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 176: -- P_Message_Table - Hxc_User_Type_Definition_Grp.Message_Table

172: --
173: -- Parameters:
174: --
175: -- IN
176: -- P_Message_Table - Hxc_User_Type_Definition_Grp.Message_Table
177: -- P_Message_Name - Fnd_New_Messages.Message_Name%TYPE
178: -- P_Message_Level - Varchar2
179: -- P_Message_Field - Varchar2
180: -- P_Msg_Tokens - Pa_Otc_Api.Message_Tokens

Line 186: -- P_Message_Table - Hxc_User_Type_Definition_Grp.Message_Table

182: -- P_Time_Attribute_Id - Hxc_Time_Attributes.Time_Attribute_Id%TYPE
183: -- P_Message_App - Varchar2 Default 'PA'
184: --
185: -- OUT
186: -- P_Message_Table - Hxc_User_Type_Definition_Grp.Message_Table
187: --
188:
189: /*-------------------------------------------------------------------------*/
190:

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

188:
189: /*-------------------------------------------------------------------------*/
190:
191: Procedure Add_Error_To_Table(
192: P_Message_Table IN OUT NOCOPY Hxc_User_Type_Definition_Grp.Message_Table, -- 2672653
193: P_Message_Name IN Fnd_New_Messages.Message_Name%TYPE,
194: P_Message_Level IN Varchar2,
195: P_Message_Field IN Varchar2,
196: P_Msg_Tokens IN Pa_Otc_Api.Message_Tokens,

Line 393: -- Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks table generated

389: -- Pre-Reqs : None
390: -- Type : Procedure
391: -- Return : n/a
392: -- Function : This procedure finds the Index located in the detail pl/sql
393: -- Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks table generated
394: -- during the generic retrieval process for the
395: -- Building_Block_Id that is passed in to it.
396: --
397: -- Parameters :

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

395: -- Building_Block_Id that is passed in to it.
396: --
397: -- Parameters :
398: -- IN
399: -- P_Detail_BB_Id - Hxc_User_Type_Definition_Grp.Resource_Id%TYPE
400: -- OUT
401: -- X_Detail_Index - Binary_Integer
402:
403: /*--------------------------------------------------------------------------*/

Line 468: -- P_Building_Blocks -- Hxc_User_Type_Definition_Grp.Timecard_Info

464: --
465: -- Parameters:
466: -- IN
467: -- P_Operation -- Varchar2
468: -- P_Building_Blocks -- Hxc_User_Type_Definition_Grp.Timecard_Info
469: -- P_Attribute_Table -- Hxc_User_Type_Definition_Grp.App_Attributes_Info
470: -- OUT
471: -- P_Building_Blocks -- Hxc_User_Type_Definition_Grp.Timecard_Info
472: -- P_Attribute_Table -- Hxc_User_Type_Definition_Grp.App_Attributes_Info

Line 469: -- P_Attribute_Table -- Hxc_User_Type_Definition_Grp.App_Attributes_Info

465: -- Parameters:
466: -- IN
467: -- P_Operation -- Varchar2
468: -- P_Building_Blocks -- Hxc_User_Type_Definition_Grp.Timecard_Info
469: -- P_Attribute_Table -- Hxc_User_Type_Definition_Grp.App_Attributes_Info
470: -- OUT
471: -- P_Building_Blocks -- Hxc_User_Type_Definition_Grp.Timecard_Info
472: -- P_Attribute_Table -- Hxc_User_Type_Definition_Grp.App_Attributes_Info
473:

Line 471: -- P_Building_Blocks -- Hxc_User_Type_Definition_Grp.Timecard_Info

467: -- P_Operation -- Varchar2
468: -- P_Building_Blocks -- Hxc_User_Type_Definition_Grp.Timecard_Info
469: -- P_Attribute_Table -- Hxc_User_Type_Definition_Grp.App_Attributes_Info
470: -- OUT
471: -- P_Building_Blocks -- Hxc_User_Type_Definition_Grp.Timecard_Info
472: -- P_Attribute_Table -- Hxc_User_Type_Definition_Grp.App_Attributes_Info
473:
474: /*------------------------------------------------------------------------- */
475:

Line 472: -- P_Attribute_Table -- Hxc_User_Type_Definition_Grp.App_Attributes_Info

468: -- P_Building_Blocks -- Hxc_User_Type_Definition_Grp.Timecard_Info
469: -- P_Attribute_Table -- Hxc_User_Type_Definition_Grp.App_Attributes_Info
470: -- OUT
471: -- P_Building_Blocks -- Hxc_User_Type_Definition_Grp.Timecard_Info
472: -- P_Attribute_Table -- Hxc_User_Type_Definition_Grp.App_Attributes_Info
473:
474: /*------------------------------------------------------------------------- */
475:
476: Procedure Update_Process(

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

474: /*------------------------------------------------------------------------- */
475:
476: Procedure Update_Process(
477: P_Operation IN Varchar2,
478: P_Building_Blocks IN OUT NOCOPY Hxc_User_Type_Definition_Grp.Timecard_Info, -- 2672653
479: P_Attribute_Table IN OUT NOCOPY Hxc_User_Type_Definition_Grp.App_Attributes_Info); -- 2672653
480:
481: -- =======================================================================
482: -- Start of Comments

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

475:
476: Procedure Update_Process(
477: P_Operation IN Varchar2,
478: P_Building_Blocks IN OUT NOCOPY Hxc_User_Type_Definition_Grp.Timecard_Info, -- 2672653
479: P_Attribute_Table IN OUT NOCOPY Hxc_User_Type_Definition_Grp.App_Attributes_Info); -- 2672653
480:
481: -- =======================================================================
482: -- Start of Comments
483: -- API Name : Validate_Otc_Data

Line 514: -- P_Building_Blocks -- Hxc_User_Type_Definition_Grp.Timecard_Info

510: --
511: -- Parameters :
512: -- IN
513: -- P_Operation -- Varchar2
514: -- P_Building_Blocks -- Hxc_User_Type_Definition_Grp.Timecard_Info
515: -- P_Attribute_Table -- Hxc_User_Type_Definition_Grp.App_Attributes_Info
516: -- OUT
517: -- P_Message_Table -- Hxc_User_Type_Definition_Grp.Message_Table
518:

Line 515: -- P_Attribute_Table -- Hxc_User_Type_Definition_Grp.App_Attributes_Info

511: -- Parameters :
512: -- IN
513: -- P_Operation -- Varchar2
514: -- P_Building_Blocks -- Hxc_User_Type_Definition_Grp.Timecard_Info
515: -- P_Attribute_Table -- Hxc_User_Type_Definition_Grp.App_Attributes_Info
516: -- OUT
517: -- P_Message_Table -- Hxc_User_Type_Definition_Grp.Message_Table
518:
519: /*------------------------------------------------------------------------- */

Line 517: -- P_Message_Table -- Hxc_User_Type_Definition_Grp.Message_Table

513: -- P_Operation -- Varchar2
514: -- P_Building_Blocks -- Hxc_User_Type_Definition_Grp.Timecard_Info
515: -- P_Attribute_Table -- Hxc_User_Type_Definition_Grp.App_Attributes_Info
516: -- OUT
517: -- P_Message_Table -- Hxc_User_Type_Definition_Grp.Message_Table
518:
519: /*------------------------------------------------------------------------- */
520:
521: Procedure Validate_Process(

Line 523: P_Building_Blocks IN Hxc_User_Type_Definition_Grp.Timecard_Info,

519: /*------------------------------------------------------------------------- */
520:
521: Procedure Validate_Process(
522: P_Operation IN Varchar2,
523: P_Building_Blocks IN Hxc_User_Type_Definition_Grp.Timecard_Info,
524: P_Attribute_Table IN Hxc_User_Type_Definition_Grp.App_Attributes_Info,
525: P_Message_Table IN OUT NOCOPY Hxc_User_Type_Definition_Grp.Message_Table); -- 2672653
526:
527:

Line 524: P_Attribute_Table IN Hxc_User_Type_Definition_Grp.App_Attributes_Info,

520:
521: Procedure Validate_Process(
522: P_Operation IN Varchar2,
523: P_Building_Blocks IN Hxc_User_Type_Definition_Grp.Timecard_Info,
524: P_Attribute_Table IN Hxc_User_Type_Definition_Grp.App_Attributes_Info,
525: P_Message_Table IN OUT NOCOPY Hxc_User_Type_Definition_Grp.Message_Table); -- 2672653
526:
527:
528: -- =======================================================================

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

521: Procedure Validate_Process(
522: P_Operation IN Varchar2,
523: P_Building_Blocks IN Hxc_User_Type_Definition_Grp.Timecard_Info,
524: P_Attribute_Table IN Hxc_User_Type_Definition_Grp.App_Attributes_Info,
525: P_Message_Table IN OUT NOCOPY Hxc_User_Type_Definition_Grp.Message_Table); -- 2672653
526:
527:
528: -- =======================================================================
529: -- Start of Comments

Line 789: -- IN P_Building_Block_Rec - Hxc_User_Type_Definition_Grp.Building_Block_Info

785: -- Function : This procedure is used to pull out the needed project specific data from
786: -- the OTC pl/sql table P_Attribute_Table.
787: --
788: -- Parameters :
789: -- IN P_Building_Block_Rec - Hxc_User_Type_Definition_Grp.Building_Block_Info
790: -- P_Building_Block - Hxc_User_Type_Definition_Grp.Timecard_Info,
791: -- P_Attribute_Table - Hxc_User_Type_Definition_Grp.App_Attributes_Info
792: -- X_Detail_Attr_Changed - Varchar2
793: -- OUT

Line 790: -- P_Building_Block - Hxc_User_Type_Definition_Grp.Timecard_Info,

786: -- the OTC pl/sql table P_Attribute_Table.
787: --
788: -- Parameters :
789: -- IN P_Building_Block_Rec - Hxc_User_Type_Definition_Grp.Building_Block_Info
790: -- P_Building_Block - Hxc_User_Type_Definition_Grp.Timecard_Info,
791: -- P_Attribute_Table - Hxc_User_Type_Definition_Grp.App_Attributes_Info
792: -- X_Detail_Attr_Changed - Varchar2
793: -- OUT
794: -- X_Detail_Attr_Changed - Varchar2

Line 791: -- P_Attribute_Table - Hxc_User_Type_Definition_Grp.App_Attributes_Info

787: --
788: -- Parameters :
789: -- IN P_Building_Block_Rec - Hxc_User_Type_Definition_Grp.Building_Block_Info
790: -- P_Building_Block - Hxc_User_Type_Definition_Grp.Timecard_Info,
791: -- P_Attribute_Table - Hxc_User_Type_Definition_Grp.App_Attributes_Info
792: -- X_Detail_Attr_Changed - Varchar2
793: -- OUT
794: -- X_Detail_Attr_Changed - Varchar2
795: -- X_Proj_Attrib_Rec - Pa_Otc_Api.Project_Attribution_Rec

Line 801: P_Building_Block_Rec IN Hxc_User_Type_Definition_Grp.Building_Block_Info,

797:
798: /*--------------------------------------------------------------------------*/
799:
800: Procedure RetrieveProjAttribution(
801: P_Building_Block_Rec IN Hxc_User_Type_Definition_Grp.Building_Block_Info,
802: P_Building_Block IN Hxc_User_Type_Definition_Grp.Timecard_Info,
803: P_Attribute_Table IN Hxc_User_Type_Definition_Grp.App_Attributes_Info,
804: X_Detail_Attr_Changed IN OUT NOCOPY Varchar2,
805: X_Proj_Attrib_Rec OUT NOCOPY Pa_Otc_Api.Project_Attribution_Rec); -- 2672653

Line 802: P_Building_Block IN Hxc_User_Type_Definition_Grp.Timecard_Info,

798: /*--------------------------------------------------------------------------*/
799:
800: Procedure RetrieveProjAttribution(
801: P_Building_Block_Rec IN Hxc_User_Type_Definition_Grp.Building_Block_Info,
802: P_Building_Block IN Hxc_User_Type_Definition_Grp.Timecard_Info,
803: P_Attribute_Table IN Hxc_User_Type_Definition_Grp.App_Attributes_Info,
804: X_Detail_Attr_Changed IN OUT NOCOPY Varchar2,
805: X_Proj_Attrib_Rec OUT NOCOPY Pa_Otc_Api.Project_Attribution_Rec); -- 2672653
806:

Line 803: P_Attribute_Table IN Hxc_User_Type_Definition_Grp.App_Attributes_Info,

799:
800: Procedure RetrieveProjAttribution(
801: P_Building_Block_Rec IN Hxc_User_Type_Definition_Grp.Building_Block_Info,
802: P_Building_Block IN Hxc_User_Type_Definition_Grp.Timecard_Info,
803: P_Attribute_Table IN Hxc_User_Type_Definition_Grp.App_Attributes_Info,
804: X_Detail_Attr_Changed IN OUT NOCOPY Varchar2,
805: X_Proj_Attrib_Rec OUT NOCOPY Pa_Otc_Api.Project_Attribution_Rec); -- 2672653
806:
807: -- ========================================================================

Line 832: P_Building_Block_Rec IN Hxc_User_Type_Definition_Grp.Building_Block_Info,

828:
829: /*--------------------------------------------------------------------------*/
830:
831: Procedure RetrieveProjAttribForUpd(
832: P_Building_Block_Rec IN Hxc_User_Type_Definition_Grp.Building_Block_Info,
833: P_Building_Block IN Hxc_User_Type_Definition_Grp.Timecard_Info,
834: P_Attribute_Table IN OUT NOCOPY Hxc_User_Type_Definition_Grp.App_Attributes_Info,
835: X_Detail_Attr_Changed IN OUT NOCOPY Varchar2,
836: X_Proj_Attrib_Rec OUT NOCOPY Pa_Otc_Api.Project_Attribution_Rec);

Line 833: P_Building_Block IN Hxc_User_Type_Definition_Grp.Timecard_Info,

829: /*--------------------------------------------------------------------------*/
830:
831: Procedure RetrieveProjAttribForUpd(
832: P_Building_Block_Rec IN Hxc_User_Type_Definition_Grp.Building_Block_Info,
833: P_Building_Block IN Hxc_User_Type_Definition_Grp.Timecard_Info,
834: P_Attribute_Table IN OUT NOCOPY Hxc_User_Type_Definition_Grp.App_Attributes_Info,
835: X_Detail_Attr_Changed IN OUT NOCOPY Varchar2,
836: X_Proj_Attrib_Rec OUT NOCOPY Pa_Otc_Api.Project_Attribution_Rec);
837:

Line 834: P_Attribute_Table IN OUT NOCOPY Hxc_User_Type_Definition_Grp.App_Attributes_Info,

830:
831: Procedure RetrieveProjAttribForUpd(
832: P_Building_Block_Rec IN Hxc_User_Type_Definition_Grp.Building_Block_Info,
833: P_Building_Block IN Hxc_User_Type_Definition_Grp.Timecard_Info,
834: P_Attribute_Table IN OUT NOCOPY Hxc_User_Type_Definition_Grp.App_Attributes_Info,
835: X_Detail_Attr_Changed IN OUT NOCOPY Varchar2,
836: X_Proj_Attrib_Rec OUT NOCOPY Pa_Otc_Api.Project_Attribution_Rec);
837:
838:

Line 886: -- P_Building_Blocks_Table - Hxc_User_Type_Definition_Grp.Timecard_Info

882: -- This procedure is only called when Mode is VALIDATE.
883: --
884: -- Parameters :
885: -- IN
886: -- P_Building_Blocks_Table - Hxc_User_Type_Definition_Grp.Timecard_Info
887: -- P_Attribute_Table - Hxc_User_Type_Definition_Grp.App_Attributes_Info
888: -- P_Message_Table - Hxc_User_Type_Definition_Grp.Message_Table
889: -- OUT
890: -- P_Message_Table - Hxc_User_Type_Definition_Grp.Message_Table

Line 887: -- P_Attribute_Table - Hxc_User_Type_Definition_Grp.App_Attributes_Info

883: --
884: -- Parameters :
885: -- IN
886: -- P_Building_Blocks_Table - Hxc_User_Type_Definition_Grp.Timecard_Info
887: -- P_Attribute_Table - Hxc_User_Type_Definition_Grp.App_Attributes_Info
888: -- P_Message_Table - Hxc_User_Type_Definition_Grp.Message_Table
889: -- OUT
890: -- P_Message_Table - Hxc_User_Type_Definition_Grp.Message_Table
891: -- X_TimeBB_Id - Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE

Line 888: -- P_Message_Table - Hxc_User_Type_Definition_Grp.Message_Table

884: -- Parameters :
885: -- IN
886: -- P_Building_Blocks_Table - Hxc_User_Type_Definition_Grp.Timecard_Info
887: -- P_Attribute_Table - Hxc_User_Type_Definition_Grp.App_Attributes_Info
888: -- P_Message_Table - Hxc_User_Type_Definition_Grp.Message_Table
889: -- OUT
890: -- P_Message_Table - Hxc_User_Type_Definition_Grp.Message_Table
891: -- X_TimeBB_Id - Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE
892: -- X_Ovr_Approver_Person_Id - Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE

Line 890: -- P_Message_Table - Hxc_User_Type_Definition_Grp.Message_Table

886: -- P_Building_Blocks_Table - Hxc_User_Type_Definition_Grp.Timecard_Info
887: -- P_Attribute_Table - Hxc_User_Type_Definition_Grp.App_Attributes_Info
888: -- P_Message_Table - Hxc_User_Type_Definition_Grp.Message_Table
889: -- OUT
890: -- P_Message_Table - Hxc_User_Type_Definition_Grp.Message_Table
891: -- X_TimeBB_Id - Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE
892: -- X_Ovr_Approver_Person_Id - Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE
893: -- X_Pass_Val_Flag - Varchar2
894: -- X_Approval_Status - Hxc_Time_Building_Blocks.Approval_Status%TYPE

Line 900: P_Building_Blocks_Table IN Hxc_User_Type_Definition_Grp.Timecard_Info,

896: /*--------------------------------------------------------------------------*/
897:
898:
899: Procedure FindandValidateHeader(
900: P_Building_Blocks_Table IN Hxc_User_Type_Definition_Grp.Timecard_Info,
901: P_Attribute_Table IN Hxc_User_Type_Definition_Grp.App_Attributes_Info,
902: P_Message_Table IN OUT NOCOPY Hxc_User_Type_Definition_Grp.Message_Table,-- 2672653
903: X_TimeBB_Id OUT NOCOPY Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE,
904: X_Ovr_Approver_Person_Id OUT NOCOPY Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE,

Line 901: P_Attribute_Table IN Hxc_User_Type_Definition_Grp.App_Attributes_Info,

897:
898:
899: Procedure FindandValidateHeader(
900: P_Building_Blocks_Table IN Hxc_User_Type_Definition_Grp.Timecard_Info,
901: P_Attribute_Table IN Hxc_User_Type_Definition_Grp.App_Attributes_Info,
902: P_Message_Table IN OUT NOCOPY Hxc_User_Type_Definition_Grp.Message_Table,-- 2672653
903: X_TimeBB_Id OUT NOCOPY Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE,
904: X_Ovr_Approver_Person_Id OUT NOCOPY Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE,
905: X_Pass_Val_Flag OUT NOCOPY Varchar2,

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

898:
899: Procedure FindandValidateHeader(
900: P_Building_Blocks_Table IN Hxc_User_Type_Definition_Grp.Timecard_Info,
901: P_Attribute_Table IN Hxc_User_Type_Definition_Grp.App_Attributes_Info,
902: P_Message_Table IN OUT NOCOPY Hxc_User_Type_Definition_Grp.Message_Table,-- 2672653
903: X_TimeBB_Id OUT NOCOPY Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE,
904: X_Ovr_Approver_Person_Id OUT NOCOPY Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE,
905: X_Pass_Val_Flag OUT NOCOPY Varchar2,
906: X_Approval_Status OUT NOCOPY Hxc_Time_Building_Blocks.Approval_Status%TYPE);