eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_OTC_API dependencies on HXC_USER_TYPE_DEFINITION_GRP

Line 159: -- P_Message_Table - Hxc_User_Type_Definition_Grp.Message_Table

155: --
156: -- Parameters:
157: --
158: -- IN
159: -- P_Message_Table - Hxc_User_Type_Definition_Grp.Message_Table
160: -- P_Message_Name - Fnd_New_Messages.Message_Name%TYPE
161: -- P_Message_Level - Varchar2
162: -- P_Message_Field - Varchar2
163: -- P_Msg_Tokens - Pa_Otc_Api.Message_Tokens

Line 169: -- P_Message_Table - Hxc_User_Type_Definition_Grp.Message_Table

165: -- P_Time_Attribute_Id - Hxc_Time_Attributes.Time_Attribute_Id%TYPE
166: -- P_Message_App - Varchar2 Default 'PA'
167: --
168: -- OUT
169: -- P_Message_Table - Hxc_User_Type_Definition_Grp.Message_Table
170: --
171:
172: /*-------------------------------------------------------------------------*/
173:

Line 175: P_Message_Table IN OUT NOCOPY Hxc_User_Type_Definition_Grp.Message_Table, -- 2672653

171:
172: /*-------------------------------------------------------------------------*/
173:
174: Procedure Add_Error_To_Table(
175: P_Message_Table IN OUT NOCOPY Hxc_User_Type_Definition_Grp.Message_Table, -- 2672653
176: P_Message_Name IN Fnd_New_Messages.Message_Name%TYPE,
177: P_Message_Level IN Varchar2,
178: P_Message_Field IN Varchar2,
179: P_Msg_Tokens IN Pa_Otc_Api.Message_Tokens,

Line 376: -- Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks table generated

372: -- Pre-Reqs : None
373: -- Type : Procedure
374: -- Return : n/a
375: -- Function : This procedure finds the Index located in the detail pl/sql
376: -- Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks table generated
377: -- during the generic retrieval process for the
378: -- Building_Block_Id that is passed in to it.
379: --
380: -- Parameters :

Line 382: -- P_Detail_BB_Id - Hxc_User_Type_Definition_Grp.Resource_Id%TYPE

378: -- Building_Block_Id that is passed in to it.
379: --
380: -- Parameters :
381: -- IN
382: -- P_Detail_BB_Id - Hxc_User_Type_Definition_Grp.Resource_Id%TYPE
383: -- OUT
384: -- X_Detail_Index - Binary_Integer
385:
386: /*--------------------------------------------------------------------------*/

Line 451: -- P_Building_Blocks -- Hxc_User_Type_Definition_Grp.Timecard_Info

447: --
448: -- Parameters:
449: -- IN
450: -- P_Operation -- Varchar2
451: -- P_Building_Blocks -- Hxc_User_Type_Definition_Grp.Timecard_Info
452: -- P_Attribute_Table -- Hxc_User_Type_Definition_Grp.App_Attributes_Info
453: -- OUT
454: -- P_Building_Blocks -- Hxc_User_Type_Definition_Grp.Timecard_Info
455: -- P_Attribute_Table -- Hxc_User_Type_Definition_Grp.App_Attributes_Info

Line 452: -- P_Attribute_Table -- Hxc_User_Type_Definition_Grp.App_Attributes_Info

448: -- Parameters:
449: -- IN
450: -- P_Operation -- Varchar2
451: -- P_Building_Blocks -- Hxc_User_Type_Definition_Grp.Timecard_Info
452: -- P_Attribute_Table -- Hxc_User_Type_Definition_Grp.App_Attributes_Info
453: -- OUT
454: -- P_Building_Blocks -- Hxc_User_Type_Definition_Grp.Timecard_Info
455: -- P_Attribute_Table -- Hxc_User_Type_Definition_Grp.App_Attributes_Info
456:

Line 454: -- P_Building_Blocks -- Hxc_User_Type_Definition_Grp.Timecard_Info

450: -- P_Operation -- Varchar2
451: -- P_Building_Blocks -- Hxc_User_Type_Definition_Grp.Timecard_Info
452: -- P_Attribute_Table -- Hxc_User_Type_Definition_Grp.App_Attributes_Info
453: -- OUT
454: -- P_Building_Blocks -- Hxc_User_Type_Definition_Grp.Timecard_Info
455: -- P_Attribute_Table -- Hxc_User_Type_Definition_Grp.App_Attributes_Info
456:
457: /*------------------------------------------------------------------------- */
458:

Line 455: -- P_Attribute_Table -- Hxc_User_Type_Definition_Grp.App_Attributes_Info

451: -- P_Building_Blocks -- Hxc_User_Type_Definition_Grp.Timecard_Info
452: -- P_Attribute_Table -- Hxc_User_Type_Definition_Grp.App_Attributes_Info
453: -- OUT
454: -- P_Building_Blocks -- Hxc_User_Type_Definition_Grp.Timecard_Info
455: -- P_Attribute_Table -- Hxc_User_Type_Definition_Grp.App_Attributes_Info
456:
457: /*------------------------------------------------------------------------- */
458:
459: Procedure Update_Process(

Line 461: P_Building_Blocks IN OUT NOCOPY Hxc_User_Type_Definition_Grp.Timecard_Info, -- 2672653

457: /*------------------------------------------------------------------------- */
458:
459: Procedure Update_Process(
460: P_Operation IN Varchar2,
461: P_Building_Blocks IN OUT NOCOPY Hxc_User_Type_Definition_Grp.Timecard_Info, -- 2672653
462: P_Attribute_Table IN OUT NOCOPY Hxc_User_Type_Definition_Grp.App_Attributes_Info); -- 2672653
463:
464: -- =======================================================================
465: -- Start of Comments

Line 462: P_Attribute_Table IN OUT NOCOPY Hxc_User_Type_Definition_Grp.App_Attributes_Info); -- 2672653

458:
459: Procedure Update_Process(
460: P_Operation IN Varchar2,
461: P_Building_Blocks IN OUT NOCOPY Hxc_User_Type_Definition_Grp.Timecard_Info, -- 2672653
462: P_Attribute_Table IN OUT NOCOPY Hxc_User_Type_Definition_Grp.App_Attributes_Info); -- 2672653
463:
464: -- =======================================================================
465: -- Start of Comments
466: -- API Name : Validate_Otc_Data

Line 497: -- P_Building_Blocks -- Hxc_User_Type_Definition_Grp.Timecard_Info

493: --
494: -- Parameters :
495: -- IN
496: -- P_Operation -- Varchar2
497: -- P_Building_Blocks -- Hxc_User_Type_Definition_Grp.Timecard_Info
498: -- P_Attribute_Table -- Hxc_User_Type_Definition_Grp.App_Attributes_Info
499: -- OUT
500: -- P_Message_Table -- Hxc_User_Type_Definition_Grp.Message_Table
501:

Line 498: -- P_Attribute_Table -- Hxc_User_Type_Definition_Grp.App_Attributes_Info

494: -- Parameters :
495: -- IN
496: -- P_Operation -- Varchar2
497: -- P_Building_Blocks -- Hxc_User_Type_Definition_Grp.Timecard_Info
498: -- P_Attribute_Table -- Hxc_User_Type_Definition_Grp.App_Attributes_Info
499: -- OUT
500: -- P_Message_Table -- Hxc_User_Type_Definition_Grp.Message_Table
501:
502: /*------------------------------------------------------------------------- */

Line 500: -- P_Message_Table -- Hxc_User_Type_Definition_Grp.Message_Table

496: -- P_Operation -- Varchar2
497: -- P_Building_Blocks -- Hxc_User_Type_Definition_Grp.Timecard_Info
498: -- P_Attribute_Table -- Hxc_User_Type_Definition_Grp.App_Attributes_Info
499: -- OUT
500: -- P_Message_Table -- Hxc_User_Type_Definition_Grp.Message_Table
501:
502: /*------------------------------------------------------------------------- */
503:
504: Procedure Validate_Process(

Line 506: P_Building_Blocks IN Hxc_User_Type_Definition_Grp.Timecard_Info,

502: /*------------------------------------------------------------------------- */
503:
504: Procedure Validate_Process(
505: P_Operation IN Varchar2,
506: P_Building_Blocks IN Hxc_User_Type_Definition_Grp.Timecard_Info,
507: P_Attribute_Table IN Hxc_User_Type_Definition_Grp.App_Attributes_Info,
508: P_Message_Table IN OUT NOCOPY Hxc_User_Type_Definition_Grp.Message_Table); -- 2672653
509:
510:

Line 507: P_Attribute_Table IN Hxc_User_Type_Definition_Grp.App_Attributes_Info,

503:
504: Procedure Validate_Process(
505: P_Operation IN Varchar2,
506: P_Building_Blocks IN Hxc_User_Type_Definition_Grp.Timecard_Info,
507: P_Attribute_Table IN Hxc_User_Type_Definition_Grp.App_Attributes_Info,
508: P_Message_Table IN OUT NOCOPY Hxc_User_Type_Definition_Grp.Message_Table); -- 2672653
509:
510:
511: -- =======================================================================

Line 508: P_Message_Table IN OUT NOCOPY Hxc_User_Type_Definition_Grp.Message_Table); -- 2672653

504: Procedure Validate_Process(
505: P_Operation IN Varchar2,
506: P_Building_Blocks IN Hxc_User_Type_Definition_Grp.Timecard_Info,
507: P_Attribute_Table IN Hxc_User_Type_Definition_Grp.App_Attributes_Info,
508: P_Message_Table IN OUT NOCOPY Hxc_User_Type_Definition_Grp.Message_Table); -- 2672653
509:
510:
511: -- =======================================================================
512: -- Start of Comments

Line 754: -- IN P_Building_Block_Rec - Hxc_User_Type_Definition_Grp.Building_Block_Info

750: -- Function : This procedure is used to pull out the needed project specific data from
751: -- the OTC pl/sql table P_Attribute_Table.
752: --
753: -- Parameters :
754: -- IN P_Building_Block_Rec - Hxc_User_Type_Definition_Grp.Building_Block_Info
755: -- P_Building_Block - Hxc_User_Type_Definition_Grp.Timecard_Info,
756: -- P_Attribute_Table - Hxc_User_Type_Definition_Grp.App_Attributes_Info
757: -- X_Detail_Attr_Changed - Varchar2
758: -- OUT

Line 755: -- P_Building_Block - Hxc_User_Type_Definition_Grp.Timecard_Info,

751: -- the OTC pl/sql table P_Attribute_Table.
752: --
753: -- Parameters :
754: -- IN P_Building_Block_Rec - Hxc_User_Type_Definition_Grp.Building_Block_Info
755: -- P_Building_Block - Hxc_User_Type_Definition_Grp.Timecard_Info,
756: -- P_Attribute_Table - Hxc_User_Type_Definition_Grp.App_Attributes_Info
757: -- X_Detail_Attr_Changed - Varchar2
758: -- OUT
759: -- X_Detail_Attr_Changed - Varchar2

Line 756: -- P_Attribute_Table - Hxc_User_Type_Definition_Grp.App_Attributes_Info

752: --
753: -- Parameters :
754: -- IN P_Building_Block_Rec - Hxc_User_Type_Definition_Grp.Building_Block_Info
755: -- P_Building_Block - Hxc_User_Type_Definition_Grp.Timecard_Info,
756: -- P_Attribute_Table - Hxc_User_Type_Definition_Grp.App_Attributes_Info
757: -- X_Detail_Attr_Changed - Varchar2
758: -- OUT
759: -- X_Detail_Attr_Changed - Varchar2
760: -- X_Proj_Attrib_Rec - Pa_Otc_Api.Project_Attribution_Rec

Line 766: P_Building_Block_Rec IN Hxc_User_Type_Definition_Grp.Building_Block_Info,

762:
763: /*--------------------------------------------------------------------------*/
764:
765: Procedure RetrieveProjAttribution(
766: P_Building_Block_Rec IN Hxc_User_Type_Definition_Grp.Building_Block_Info,
767: P_Building_Block IN Hxc_User_Type_Definition_Grp.Timecard_Info,
768: P_Attribute_Table IN Hxc_User_Type_Definition_Grp.App_Attributes_Info,
769: X_Detail_Attr_Changed IN OUT NOCOPY Varchar2,
770: X_Proj_Attrib_Rec OUT NOCOPY Pa_Otc_Api.Project_Attribution_Rec); -- 2672653

Line 767: P_Building_Block IN Hxc_User_Type_Definition_Grp.Timecard_Info,

763: /*--------------------------------------------------------------------------*/
764:
765: Procedure RetrieveProjAttribution(
766: P_Building_Block_Rec IN Hxc_User_Type_Definition_Grp.Building_Block_Info,
767: P_Building_Block IN Hxc_User_Type_Definition_Grp.Timecard_Info,
768: P_Attribute_Table IN Hxc_User_Type_Definition_Grp.App_Attributes_Info,
769: X_Detail_Attr_Changed IN OUT NOCOPY Varchar2,
770: X_Proj_Attrib_Rec OUT NOCOPY Pa_Otc_Api.Project_Attribution_Rec); -- 2672653
771:

Line 768: P_Attribute_Table IN Hxc_User_Type_Definition_Grp.App_Attributes_Info,

764:
765: Procedure RetrieveProjAttribution(
766: P_Building_Block_Rec IN Hxc_User_Type_Definition_Grp.Building_Block_Info,
767: P_Building_Block IN Hxc_User_Type_Definition_Grp.Timecard_Info,
768: P_Attribute_Table IN Hxc_User_Type_Definition_Grp.App_Attributes_Info,
769: X_Detail_Attr_Changed IN OUT NOCOPY Varchar2,
770: X_Proj_Attrib_Rec OUT NOCOPY Pa_Otc_Api.Project_Attribution_Rec); -- 2672653
771:
772: -- ========================================================================

Line 797: P_Building_Block_Rec IN Hxc_User_Type_Definition_Grp.Building_Block_Info,

793:
794: /*--------------------------------------------------------------------------*/
795:
796: Procedure RetrieveProjAttribForUpd(
797: P_Building_Block_Rec IN Hxc_User_Type_Definition_Grp.Building_Block_Info,
798: P_Building_Block IN Hxc_User_Type_Definition_Grp.Timecard_Info,
799: P_Attribute_Table IN OUT NOCOPY Hxc_User_Type_Definition_Grp.App_Attributes_Info,
800: X_Detail_Attr_Changed IN OUT NOCOPY Varchar2,
801: X_Proj_Attrib_Rec OUT NOCOPY Pa_Otc_Api.Project_Attribution_Rec);

Line 798: P_Building_Block IN Hxc_User_Type_Definition_Grp.Timecard_Info,

794: /*--------------------------------------------------------------------------*/
795:
796: Procedure RetrieveProjAttribForUpd(
797: P_Building_Block_Rec IN Hxc_User_Type_Definition_Grp.Building_Block_Info,
798: P_Building_Block IN Hxc_User_Type_Definition_Grp.Timecard_Info,
799: P_Attribute_Table IN OUT NOCOPY Hxc_User_Type_Definition_Grp.App_Attributes_Info,
800: X_Detail_Attr_Changed IN OUT NOCOPY Varchar2,
801: X_Proj_Attrib_Rec OUT NOCOPY Pa_Otc_Api.Project_Attribution_Rec);
802:

Line 799: P_Attribute_Table IN OUT NOCOPY Hxc_User_Type_Definition_Grp.App_Attributes_Info,

795:
796: Procedure RetrieveProjAttribForUpd(
797: P_Building_Block_Rec IN Hxc_User_Type_Definition_Grp.Building_Block_Info,
798: P_Building_Block IN Hxc_User_Type_Definition_Grp.Timecard_Info,
799: P_Attribute_Table IN OUT NOCOPY Hxc_User_Type_Definition_Grp.App_Attributes_Info,
800: X_Detail_Attr_Changed IN OUT NOCOPY Varchar2,
801: X_Proj_Attrib_Rec OUT NOCOPY Pa_Otc_Api.Project_Attribution_Rec);
802:
803:

Line 851: -- P_Building_Blocks_Table - Hxc_User_Type_Definition_Grp.Timecard_Info

847: -- This procedure is only called when Mode is VALIDATE.
848: --
849: -- Parameters :
850: -- IN
851: -- P_Building_Blocks_Table - Hxc_User_Type_Definition_Grp.Timecard_Info
852: -- P_Attribute_Table - Hxc_User_Type_Definition_Grp.App_Attributes_Info
853: -- P_Message_Table - Hxc_User_Type_Definition_Grp.Message_Table
854: -- OUT
855: -- P_Message_Table - Hxc_User_Type_Definition_Grp.Message_Table

Line 852: -- P_Attribute_Table - Hxc_User_Type_Definition_Grp.App_Attributes_Info

848: --
849: -- Parameters :
850: -- IN
851: -- P_Building_Blocks_Table - Hxc_User_Type_Definition_Grp.Timecard_Info
852: -- P_Attribute_Table - Hxc_User_Type_Definition_Grp.App_Attributes_Info
853: -- P_Message_Table - Hxc_User_Type_Definition_Grp.Message_Table
854: -- OUT
855: -- P_Message_Table - Hxc_User_Type_Definition_Grp.Message_Table
856: -- X_TimeBB_Id - Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE

Line 853: -- P_Message_Table - Hxc_User_Type_Definition_Grp.Message_Table

849: -- Parameters :
850: -- IN
851: -- P_Building_Blocks_Table - Hxc_User_Type_Definition_Grp.Timecard_Info
852: -- P_Attribute_Table - Hxc_User_Type_Definition_Grp.App_Attributes_Info
853: -- P_Message_Table - Hxc_User_Type_Definition_Grp.Message_Table
854: -- OUT
855: -- P_Message_Table - Hxc_User_Type_Definition_Grp.Message_Table
856: -- X_TimeBB_Id - Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE
857: -- X_Ovr_Approver_Person_Id - Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE

Line 855: -- P_Message_Table - Hxc_User_Type_Definition_Grp.Message_Table

851: -- P_Building_Blocks_Table - Hxc_User_Type_Definition_Grp.Timecard_Info
852: -- P_Attribute_Table - Hxc_User_Type_Definition_Grp.App_Attributes_Info
853: -- P_Message_Table - Hxc_User_Type_Definition_Grp.Message_Table
854: -- OUT
855: -- P_Message_Table - Hxc_User_Type_Definition_Grp.Message_Table
856: -- X_TimeBB_Id - Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE
857: -- X_Ovr_Approver_Person_Id - Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE
858: -- X_Pass_Val_Flag - Varchar2
859: -- X_Approval_Status - Hxc_Time_Building_Blocks.Approval_Status%TYPE

Line 865: P_Building_Blocks_Table IN Hxc_User_Type_Definition_Grp.Timecard_Info,

861: /*--------------------------------------------------------------------------*/
862:
863:
864: Procedure FindandValidateHeader(
865: P_Building_Blocks_Table IN Hxc_User_Type_Definition_Grp.Timecard_Info,
866: P_Attribute_Table IN Hxc_User_Type_Definition_Grp.App_Attributes_Info,
867: P_Message_Table IN OUT NOCOPY Hxc_User_Type_Definition_Grp.Message_Table,-- 2672653
868: X_TimeBB_Id OUT NOCOPY Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE,
869: X_Ovr_Approver_Person_Id OUT NOCOPY Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE,

Line 866: P_Attribute_Table IN Hxc_User_Type_Definition_Grp.App_Attributes_Info,

862:
863:
864: Procedure FindandValidateHeader(
865: P_Building_Blocks_Table IN Hxc_User_Type_Definition_Grp.Timecard_Info,
866: P_Attribute_Table IN Hxc_User_Type_Definition_Grp.App_Attributes_Info,
867: P_Message_Table IN OUT NOCOPY Hxc_User_Type_Definition_Grp.Message_Table,-- 2672653
868: X_TimeBB_Id OUT NOCOPY Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE,
869: X_Ovr_Approver_Person_Id OUT NOCOPY Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE,
870: X_Pass_Val_Flag OUT NOCOPY Varchar2,

Line 867: P_Message_Table IN OUT NOCOPY Hxc_User_Type_Definition_Grp.Message_Table,-- 2672653

863:
864: Procedure FindandValidateHeader(
865: P_Building_Blocks_Table IN Hxc_User_Type_Definition_Grp.Timecard_Info,
866: P_Attribute_Table IN Hxc_User_Type_Definition_Grp.App_Attributes_Info,
867: P_Message_Table IN OUT NOCOPY Hxc_User_Type_Definition_Grp.Message_Table,-- 2672653
868: X_TimeBB_Id OUT NOCOPY Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE,
869: X_Ovr_Approver_Person_Id OUT NOCOPY Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE,
870: X_Pass_Val_Flag OUT NOCOPY Varchar2,
871: X_Approval_Status OUT NOCOPY Hxc_Time_Building_Blocks.Approval_Status%TYPE);