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 235: -- P_Message_Table - Hxc_User_Type_Definition_Grp.Message_Table%TYPE

231: --
232: -- Parameters:
233: --
234: -- IN
235: -- P_Message_Table - Hxc_User_Type_Definition_Grp.Message_Table%TYPE
236: -- P_Message_Name - Fnd_New_Messages.Message_Name%TYPE
237: -- P_Message_Level - Varchar2
238: -- P_Message_Field - Varchar2
239: -- P_Msg_Tokens - Pa_Otc_Api.Messages_Tokens

Line 245: -- P_Message_Table - Hxc_User_Type_Definition_Grp.Message_Table%TYPE

241: -- P_Time_Attribute_Id - Hxc_Time_Attributes.Time_Attribute_Id%TYPE
242: -- P_Message_App - Varchar2 Default 'PA'
243: --
244: -- OUT
245: -- P_Message_Table - Hxc_User_Type_Definition_Grp.Message_Table%TYPE
246: --
247:
248: /*-------------------------------------------------------------------------*/
249:

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

247:
248: /*-------------------------------------------------------------------------*/
249:
250: Procedure Add_Error_To_Table(
251: P_Message_Table IN OUT NOCOPY Hxc_User_Type_Definition_Grp.Message_Table, -- 2672653
252: P_Message_Name IN Fnd_New_Messages.Message_Name%TYPE,
253: P_Message_Level IN Varchar2,
254: P_Message_Field IN Varchar2,
255: P_Msg_Tokens IN Pa_Otc_Api.Message_Tokens,

Line 498: * Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks Using

494:
495: /* Pull the data into the OTL pl/sql tables.
496: *
497: * PL/SQL tables to work with once the procedure execute_retrieval_process is done:
498: * Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks Using
499: * Hxc_User_Type_Definition_Grp.T_Old_Detail_Bld_Blks Using
500: * Hxc_User_Type_Definition_Grp.T_Detail_Attributes Using
501: * Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes Using
502: * Hxc_User_Type_Definition_Grp.T_Day_Bld_Blks Using for ei date retrieval

Line 499: * Hxc_User_Type_Definition_Grp.T_Old_Detail_Bld_Blks Using

495: /* Pull the data into the OTL pl/sql tables.
496: *
497: * PL/SQL tables to work with once the procedure execute_retrieval_process is done:
498: * Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks Using
499: * Hxc_User_Type_Definition_Grp.T_Old_Detail_Bld_Blks Using
500: * Hxc_User_Type_Definition_Grp.T_Detail_Attributes Using
501: * Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes Using
502: * Hxc_User_Type_Definition_Grp.T_Day_Bld_Blks Using for ei date retrieval
503: * Hxc_User_Type_Definition_Grp.T_Old_Day_Bld_Blks Using for ei date retrieval

Line 500: * Hxc_User_Type_Definition_Grp.T_Detail_Attributes Using

496: *
497: * PL/SQL tables to work with once the procedure execute_retrieval_process is done:
498: * Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks Using
499: * Hxc_User_Type_Definition_Grp.T_Old_Detail_Bld_Blks Using
500: * Hxc_User_Type_Definition_Grp.T_Detail_Attributes Using
501: * Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes Using
502: * Hxc_User_Type_Definition_Grp.T_Day_Bld_Blks Using for ei date retrieval
503: * Hxc_User_Type_Definition_Grp.T_Old_Day_Bld_Blks Using for ei date retrieval
504: * Hxc_User_Type_Definition_Grp.T_Day_Attributes Not Using

Line 501: * Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes Using

497: * PL/SQL tables to work with once the procedure execute_retrieval_process is done:
498: * Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks Using
499: * Hxc_User_Type_Definition_Grp.T_Old_Detail_Bld_Blks Using
500: * Hxc_User_Type_Definition_Grp.T_Detail_Attributes Using
501: * Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes Using
502: * Hxc_User_Type_Definition_Grp.T_Day_Bld_Blks Using for ei date retrieval
503: * Hxc_User_Type_Definition_Grp.T_Old_Day_Bld_Blks Using for ei date retrieval
504: * Hxc_User_Type_Definition_Grp.T_Day_Attributes Not Using
505: * Hxc_User_Type_Definition_Grp.T_Old_Day_Attributes Not Using

Line 502: * Hxc_User_Type_Definition_Grp.T_Day_Bld_Blks Using for ei date retrieval

498: * Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks Using
499: * Hxc_User_Type_Definition_Grp.T_Old_Detail_Bld_Blks Using
500: * Hxc_User_Type_Definition_Grp.T_Detail_Attributes Using
501: * Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes Using
502: * Hxc_User_Type_Definition_Grp.T_Day_Bld_Blks Using for ei date retrieval
503: * Hxc_User_Type_Definition_Grp.T_Old_Day_Bld_Blks Using for ei date retrieval
504: * Hxc_User_Type_Definition_Grp.T_Day_Attributes Not Using
505: * Hxc_User_Type_Definition_Grp.T_Old_Day_Attributes Not Using
506: * Hxc_User_Type_Definition_Grp.T_Time_Bld_Blks Not Using

Line 503: * Hxc_User_Type_Definition_Grp.T_Old_Day_Bld_Blks Using for ei date retrieval

499: * Hxc_User_Type_Definition_Grp.T_Old_Detail_Bld_Blks Using
500: * Hxc_User_Type_Definition_Grp.T_Detail_Attributes Using
501: * Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes Using
502: * Hxc_User_Type_Definition_Grp.T_Day_Bld_Blks Using for ei date retrieval
503: * Hxc_User_Type_Definition_Grp.T_Old_Day_Bld_Blks Using for ei date retrieval
504: * Hxc_User_Type_Definition_Grp.T_Day_Attributes Not Using
505: * Hxc_User_Type_Definition_Grp.T_Old_Day_Attributes Not Using
506: * Hxc_User_Type_Definition_Grp.T_Time_Bld_Blks Not Using
507: * Hxc_User_Type_Definition_Grp.T_Old_Time_Bld_Blks Not Using

Line 504: * Hxc_User_Type_Definition_Grp.T_Day_Attributes Not Using

500: * Hxc_User_Type_Definition_Grp.T_Detail_Attributes Using
501: * Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes Using
502: * Hxc_User_Type_Definition_Grp.T_Day_Bld_Blks Using for ei date retrieval
503: * Hxc_User_Type_Definition_Grp.T_Old_Day_Bld_Blks Using for ei date retrieval
504: * Hxc_User_Type_Definition_Grp.T_Day_Attributes Not Using
505: * Hxc_User_Type_Definition_Grp.T_Old_Day_Attributes Not Using
506: * Hxc_User_Type_Definition_Grp.T_Time_Bld_Blks Not Using
507: * Hxc_User_Type_Definition_Grp.T_Old_Time_Bld_Blks Not Using
508: * Hxc_User_Type_Definition_Grp.T_Time_Attributes Not Using

Line 505: * Hxc_User_Type_Definition_Grp.T_Old_Day_Attributes Not Using

501: * Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes Using
502: * Hxc_User_Type_Definition_Grp.T_Day_Bld_Blks Using for ei date retrieval
503: * Hxc_User_Type_Definition_Grp.T_Old_Day_Bld_Blks Using for ei date retrieval
504: * Hxc_User_Type_Definition_Grp.T_Day_Attributes Not Using
505: * Hxc_User_Type_Definition_Grp.T_Old_Day_Attributes Not Using
506: * Hxc_User_Type_Definition_Grp.T_Time_Bld_Blks Not Using
507: * Hxc_User_Type_Definition_Grp.T_Old_Time_Bld_Blks Not Using
508: * Hxc_User_Type_Definition_Grp.T_Time_Attributes Not Using
509: * Hxc_User_Type_Definition_Grp.T_Old_Time_Attributes Not Using

Line 506: * Hxc_User_Type_Definition_Grp.T_Time_Bld_Blks Not Using

502: * Hxc_User_Type_Definition_Grp.T_Day_Bld_Blks Using for ei date retrieval
503: * Hxc_User_Type_Definition_Grp.T_Old_Day_Bld_Blks Using for ei date retrieval
504: * Hxc_User_Type_Definition_Grp.T_Day_Attributes Not Using
505: * Hxc_User_Type_Definition_Grp.T_Old_Day_Attributes Not Using
506: * Hxc_User_Type_Definition_Grp.T_Time_Bld_Blks Not Using
507: * Hxc_User_Type_Definition_Grp.T_Old_Time_Bld_Blks Not Using
508: * Hxc_User_Type_Definition_Grp.T_Time_Attributes Not Using
509: * Hxc_User_Type_Definition_Grp.T_Old_Time_Attributes Not Using
510: * Hxc_User_Type_Definition_Grp.T_Tx_Detail_Status Using

Line 507: * Hxc_User_Type_Definition_Grp.T_Old_Time_Bld_Blks Not Using

503: * Hxc_User_Type_Definition_Grp.T_Old_Day_Bld_Blks Using for ei date retrieval
504: * Hxc_User_Type_Definition_Grp.T_Day_Attributes Not Using
505: * Hxc_User_Type_Definition_Grp.T_Old_Day_Attributes Not Using
506: * Hxc_User_Type_Definition_Grp.T_Time_Bld_Blks Not Using
507: * Hxc_User_Type_Definition_Grp.T_Old_Time_Bld_Blks Not Using
508: * Hxc_User_Type_Definition_Grp.T_Time_Attributes Not Using
509: * Hxc_User_Type_Definition_Grp.T_Old_Time_Attributes Not Using
510: * Hxc_User_Type_Definition_Grp.T_Tx_Detail_Status Using
511: * Hxc_User_Type_Definition_Grp.T_Tx_Detail_Exception Using

Line 508: * Hxc_User_Type_Definition_Grp.T_Time_Attributes Not Using

504: * Hxc_User_Type_Definition_Grp.T_Day_Attributes Not Using
505: * Hxc_User_Type_Definition_Grp.T_Old_Day_Attributes Not Using
506: * Hxc_User_Type_Definition_Grp.T_Time_Bld_Blks Not Using
507: * Hxc_User_Type_Definition_Grp.T_Old_Time_Bld_Blks Not Using
508: * Hxc_User_Type_Definition_Grp.T_Time_Attributes Not Using
509: * Hxc_User_Type_Definition_Grp.T_Old_Time_Attributes Not Using
510: * Hxc_User_Type_Definition_Grp.T_Tx_Detail_Status Using
511: * Hxc_User_Type_Definition_Grp.T_Tx_Detail_Exception Using
512: */

Line 509: * Hxc_User_Type_Definition_Grp.T_Old_Time_Attributes Not Using

505: * Hxc_User_Type_Definition_Grp.T_Old_Day_Attributes Not Using
506: * Hxc_User_Type_Definition_Grp.T_Time_Bld_Blks Not Using
507: * Hxc_User_Type_Definition_Grp.T_Old_Time_Bld_Blks Not Using
508: * Hxc_User_Type_Definition_Grp.T_Time_Attributes Not Using
509: * Hxc_User_Type_Definition_Grp.T_Old_Time_Attributes Not Using
510: * Hxc_User_Type_Definition_Grp.T_Tx_Detail_Status Using
511: * Hxc_User_Type_Definition_Grp.T_Tx_Detail_Exception Using
512: */
513:

Line 510: * Hxc_User_Type_Definition_Grp.T_Tx_Detail_Status Using

506: * Hxc_User_Type_Definition_Grp.T_Time_Bld_Blks Not Using
507: * Hxc_User_Type_Definition_Grp.T_Old_Time_Bld_Blks Not Using
508: * Hxc_User_Type_Definition_Grp.T_Time_Attributes Not Using
509: * Hxc_User_Type_Definition_Grp.T_Old_Time_Attributes Not Using
510: * Hxc_User_Type_Definition_Grp.T_Tx_Detail_Status Using
511: * Hxc_User_Type_Definition_Grp.T_Tx_Detail_Exception Using
512: */
513:
514: G_Stage := 'Call execute retrieval process API.';

Line 511: * Hxc_User_Type_Definition_Grp.T_Tx_Detail_Exception Using

507: * Hxc_User_Type_Definition_Grp.T_Old_Time_Bld_Blks Not Using
508: * Hxc_User_Type_Definition_Grp.T_Time_Attributes Not Using
509: * Hxc_User_Type_Definition_Grp.T_Old_Time_Attributes Not Using
510: * Hxc_User_Type_Definition_Grp.T_Tx_Detail_Status Using
511: * Hxc_User_Type_Definition_Grp.T_Tx_Detail_Exception Using
512: */
513:
514: G_Stage := 'Call execute retrieval process API.';
515: If G_Debug_Mode = 'Y' Then

Line 530: If Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks.COUNT > 0 Then

526: P_Where_Clause => l_Where_Clause,
527: P_Scope => 'DAY',
528: P_Clusive => 'EX');
529:
530: If Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks.COUNT > 0 Then
531:
532: Pa_Trx_Import.G_Exit_Main := FALSE;
533:
534: G_Stage := 'Loop thru all hxc detail building block records.';

Line 539: For i IN Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks.First .. Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks.Last

535: If G_Debug_Mode = 'Y' Then
536: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
537: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
538: End If;
539: For i IN Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks.First .. Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks.Last
540: Loop
541:
542: G_Stage := 'Process bb/ovn: ' || to_char(Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).BB_Id) || ':' ||
543: to_char(Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).Ovn) ||

Line 542: G_Stage := 'Process bb/ovn: ' || to_char(Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).BB_Id) || ':' ||

538: End If;
539: For i IN Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks.First .. Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks.Last
540: Loop
541:
542: G_Stage := 'Process bb/ovn: ' || to_char(Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).BB_Id) || ':' ||
543: to_char(Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).Ovn) ||
544: ' for Resource_Id(Person_Id): ' || to_char(Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).Resource_Id);
545: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
546: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,1);

Line 543: to_char(Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).Ovn) ||

539: For i IN Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks.First .. Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks.Last
540: Loop
541:
542: G_Stage := 'Process bb/ovn: ' || to_char(Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).BB_Id) || ':' ||
543: to_char(Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).Ovn) ||
544: ' for Resource_Id(Person_Id): ' || to_char(Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).Resource_Id);
545: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
546: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,1);
547:

Line 544: ' for Resource_Id(Person_Id): ' || to_char(Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).Resource_Id);

540: Loop
541:
542: G_Stage := 'Process bb/ovn: ' || to_char(Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).BB_Id) || ':' ||
543: to_char(Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).Ovn) ||
544: ' for Resource_Id(Person_Id): ' || to_char(Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).Resource_Id);
545: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
546: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,1);
547:
548: Begin

Line 556: If Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).Changed = 'N' and

552: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
553: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
554: End If;
555:
556: If Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).Changed = 'N' and
557: Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).Deleted = 'Y' Then
558:
559: G_Stage := 'Item Changed: N, Deleted: Y.';
560: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;

Line 557: Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).Deleted = 'Y' Then

553: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
554: End If;
555:
556: If Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).Changed = 'N' and
557: Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).Deleted = 'Y' Then
558:
559: G_Stage := 'Item Changed: N, Deleted: Y.';
560: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
561: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,1);

Line 579: P_BB_Id => Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).BB_Id,

575: End If;
576:
577: Pa_Otc_Api.PopulateProjRec(
578: P_New_Old_BB => 'NEW',
579: P_BB_Id => Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).BB_Id,
580: P_Detail_Index => i,
581: P_Old_Detl_Ind => l_Old_Detail_Index,
582: P_Timecard_Rec => l_New_Timecard_Rec);
583:

Line 584: Hxc_User_Type_Definition_Grp.T_Tx_Detail_Status(i) := 'SUCCESS';

580: P_Detail_Index => i,
581: P_Old_Detl_Ind => l_Old_Detail_Index,
582: P_Timecard_Rec => l_New_Timecard_Rec);
583:
584: Hxc_User_Type_Definition_Grp.T_Tx_Detail_Status(i) := 'SUCCESS';
585:
586: l_insert_rec_flag := FALSE;
587:
588: ElsIf Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).Changed = 'N' and

Line 588: ElsIf Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).Changed = 'N' and

584: Hxc_User_Type_Definition_Grp.T_Tx_Detail_Status(i) := 'SUCCESS';
585:
586: l_insert_rec_flag := FALSE;
587:
588: ElsIf Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).Changed = 'N' and
589: Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).Deleted = 'N' Then
590:
591: -- If this is the condition then there is only new data to process via PopulateProjRec() procedure
592: -- and there is no need to look at the old data via the same procedure.

Line 589: Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).Deleted = 'N' Then

585:
586: l_insert_rec_flag := FALSE;
587:
588: ElsIf Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).Changed = 'N' and
589: Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).Deleted = 'N' Then
590:
591: -- If this is the condition then there is only new data to process via PopulateProjRec() procedure
592: -- and there is no need to look at the old data via the same procedure.
593:

Line 606: P_BB_Id => Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).BB_Id,

602: End If;
603:
604: Pa_Otc_Api.PopulateProjRec(
605: P_New_Old_BB => 'NEW',
606: P_BB_Id => Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).BB_Id,
607: P_Detail_Index => i,
608: P_Old_Detl_Ind => l_Old_Detail_Index,
609: P_Timecard_Rec => l_New_Timecard_Rec);
610:

Line 625: Hxc_User_Type_Definition_Grp.T_Tx_Detail_Status(i) := 'ERRORS';

621: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
622: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
623: End If;
624:
625: Hxc_User_Type_Definition_Grp.T_Tx_Detail_Status(i) := 'ERRORS';
626: Hxc_User_Type_Definition_Grp.T_Tx_Detail_Exception(i) := l_New_Timecard_Rec.Status;
627: l_insert_rec_flag := FALSE;
628:
629: Else

Line 626: Hxc_User_Type_Definition_Grp.T_Tx_Detail_Exception(i) := l_New_Timecard_Rec.Status;

622: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
623: End If;
624:
625: Hxc_User_Type_Definition_Grp.T_Tx_Detail_Status(i) := 'ERRORS';
626: Hxc_User_Type_Definition_Grp.T_Tx_Detail_Exception(i) := l_New_Timecard_Rec.Status;
627: l_insert_rec_flag := FALSE;
628:
629: Else
630:

Line 638: to_char(Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).BB_Id) || ':' ||

634: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
635: End If;
636:
637: l_new_orig_trx_ref :=
638: to_char(Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).BB_Id) || ':' ||
639: to_char(Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).Ovn);
640:
641: G_Stage := 'Check if original transaction reference already exists 2';
642: If G_Debug_Mode = 'Y' Then

Line 639: to_char(Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).Ovn);

635: End If;
636:
637: l_new_orig_trx_ref :=
638: to_char(Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).BB_Id) || ':' ||
639: to_char(Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).Ovn);
640:
641: G_Stage := 'Check if original transaction reference already exists 2';
642: If G_Debug_Mode = 'Y' Then
643: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;

Line 676: Hxc_User_Type_Definition_Grp.T_Tx_Detail_Status(i) := 'SUCCESS';

672: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
673: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
674: End If;
675: l_insert_rec_flag := FALSE;
676: Hxc_User_Type_Definition_Grp.T_Tx_Detail_Status(i) := 'SUCCESS';
677:
678: End If;
679:
680: End If;

Line 682: ElsIf Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).Changed = 'Y' and

678: End If;
679:
680: End If;
681:
682: ElsIf Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).Changed = 'Y' and
683: Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).Deleted = 'N' Then
684:
685: G_Stage := 'Item Changed: Y, Deleted: N.';
686: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;

Line 683: Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).Deleted = 'N' Then

679:
680: End If;
681:
682: ElsIf Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).Changed = 'Y' and
683: Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).Deleted = 'N' Then
684:
685: G_Stage := 'Item Changed: Y, Deleted: N.';
686: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
687: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);

Line 698: to_char(Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).BB_Id) || ':' ||

694: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
695: End If;
696:
697: l_new_orig_trx_ref :=
698: to_char(Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).BB_Id) || ':' ||
699: to_char(Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).Ovn);
700:
701: If NOT Pa_Otc_Api.OrigTrxRefValueExists(l_new_orig_trx_ref) Then
702:

Line 699: to_char(Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).Ovn);

695: End If;
696:
697: l_new_orig_trx_ref :=
698: to_char(Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).BB_Id) || ':' ||
699: to_char(Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).Ovn);
700:
701: If NOT Pa_Otc_Api.OrigTrxRefValueExists(l_new_orig_trx_ref) Then
702:
703: G_Stage := 'Call Populate Project Record new 3a.';

Line 711: P_BB_Id => Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).BB_Id,

707: End If;
708:
709: Pa_Otc_Api.PopulateProjRec(
710: P_New_Old_BB => 'NEW',
711: P_BB_Id => Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).BB_Id,
712: P_Detail_Index => i,
713: P_Old_Detl_Ind => l_Old_Detail_Index,
714: P_timecard_Rec => l_New_Timecard_Rec);
715:

Line 730: Hxc_User_Type_Definition_Grp.T_Tx_Detail_Status(i) := 'ERRORS';

726: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
727: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
728: End If;
729:
730: Hxc_User_Type_Definition_Grp.T_Tx_Detail_Status(i) := 'ERRORS';
731: Hxc_User_Type_Definition_Grp.T_Tx_Detail_Exception(i) := l_New_Timecard_Rec.Status;
732: l_insert_rec_Flag := FALSE;
733:
734: G_Stage := 'Since the Status is not null 3a has been hit for new record, ' ||

Line 731: Hxc_User_Type_Definition_Grp.T_Tx_Detail_Exception(i) := l_New_Timecard_Rec.Status;

727: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
728: End If;
729:
730: Hxc_User_Type_Definition_Grp.T_Tx_Detail_Status(i) := 'ERRORS';
731: Hxc_User_Type_Definition_Grp.T_Tx_Detail_Exception(i) := l_New_Timecard_Rec.Status;
732: l_insert_rec_Flag := FALSE;
733:
734: G_Stage := 'Since the Status is not null 3a has been hit for new record, ' ||
735: 'call PopulateProjRec() for old records for positioning ' ||

Line 744: P_BB_Id => Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).bb_id,

740: End If;
741:
742: Pa_Otc_Api.PopulateProjRec(
743: P_New_Old_BB => 'OLD',
744: P_BB_Id => Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).bb_id,
745: P_Detail_Index => i,
746: P_Old_Detl_Ind => l_Old_Detail_Index,
747: P_timecard_Rec => l_Old_Timecard_Rec);
748:

Line 762: P_BB_Id => Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).bb_id,

758: End If;
759:
760: Pa_Otc_Api.PopulateProjRec(
761: P_New_Old_BB => 'OLD',
762: P_BB_Id => Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).bb_id,
763: P_Detail_Index => i,
764: P_Old_Detl_Ind => l_Old_Detail_Index,
765: P_timecard_Rec => l_Old_Timecard_Rec);
766:

Line 775: Hxc_User_Type_Definition_Grp.T_Tx_Detail_Status(i) := 'ERRORS';

771: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
772: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
773: End If;
774:
775: Hxc_User_Type_Definition_Grp.T_Tx_Detail_Status(i) := 'ERRORS';
776: Hxc_User_Type_Definition_Grp.T_Tx_Detail_Exception(i) := l_Old_Timecard_Rec.Status;
777: l_insert_rec_Flag := FALSE;
778:
779: Else

Line 776: Hxc_User_Type_Definition_Grp.T_Tx_Detail_Exception(i) := l_Old_Timecard_Rec.Status;

772: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
773: End If;
774:
775: Hxc_User_Type_Definition_Grp.T_Tx_Detail_Status(i) := 'ERRORS';
776: Hxc_User_Type_Definition_Grp.T_Tx_Detail_Exception(i) := l_Old_Timecard_Rec.Status;
777: l_insert_rec_Flag := FALSE;
778:
779: Else
780:

Line 813: P_Building_Block_Id => Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).BB_Id,

809: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
810: End If;
811:
812: Pa_Otc_Api.GetOrigTrxRef(
813: P_Building_Block_Id => Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).BB_Id,
814: X_OrigTrxRef => l_old_orig_trx_ref,
815: X_Status => l_New_Timecard_Rec.Status);
816:
817: If l_New_Timecard_Rec.Status is not null Then

Line 825: Hxc_User_Type_Definition_Grp.T_Tx_Detail_Status(i) := 'ERRORS';

821: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
822: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
823: End If;
824:
825: Hxc_User_Type_Definition_Grp.T_Tx_Detail_Status(i) := 'ERRORS';
826: Hxc_User_Type_Definition_Grp.T_Tx_Detail_Exception(i) := l_New_Timecard_Rec.Status;
827: Raise G_BAD_OTL_DATA;
828:
829: End If;

Line 826: Hxc_User_Type_Definition_Grp.T_Tx_Detail_Exception(i) := l_New_Timecard_Rec.Status;

822: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
823: End If;
824:
825: Hxc_User_Type_Definition_Grp.T_Tx_Detail_Status(i) := 'ERRORS';
826: Hxc_User_Type_Definition_Grp.T_Tx_Detail_Exception(i) := l_New_Timecard_Rec.Status;
827: Raise G_BAD_OTL_DATA;
828:
829: End If;
830:

Line 851: G_Trx_Direct_Upd_Tab(Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).BB_Id).BB_Index := i;

847: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
848: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
849: End If;
850:
851: G_Trx_Direct_Upd_Tab(Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).BB_Id).BB_Index := i;
852:
853: Else
854:
855: l_insert_rec_flag := TRUE;

Line 868: to_char(Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).BB_Id) || ':' ||

864: P_Exp_End_Date => l_New_Timecard_Rec.Expenditure_Ending_Date,
865: X_Batch_Name => l_Batch_Name);
866:
867: G_Stage := 'Get old orig trx ref 3 using the new bb_id/ovn ' || 'combo ' ||
868: to_char(Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).BB_Id) || ':' ||
869: to_char(Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).Ovn);
870: If G_Debug_Mode = 'Y' Then
871: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
872: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);

Line 869: to_char(Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).Ovn);

865: X_Batch_Name => l_Batch_Name);
866:
867: G_Stage := 'Get old orig trx ref 3 using the new bb_id/ovn ' || 'combo ' ||
868: to_char(Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).BB_Id) || ':' ||
869: to_char(Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).Ovn);
870: If G_Debug_Mode = 'Y' Then
871: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
872: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
873: End If;

Line 886: P_Building_Block_Id => Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).BB_Id,

882: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
883: End If;
884:
885: Pa_Otc_Api.GetOrigTrxRef(
886: P_Building_Block_Id => Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).BB_Id,
887: X_OrigTrxRef => l_old_orig_trx_ref,
888: X_Status => l_New_Timecard_Rec.Status);
889:
890: If l_New_Timecard_Rec.Status is not null Then

Line 897: Hxc_User_Type_Definition_Grp.T_Tx_Detail_Status(i) := 'ERRORS';

893: If G_Debug_Mode = 'Y' Then
894: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
895: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
896: End If;
897: Hxc_User_Type_Definition_Grp.T_Tx_Detail_Status(i) := 'ERRORS';
898: Hxc_User_Type_Definition_Grp.T_Tx_Detail_Exception(i) :=
899: l_New_Timecard_Rec.Status;
900: Raise G_BAD_OTL_DATA;
901:

Line 898: Hxc_User_Type_Definition_Grp.T_Tx_Detail_Exception(i) :=

894: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
895: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
896: End If;
897: Hxc_User_Type_Definition_Grp.T_Tx_Detail_Status(i) := 'ERRORS';
898: Hxc_User_Type_Definition_Grp.T_Tx_Detail_Exception(i) :=
899: l_New_Timecard_Rec.Status;
900: Raise G_BAD_OTL_DATA;
901:
902: End If;

Line 906: -- Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).BB_Id);

902: End If;
903:
904: -- l_old_orig_trx_ref :=
905: -- Pa_Otc_Api.GetOrigTrxRef(
906: -- Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).BB_Id);
907:
908: -- End bug enhancement
909:
910: G_Stage := 'Call Build Reverse Item 3.';

Line 930: G_Trx_Inserted_Tab(Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).BB_Id).BB_Index := i;

926: If G_Debug_Mode = 'Y' Then
927: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
928: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
929: End If;
930: G_Trx_Inserted_Tab(Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).BB_Id).BB_Index := i;
931:
932: End If; -- l_direct_update_flag
933:
934: End If; -- l_Old_Timecard_Rec.Status

Line 950: to_char(Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).BB_Id) ||

946: -- and the user decides to click on the "Save for Later" button then all
947: -- eis in OTL timecard get an incremented ovn number and we need to account for this.
948:
949: G_Stage := 'The bb_id/ovn combo already exists in projects, bypassing BB_Id: ' ||
950: to_char(Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).BB_Id) ||
951: ':' || to_char(Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).Ovn) ||
952: ' for Resource_Id: ' || to_char(Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).Resource_Id);
953: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Stage;
954: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,1);

Line 951: ':' || to_char(Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).Ovn) ||

947: -- eis in OTL timecard get an incremented ovn number and we need to account for this.
948:
949: G_Stage := 'The bb_id/ovn combo already exists in projects, bypassing BB_Id: ' ||
950: to_char(Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).BB_Id) ||
951: ':' || to_char(Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).Ovn) ||
952: ' for Resource_Id: ' || to_char(Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).Resource_Id);
953: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Stage;
954: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,1);
955:

Line 952: ' for Resource_Id: ' || to_char(Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).Resource_Id);

948:
949: G_Stage := 'The bb_id/ovn combo already exists in projects, bypassing BB_Id: ' ||
950: to_char(Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).BB_Id) ||
951: ':' || to_char(Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).Ovn) ||
952: ' for Resource_Id: ' || to_char(Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).Resource_Id);
953: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Stage;
954: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,1);
955:
956: G_Stage := 'Call Populate Project Record new 3b for positioning purposes only.';

Line 964: P_BB_Id => Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).BB_Id,

960: End If;
961:
962: Pa_Otc_Api.PopulateProjRec(
963: P_New_Old_BB => 'NEW',
964: P_BB_Id => Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).BB_Id,
965: P_Detail_Index => i,
966: P_Old_Detl_Ind => l_Old_Detail_Index,
967: P_timecard_Rec => l_New_Timecard_Rec);
968:

Line 977: P_BB_Id => Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).bb_id,

973: End If;
974:
975: Pa_Otc_Api.PopulateProjRec(
976: P_New_Old_BB => 'OLD',
977: P_BB_Id => Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).bb_id,
978: P_Detail_Index => i,
979: P_Old_Detl_Ind => l_Old_Detail_Index,
980: P_timecard_Rec => l_Old_Timecard_Rec);
981:

Line 982: Hxc_User_Type_Definition_Grp.T_Tx_Detail_Status(i) := 'SUCCESS';

978: P_Detail_Index => i,
979: P_Old_Detl_Ind => l_Old_Detail_Index,
980: P_timecard_Rec => l_Old_Timecard_Rec);
981:
982: Hxc_User_Type_Definition_Grp.T_Tx_Detail_Status(i) := 'SUCCESS';
983: l_insert_rec_Flag := FALSE;
984:
985: End If;
986:

Line 987: ElsIf Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).Changed = 'Y' and

983: l_insert_rec_Flag := FALSE;
984:
985: End If;
986:
987: ElsIf Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).Changed = 'Y' and
988: Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).Deleted = 'Y' Then
989:
990: -- The item was deleted in OTL after it was imported into Projects.
991: -- Need to Reverse out the original transaction.

Line 988: Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).Deleted = 'Y' Then

984:
985: End If;
986:
987: ElsIf Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).Changed = 'Y' and
988: Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).Deleted = 'Y' Then
989:
990: -- The item was deleted in OTL after it was imported into Projects.
991: -- Need to Reverse out the original transaction.
992:

Line 1006: l_new_orig_trx_ref := to_char(Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).BB_Id) || ':' ||

1002: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
1003: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
1004: End If;
1005:
1006: l_new_orig_trx_ref := to_char(Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).BB_Id) || ':' ||
1007: to_char(Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).Ovn);
1008:
1009: G_Stage := 'Call Populate Project Record new 4.';
1010: If G_Debug_Mode = 'Y' Then

Line 1007: to_char(Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).Ovn);

1003: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
1004: End If;
1005:
1006: l_new_orig_trx_ref := to_char(Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).BB_Id) || ':' ||
1007: to_char(Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).Ovn);
1008:
1009: G_Stage := 'Call Populate Project Record new 4.';
1010: If G_Debug_Mode = 'Y' Then
1011: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;

Line 1017: P_BB_Id => Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).BB_Id,

1013: End If;
1014:
1015: Pa_Otc_Api.PopulateProjRec(
1016: P_New_Old_BB => 'NEW',
1017: P_BB_Id => Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).BB_Id,
1018: P_Detail_Index => i,
1019: P_Old_Detl_Ind => l_Old_Detail_Index,
1020: P_timecard_Rec => l_New_Timecard_Rec);
1021:

Line 1036: Hxc_User_Type_Definition_Grp.T_Tx_Detail_Status(i) := 'ERRORS';

1032: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
1033: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
1034: End If;
1035:
1036: Hxc_User_Type_Definition_Grp.T_Tx_Detail_Status(i) := 'ERRORS';
1037: Hxc_User_Type_Definition_Grp.T_Tx_Detail_Exception(i) := l_New_Timecard_Rec.Status;
1038:
1039: G_Stage := 'Since Status is not null 4 occured for new record, call the ' ||
1040: 'PopulateProjRec() procedure for the old record for positioning purposes ' ||

Line 1037: Hxc_User_Type_Definition_Grp.T_Tx_Detail_Exception(i) := l_New_Timecard_Rec.Status;

1033: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
1034: End If;
1035:
1036: Hxc_User_Type_Definition_Grp.T_Tx_Detail_Status(i) := 'ERRORS';
1037: Hxc_User_Type_Definition_Grp.T_Tx_Detail_Exception(i) := l_New_Timecard_Rec.Status;
1038:
1039: G_Stage := 'Since Status is not null 4 occured for new record, call the ' ||
1040: 'PopulateProjRec() procedure for the old record for positioning purposes ' ||
1041: 'so as to maintain sync with new pl/sql tables.';

Line 1049: P_BB_Id => Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).bb_id,

1045: End If;
1046:
1047: Pa_Otc_Api.PopulateProjRec(
1048: P_New_Old_BB => 'OLD',
1049: P_BB_Id => Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).bb_id,
1050: P_Detail_Index => i,
1051: P_Old_Detl_Ind => l_Old_Detail_Index,
1052: P_timecard_Rec => l_Old_Timecard_Rec);
1053:

Line 1077: P_BB_Id => Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).bb_id,

1073: End If;
1074:
1075: Pa_Otc_Api.PopulateProjRec(
1076: P_New_Old_BB => 'OLD',
1077: P_BB_Id => Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).bb_id,
1078: P_Detail_Index => i,
1079: P_Old_Detl_Ind => l_Old_Detail_Index,
1080: P_timecard_Rec => l_Old_Timecard_Rec);
1081:

Line 1085: to_char(Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).BB_Id) || ':' ||

1081:
1082: -- We are not checking the status column since the call is for positioning purposes only.
1083:
1084: G_Stage := 'Create old orig trx ref 4 using bb_id/ovn ' ||
1085: to_char(Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).BB_Id) || ':' ||
1086: to_char(Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).Ovn);
1087: If G_Debug_Mode = 'Y' Then
1088: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
1089: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);

Line 1086: to_char(Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).Ovn);

1082: -- We are not checking the status column since the call is for positioning purposes only.
1083:
1084: G_Stage := 'Create old orig trx ref 4 using bb_id/ovn ' ||
1085: to_char(Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).BB_Id) || ':' ||
1086: to_char(Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).Ovn);
1087: If G_Debug_Mode = 'Y' Then
1088: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
1089: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
1090: End If;

Line 1103: P_Building_Block_Id => Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).BB_Id,

1099: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
1100: End If;
1101:
1102: Pa_Otc_Api.GetOrigTrxRef(
1103: P_Building_Block_Id => Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).BB_Id,
1104: X_OrigTrxRef => l_old_orig_trx_ref,
1105: X_Status => l_New_Timecard_Rec.Status);
1106:
1107: If l_New_Timecard_Rec.Status is not null Then

Line 1115: Hxc_User_Type_Definition_Grp.T_Tx_Detail_Status(i) := 'ERRORS';

1111: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
1112: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
1113: End If;
1114:
1115: Hxc_User_Type_Definition_Grp.T_Tx_Detail_Status(i) := 'ERRORS';
1116: Hxc_User_Type_Definition_Grp.T_Tx_Detail_Exception(i) := l_New_Timecard_Rec.Status;
1117: Raise G_BAD_OTL_DATA;
1118:
1119: End If;

Line 1116: Hxc_User_Type_Definition_Grp.T_Tx_Detail_Exception(i) := l_New_Timecard_Rec.Status;

1112: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
1113: End If;
1114:
1115: Hxc_User_Type_Definition_Grp.T_Tx_Detail_Status(i) := 'ERRORS';
1116: Hxc_User_Type_Definition_Grp.T_Tx_Detail_Exception(i) := l_New_Timecard_Rec.Status;
1117: Raise G_BAD_OTL_DATA;
1118:
1119: End If;
1120:

Line 1122: -- Pa_Otc_Api.GetOrigTrxRef(Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).BB_Id);

1118:
1119: End If;
1120:
1121: -- l_old_orig_trx_ref :=
1122: -- Pa_Otc_Api.GetOrigTrxRef(Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).BB_Id);
1123:
1124: -- End switch from function to procedure
1125:
1126: G_Stage := 'Call Build Reverse Item 4.';

Line 1147: G_Trx_Inserted_Tab(Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).BB_Id).BB_Index := i;

1143: If G_Debug_Mode = 'Y' Then
1144: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
1145: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
1146: End If;
1147: G_Trx_Inserted_Tab(Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).BB_Id).BB_Index := i;
1148:
1149: End If; -- l_New_Timecard_Rec.Status
1150:
1151: End If; -- Change/Delete flags

Line 1303: G_Trx_Inserted_Tab(Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).BB_Id).BB_Index := i;

1299: If G_Debug_Mode = 'Y' Then
1300: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
1301: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
1302: End If;
1303: G_Trx_Inserted_Tab(Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).BB_Id).BB_Index := i;
1304:
1305: End If;
1306:
1307: G_Stage := 'Check if need to call bulk insert.';

Line 1334: Hxc_User_Type_Definition_Grp.T_Tx_Detail_Status(i) := 'ERRORS';

1330: End if; /* Bug 6698171, End of validation for terminated employee */
1331:
1332: Exception
1333: When G_BAD_OTL_DATA Then
1334: Hxc_User_Type_Definition_Grp.T_Tx_Detail_Status(i) := 'ERRORS';
1335: Hxc_User_Type_Definition_Grp.T_Tx_Detail_Exception(i) :=
1336: nvl(l_New_Timecard_Rec.Status,l_Old_Timecard_Rec.Status);
1337: G_Unhandled_Except_Cnt := G_Unhandled_Except_Cnt + 1;
1338:

Line 1335: Hxc_User_Type_Definition_Grp.T_Tx_Detail_Exception(i) :=

1331:
1332: Exception
1333: When G_BAD_OTL_DATA Then
1334: Hxc_User_Type_Definition_Grp.T_Tx_Detail_Status(i) := 'ERRORS';
1335: Hxc_User_Type_Definition_Grp.T_Tx_Detail_Exception(i) :=
1336: nvl(l_New_Timecard_Rec.Status,l_Old_Timecard_Rec.Status);
1337: G_Unhandled_Except_Cnt := G_Unhandled_Except_Cnt + 1;
1338:
1339: G_Stage := 'Unhandled exception count is now ' || to_char(G_Unhandled_Except_Cnt);

Line 1399: G_Stage := 'This chunk has ' || to_char(Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks.COUNT) ||

1395: G_Txn_Rec_Count := 0;
1396:
1397: End If;
1398:
1399: G_Stage := 'This chunk has ' || to_char(Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks.COUNT) ||
1400: ' records, of which ' || to_char(Pa_Trx_Import.G_Batch_Size) || ' are to be processed' ||
1401: ' in the next phase of Trx Import.';
1402: If G_Debug_Mode = 'Y' Then
1403: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;

Line 2290: Hxc_User_Type_Definition_Grp.T_Tx_Detail_Status(G_Trx_Inserted_Tab(TrxRecord.Detail_BB_Id).BB_Index) :=

2286: If G_Debug_Mode = 'Y' Then
2287: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
2288: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
2289: End If;
2290: Hxc_User_Type_Definition_Grp.T_Tx_Detail_Status(G_Trx_Inserted_Tab(TrxRecord.Detail_BB_Id).BB_Index) :=
2291: 'SUCCESS';
2292:
2293: ElsIf TrxRecord.Transaction_Status_Code = 'R' Then
2294:

Line 2309: Hxc_User_Type_Definition_Grp.T_Tx_Detail_Status(G_Trx_Inserted_Tab(TrxRecord.Detail_BB_Id).BB_Index) := 'ERRORS';

2305: * So we check to first see if it exists in the pl/sql table and then if it does
2306: * we update the otl pl/sql table accordingly run.
2307: */
2308:
2309: Hxc_User_Type_Definition_Grp.T_Tx_Detail_Status(G_Trx_Inserted_Tab(TrxRecord.Detail_BB_Id).BB_Index) := 'ERRORS';
2310:
2311: If TrxRecord.Transaction_Rejection_Code is not null Then
2312:
2313: Fnd_Message.Set_Name('PA', TrxRecord.Transaction_Rejection_Code);

Line 2314: Hxc_User_Type_Definition_Grp.T_Tx_Detail_Exception(G_Trx_Inserted_Tab(TrxRecord.Detail_BB_Id).BB_Index) :=

2310:
2311: If TrxRecord.Transaction_Rejection_Code is not null Then
2312:
2313: Fnd_Message.Set_Name('PA', TrxRecord.Transaction_Rejection_Code);
2314: Hxc_User_Type_Definition_Grp.T_Tx_Detail_Exception(G_Trx_Inserted_Tab(TrxRecord.Detail_BB_Id).BB_Index) :=
2315: Substr(Fnd_Message.Get,1,2000);
2316:
2317: -- Begin Bug 3355510 Don't needed to explicitly set the value to null with by default it already is. This was the problem.
2318: -- Else

Line 2320: -- Hxc_User_Type_Definition_Grp.T_Tx_Detail_Exception(G_Trx_Inserted_Tab(TrxRecord.Detail_BB_Id).BB_Index) := Null;

2316:
2317: -- Begin Bug 3355510 Don't needed to explicitly set the value to null with by default it already is. This was the problem.
2318: -- Else
2319: --
2320: -- Hxc_User_Type_Definition_Grp.T_Tx_Detail_Exception(G_Trx_Inserted_Tab(TrxRecord.Detail_BB_Id).BB_Index) := Null;
2321: -- End Bug 3355510
2322:
2323: End If;
2324:

Line 2694: P_Timecard_Rec.Incurred_By_Person_Id := Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(P_Detail_Index).Resource_Id;

2690: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
2691: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
2692: End If;
2693:
2694: P_Timecard_Rec.Incurred_By_Person_Id := Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(P_Detail_Index).Resource_Id;
2695:
2696: G_Stage := 'Get New Detail Building Block data. Quantity: ' ||
2697: to_char(Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(P_Detail_Index).Measure);
2698: If G_Debug_Mode = 'Y' Then

Line 2697: to_char(Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(P_Detail_Index).Measure);

2693:
2694: P_Timecard_Rec.Incurred_By_Person_Id := Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(P_Detail_Index).Resource_Id;
2695:
2696: G_Stage := 'Get New Detail Building Block data. Quantity: ' ||
2697: to_char(Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(P_Detail_Index).Measure);
2698: If G_Debug_Mode = 'Y' Then
2699: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
2700: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
2701: End If;

Line 2703: P_Timecard_Rec.Quantity := Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(P_Detail_Index).Measure;

2699: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
2700: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
2701: End If;
2702:
2703: P_Timecard_Rec.Quantity := Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(P_Detail_Index).Measure;
2704:
2705: /* begin bug 5412033 */
2706: G_Stage := 'Get New Detail Building Block data. Expenditure Item Comment: ' ||
2707: Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(P_Detail_Index).Comment_Text ||

Line 2707: Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(P_Detail_Index).Comment_Text ||

2703: P_Timecard_Rec.Quantity := Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(P_Detail_Index).Measure;
2704:
2705: /* begin bug 5412033 */
2706: G_Stage := 'Get New Detail Building Block data. Expenditure Item Comment: ' ||
2707: Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(P_Detail_Index).Comment_Text ||
2708: '(End of comment)';
2709: If G_Debug_Mode = 'Y' Then
2710: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
2711: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);

Line 2719: l_comment_text := Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(P_Detail_Index).Comment_Text;

2715: If G_Debug_Mode = 'Y' Then
2716: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
2717: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
2718: End If;
2719: l_comment_text := Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(P_Detail_Index).Comment_Text;
2720:
2721: G_Stage := 'Checking if comment is not null.';
2722: If G_Debug_Mode = 'Y' Then
2723: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;

Line 2738: -- If length(Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(P_Detail_Index).Comment_Text) > 240 Then

2734:
2735: /* Bug 2930551 If the length of the comment_text is greater than 240 then we should only
2736: grab the first 240 characters. */
2737: -- begin bug 4926265
2738: -- If length(Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(P_Detail_Index).Comment_Text) > 240 Then
2739: -- If lengthb(Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(P_Detail_Index).Comment_Text) > 240 Then
2740: If lengthb(l_comment_text) > 240 Then
2741:
2742: If G_Debug_Mode = 'Y' Then

Line 2739: -- If lengthb(Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(P_Detail_Index).Comment_Text) > 240 Then

2735: /* Bug 2930551 If the length of the comment_text is greater than 240 then we should only
2736: grab the first 240 characters. */
2737: -- begin bug 4926265
2738: -- If length(Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(P_Detail_Index).Comment_Text) > 240 Then
2739: -- If lengthb(Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(P_Detail_Index).Comment_Text) > 240 Then
2740: If lengthb(l_comment_text) > 240 Then
2741:
2742: If G_Debug_Mode = 'Y' Then
2743: G_Stage := 'Comment_Text length > 240.';

Line 2749: -- substr(Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(P_Detail_Index).Comment_Text,1,240);

2745: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
2746: End If;
2747:
2748: -- P_Timecard_Rec.Expenditure_Item_Comment :=
2749: -- substr(Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(P_Detail_Index).Comment_Text,1,240);
2750: -- P_Timecard_Rec.Expenditure_Item_Comment :=
2751: -- substrb(Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(P_Detail_Index).Comment_Text,1,240);
2752: -- end bug 4926265
2753: P_Timecard_Rec.Expenditure_Item_Comment := substrb(l_comment_text,1,240);

Line 2751: -- substrb(Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(P_Detail_Index).Comment_Text,1,240);

2747:
2748: -- P_Timecard_Rec.Expenditure_Item_Comment :=
2749: -- substr(Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(P_Detail_Index).Comment_Text,1,240);
2750: -- P_Timecard_Rec.Expenditure_Item_Comment :=
2751: -- substrb(Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(P_Detail_Index).Comment_Text,1,240);
2752: -- end bug 4926265
2753: P_Timecard_Rec.Expenditure_Item_Comment := substrb(l_comment_text,1,240);
2754:
2755: Else

Line 2764: -- Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(P_Detail_Index).Comment_Text;

2760: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
2761: End If;
2762:
2763: -- P_Timecard_Rec.Expenditure_Item_Comment :=
2764: -- Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(P_Detail_Index).Comment_Text;
2765: P_Timecard_Rec.Expenditure_Item_Comment := l_comment_text;
2766:
2767: End If;
2768:

Line 2788: TRUNC(Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(P_Detail_Index).Start_Time);

2784: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
2785: End If;
2786:
2787: P_Timecard_Rec.Expenditure_Item_Date :=
2788: TRUNC(Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(P_Detail_Index).Start_Time);
2789:
2790: If P_Timecard_Rec.Expenditure_Item_Date Is Null Then
2791:
2792: G_Stage := 'Get New Detail Building Block data. Exp Item Date, second attempt.';

Line 2806: While i <= Hxc_User_Type_Definition_Grp.T_Day_Bld_Blks.LAST and NOT l_Rec_Found

2802: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
2803: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
2804: End If;
2805:
2806: While i <= Hxc_User_Type_Definition_Grp.T_Day_Bld_Blks.LAST and NOT l_Rec_Found
2807: Loop
2808:
2809: G_Stage := 'Check if the current record is the correct DAY ' ||
2810: 'record to grab Exp Item Date from.';

Line 2816: If Hxc_User_Type_Definition_Grp.T_Day_Bld_Blks(i).BB_Id =

2812: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
2813: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
2814: End If;
2815:
2816: If Hxc_User_Type_Definition_Grp.T_Day_Bld_Blks(i).BB_Id =
2817: Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(P_Detail_Index).Parent_BB_Id Then
2818:
2819: G_Stage := 'Grab the Exp Item Date from new day building block record.';
2820: If G_Debug_Mode = 'Y' Then

Line 2817: Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(P_Detail_Index).Parent_BB_Id Then

2813: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
2814: End If;
2815:
2816: If Hxc_User_Type_Definition_Grp.T_Day_Bld_Blks(i).BB_Id =
2817: Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(P_Detail_Index).Parent_BB_Id Then
2818:
2819: G_Stage := 'Grab the Exp Item Date from new day building block record.';
2820: If G_Debug_Mode = 'Y' Then
2821: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;

Line 2825: P_Timecard_Rec.Expenditure_Item_Date := Trunc(Hxc_User_Type_Definition_Grp.T_Day_Bld_Blks(i).Start_Time);

2821: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
2822: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
2823: End If;
2824:
2825: P_Timecard_Rec.Expenditure_Item_Date := Trunc(Hxc_User_Type_Definition_Grp.T_Day_Bld_Blks(i).Start_Time);
2826: l_Rec_Found := TRUE;
2827:
2828: End If;
2829:

Line 2895: to_char(Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).BB_Id);

2891: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
2892: End If;
2893:
2894: G_Stage := 'Current position in NEW attribute pl/sql table bb_id value is: ' ||
2895: to_char(Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).BB_Id);
2896: If G_Debug_Mode = 'Y' Then
2897: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
2898: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
2899: End If;

Line 2901: While i <= Hxc_User_Type_Definition_Grp.T_Detail_Attributes.LAST And

2897: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
2898: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
2899: End If;
2900:
2901: While i <= Hxc_User_Type_Definition_Grp.T_Detail_Attributes.LAST And
2902: Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).BB_Id = P_BB_Id
2903: Loop
2904:
2905: If Upper(Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Field_Name) = 'PROJECT_ID' Then

Line 2902: Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).BB_Id = P_BB_Id

2898: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
2899: End If;
2900:
2901: While i <= Hxc_User_Type_Definition_Grp.T_Detail_Attributes.LAST And
2902: Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).BB_Id = P_BB_Id
2903: Loop
2904:
2905: If Upper(Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Field_Name) = 'PROJECT_ID' Then
2906:

Line 2905: If Upper(Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Field_Name) = 'PROJECT_ID' Then

2901: While i <= Hxc_User_Type_Definition_Grp.T_Detail_Attributes.LAST And
2902: Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).BB_Id = P_BB_Id
2903: Loop
2904:
2905: If Upper(Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Field_Name) = 'PROJECT_ID' Then
2906:
2907: G_Stage := 'Retrieved Project Id: ' || Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value ||
2908: ' Index position: ' || to_char(i);
2909: If G_Debug_Mode = 'Y' Then

Line 2907: G_Stage := 'Retrieved Project Id: ' || Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value ||

2903: Loop
2904:
2905: If Upper(Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Field_Name) = 'PROJECT_ID' Then
2906:
2907: G_Stage := 'Retrieved Project Id: ' || Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value ||
2908: ' Index position: ' || to_char(i);
2909: If G_Debug_Mode = 'Y' Then
2910: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
2911: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);

Line 2914: P_Timecard_Rec.Project_Id := Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value;

2910: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
2911: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
2912: End If;
2913:
2914: P_Timecard_Rec.Project_Id := Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value;
2915:
2916: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Field_Name) = 'TASK_ID' Then
2917:
2918: G_Stage := 'Retrieved Task Id: ' || Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value ||

Line 2916: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Field_Name) = 'TASK_ID' Then

2912: End If;
2913:
2914: P_Timecard_Rec.Project_Id := Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value;
2915:
2916: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Field_Name) = 'TASK_ID' Then
2917:
2918: G_Stage := 'Retrieved Task Id: ' || Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value ||
2919: ' Index position: ' || to_char(i);
2920: If G_Debug_Mode = 'Y' Then

Line 2918: G_Stage := 'Retrieved Task Id: ' || Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value ||

2914: P_Timecard_Rec.Project_Id := Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value;
2915:
2916: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Field_Name) = 'TASK_ID' Then
2917:
2918: G_Stage := 'Retrieved Task Id: ' || Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value ||
2919: ' Index position: ' || to_char(i);
2920: If G_Debug_Mode = 'Y' Then
2921: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
2922: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);

Line 2925: P_Timecard_Rec.Task_Id := Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value;

2921: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
2922: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
2923: End If;
2924:
2925: P_Timecard_Rec.Task_Id := Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value;
2926:
2927: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Field_Name) = 'EXPENDITURE_TYPE' Then
2928:
2929: G_Stage := 'Retrieved Expenditure Type: ' || Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value ||

Line 2927: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Field_Name) = 'EXPENDITURE_TYPE' Then

2923: End If;
2924:
2925: P_Timecard_Rec.Task_Id := Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value;
2926:
2927: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Field_Name) = 'EXPENDITURE_TYPE' Then
2928:
2929: G_Stage := 'Retrieved Expenditure Type: ' || Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value ||
2930: ' Index position: ' || to_char(i);
2931: If G_Debug_Mode = 'Y' Then

Line 2929: G_Stage := 'Retrieved Expenditure Type: ' || Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value ||

2925: P_Timecard_Rec.Task_Id := Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value;
2926:
2927: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Field_Name) = 'EXPENDITURE_TYPE' Then
2928:
2929: G_Stage := 'Retrieved Expenditure Type: ' || Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value ||
2930: ' Index position: ' || to_char(i);
2931: If G_Debug_Mode = 'Y' Then
2932: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
2933: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);

Line 2936: P_Timecard_Rec.Expenditure_Type := Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value;

2932: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
2933: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
2934: End If;
2935:
2936: P_Timecard_Rec.Expenditure_Type := Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value;
2937:
2938: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Field_Name) = 'SYSTEM_LINKAGE_FUNCTION' Then
2939:
2940: G_Stage := 'Retrieve System Linkage Function: ' ||

Line 2938: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Field_Name) = 'SYSTEM_LINKAGE_FUNCTION' Then

2934: End If;
2935:
2936: P_Timecard_Rec.Expenditure_Type := Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value;
2937:
2938: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Field_Name) = 'SYSTEM_LINKAGE_FUNCTION' Then
2939:
2940: G_Stage := 'Retrieve System Linkage Function: ' ||
2941: Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value ||
2942: ' Index position: ' || to_char(i);

Line 2941: Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value ||

2937:
2938: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Field_Name) = 'SYSTEM_LINKAGE_FUNCTION' Then
2939:
2940: G_Stage := 'Retrieve System Linkage Function: ' ||
2941: Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value ||
2942: ' Index position: ' || to_char(i);
2943: If G_Debug_Mode = 'Y' Then
2944: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
2945: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);

Line 2948: P_Timecard_Rec.System_Linkage_Function := Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value;

2944: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
2945: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
2946: End If;
2947:
2948: P_Timecard_Rec.System_Linkage_Function := Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value;
2949:
2950: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Field_Name) = 'OVERRIDING_APPROVER_PERSON_ID' Then
2951:
2952: G_Stage := 'Retrieve Overidding Approver Person Id: ' ||

Line 2950: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Field_Name) = 'OVERRIDING_APPROVER_PERSON_ID' Then

2946: End If;
2947:
2948: P_Timecard_Rec.System_Linkage_Function := Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value;
2949:
2950: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Field_Name) = 'OVERRIDING_APPROVER_PERSON_ID' Then
2951:
2952: G_Stage := 'Retrieve Overidding Approver Person Id: ' ||
2953: Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value ||
2954: ' Index position: ' || to_char(i);

Line 2953: Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value ||

2949:
2950: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Field_Name) = 'OVERRIDING_APPROVER_PERSON_ID' Then
2951:
2952: G_Stage := 'Retrieve Overidding Approver Person Id: ' ||
2953: Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value ||
2954: ' Index position: ' || to_char(i);
2955: If G_Debug_Mode = 'Y' Then
2956: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
2957: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);

Line 2960: P_Timecard_Rec.Override_Approver_Person_Id := Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value;

2956: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
2957: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
2958: End If;
2959:
2960: P_Timecard_Rec.Override_Approver_Person_Id := Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value;
2961:
2962: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Field_Name) = 'DUMMY PAEXPITDFF CONTEXT' Then
2963:
2964: /* The value column contains the following format:

Line 2962: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Field_Name) = 'DUMMY PAEXPITDFF CONTEXT' Then

2958: End If;
2959:
2960: P_Timecard_Rec.Override_Approver_Person_Id := Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value;
2961:
2962: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Field_Name) = 'DUMMY PAEXPITDFF CONTEXT' Then
2963:
2964: /* The value column contains the following format:
2965: * 'PAEXPITDFF - '
2966: * So to get the attribute_category out will need to find the position

Line 2970: G_Stage := 'Get new attribute category: ' || Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value ||

2966: * So to get the attribute_category out will need to find the position
2967: * for ' - ' that is: '-' and then add 3.
2968: */
2969:
2970: G_Stage := 'Get new attribute category: ' || Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value ||
2971: ' Index position: ' || to_char(i);
2972: If G_Debug_Mode = 'Y' Then
2973: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
2974: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);

Line 2977: l_attribute_category := Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value;

2973: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
2974: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
2975: End If;
2976:
2977: l_attribute_category := Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value;
2978:
2979: /* Need to check for null so as to avoid the unecessary use of errors using instr
2980: * to avoid unhandled exceptions.
2981: */

Line 3001: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Field_Name) = 'PADFFATTRIBUTE1' Then

2997: P_Timecard_Rec.Attribute_Category := substr(l_attribute_category,instr(l_attribute_category,' - ') + 3);
2998:
2999: End If;
3000:
3001: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Field_Name) = 'PADFFATTRIBUTE1' Then
3002:
3003: G_Stage := 'Got new attribute1: ' || Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value ||
3004: ' Index position: ' || to_char(i);
3005: If G_Debug_Mode = 'Y' Then

Line 3003: G_Stage := 'Got new attribute1: ' || Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value ||

2999: End If;
3000:
3001: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Field_Name) = 'PADFFATTRIBUTE1' Then
3002:
3003: G_Stage := 'Got new attribute1: ' || Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value ||
3004: ' Index position: ' || to_char(i);
3005: If G_Debug_Mode = 'Y' Then
3006: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
3007: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);

Line 3010: P_Timecard_Rec.Attribute1 := Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value;

3006: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
3007: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
3008: End If;
3009:
3010: P_Timecard_Rec.Attribute1 := Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value;
3011:
3012: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Field_Name) = 'PADFFATTRIBUTE2' Then
3013:
3014: G_Stage := 'Got new attribute2: ' || Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value ||

Line 3012: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Field_Name) = 'PADFFATTRIBUTE2' Then

3008: End If;
3009:
3010: P_Timecard_Rec.Attribute1 := Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value;
3011:
3012: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Field_Name) = 'PADFFATTRIBUTE2' Then
3013:
3014: G_Stage := 'Got new attribute2: ' || Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value ||
3015: ' Index position: ' || to_char(i);
3016: If G_Debug_Mode = 'Y' Then

Line 3014: G_Stage := 'Got new attribute2: ' || Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value ||

3010: P_Timecard_Rec.Attribute1 := Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value;
3011:
3012: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Field_Name) = 'PADFFATTRIBUTE2' Then
3013:
3014: G_Stage := 'Got new attribute2: ' || Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value ||
3015: ' Index position: ' || to_char(i);
3016: If G_Debug_Mode = 'Y' Then
3017: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
3018: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);

Line 3021: P_Timecard_Rec.Attribute2 := Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value;

3017: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
3018: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
3019: End If;
3020:
3021: P_Timecard_Rec.Attribute2 := Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value;
3022:
3023: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Field_Name) = 'PADFFATTRIBUTE3' Then
3024:
3025: G_Stage := 'Got new attribute3: ' || Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value ||

Line 3023: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Field_Name) = 'PADFFATTRIBUTE3' Then

3019: End If;
3020:
3021: P_Timecard_Rec.Attribute2 := Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value;
3022:
3023: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Field_Name) = 'PADFFATTRIBUTE3' Then
3024:
3025: G_Stage := 'Got new attribute3: ' || Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value ||
3026: ' Index position: ' || to_char(i);
3027: If G_Debug_Mode = 'Y' Then

Line 3025: G_Stage := 'Got new attribute3: ' || Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value ||

3021: P_Timecard_Rec.Attribute2 := Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value;
3022:
3023: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Field_Name) = 'PADFFATTRIBUTE3' Then
3024:
3025: G_Stage := 'Got new attribute3: ' || Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value ||
3026: ' Index position: ' || to_char(i);
3027: If G_Debug_Mode = 'Y' Then
3028: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
3029: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);

Line 3032: P_Timecard_Rec.Attribute3 := Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value;

3028: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
3029: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
3030: End If;
3031:
3032: P_Timecard_Rec.Attribute3 := Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value;
3033:
3034: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Field_Name) = 'PADFFATTRIBUTE4' Then
3035:
3036: G_Stage := 'Got new attribute4: ' || Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value ||

Line 3034: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Field_Name) = 'PADFFATTRIBUTE4' Then

3030: End If;
3031:
3032: P_Timecard_Rec.Attribute3 := Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value;
3033:
3034: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Field_Name) = 'PADFFATTRIBUTE4' Then
3035:
3036: G_Stage := 'Got new attribute4: ' || Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value ||
3037: ' Index position: ' || to_char(i);
3038: If G_Debug_Mode = 'Y' Then

Line 3036: G_Stage := 'Got new attribute4: ' || Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value ||

3032: P_Timecard_Rec.Attribute3 := Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value;
3033:
3034: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Field_Name) = 'PADFFATTRIBUTE4' Then
3035:
3036: G_Stage := 'Got new attribute4: ' || Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value ||
3037: ' Index position: ' || to_char(i);
3038: If G_Debug_Mode = 'Y' Then
3039: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
3040: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);

Line 3043: P_Timecard_Rec.Attribute4 := Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value;

3039: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
3040: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
3041: End If;
3042:
3043: P_Timecard_Rec.Attribute4 := Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value;
3044:
3045: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Field_Name) = 'PADFFATTRIBUTE5' Then
3046:
3047: G_Stage := 'Got new attribute5: ' || Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value ||

Line 3045: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Field_Name) = 'PADFFATTRIBUTE5' Then

3041: End If;
3042:
3043: P_Timecard_Rec.Attribute4 := Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value;
3044:
3045: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Field_Name) = 'PADFFATTRIBUTE5' Then
3046:
3047: G_Stage := 'Got new attribute5: ' || Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value ||
3048: ' Index position: ' || to_char(i);
3049: If G_Debug_Mode = 'Y' Then

Line 3047: G_Stage := 'Got new attribute5: ' || Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value ||

3043: P_Timecard_Rec.Attribute4 := Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value;
3044:
3045: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Field_Name) = 'PADFFATTRIBUTE5' Then
3046:
3047: G_Stage := 'Got new attribute5: ' || Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value ||
3048: ' Index position: ' || to_char(i);
3049: If G_Debug_Mode = 'Y' Then
3050: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
3051: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);

Line 3054: P_Timecard_Rec.Attribute5 := Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value;

3050: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
3051: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
3052: End If;
3053:
3054: P_Timecard_Rec.Attribute5 := Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value;
3055:
3056: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Field_Name) = 'PADFFATTRIBUTE6' Then
3057:
3058: G_Stage := 'Got new attribute6: ' || Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value ||

Line 3056: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Field_Name) = 'PADFFATTRIBUTE6' Then

3052: End If;
3053:
3054: P_Timecard_Rec.Attribute5 := Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value;
3055:
3056: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Field_Name) = 'PADFFATTRIBUTE6' Then
3057:
3058: G_Stage := 'Got new attribute6: ' || Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value ||
3059: ' Index position: ' || to_char(i);
3060: If G_Debug_Mode = 'Y' Then

Line 3058: G_Stage := 'Got new attribute6: ' || Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value ||

3054: P_Timecard_Rec.Attribute5 := Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value;
3055:
3056: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Field_Name) = 'PADFFATTRIBUTE6' Then
3057:
3058: G_Stage := 'Got new attribute6: ' || Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value ||
3059: ' Index position: ' || to_char(i);
3060: If G_Debug_Mode = 'Y' Then
3061: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
3062: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);

Line 3065: P_Timecard_Rec.Attribute6 := Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value;

3061: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
3062: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
3063: End If;
3064:
3065: P_Timecard_Rec.Attribute6 := Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value;
3066:
3067: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Field_Name) = 'PADFFATTRIBUTE7' Then
3068:
3069: G_Stage := 'Got new attribute7: ' || Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value ||

Line 3067: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Field_Name) = 'PADFFATTRIBUTE7' Then

3063: End If;
3064:
3065: P_Timecard_Rec.Attribute6 := Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value;
3066:
3067: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Field_Name) = 'PADFFATTRIBUTE7' Then
3068:
3069: G_Stage := 'Got new attribute7: ' || Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value ||
3070: ' Index position: ' || to_char(i);
3071: If G_Debug_Mode = 'Y' Then

Line 3069: G_Stage := 'Got new attribute7: ' || Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value ||

3065: P_Timecard_Rec.Attribute6 := Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value;
3066:
3067: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Field_Name) = 'PADFFATTRIBUTE7' Then
3068:
3069: G_Stage := 'Got new attribute7: ' || Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value ||
3070: ' Index position: ' || to_char(i);
3071: If G_Debug_Mode = 'Y' Then
3072: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
3073: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);

Line 3076: P_Timecard_Rec.Attribute7 := Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value;

3072: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
3073: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
3074: End If;
3075:
3076: P_Timecard_Rec.Attribute7 := Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value;
3077:
3078: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Field_Name) = 'PADFFATTRIBUTE8' Then
3079:
3080: G_Stage := 'Got new attribute8: ' || Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value ||

Line 3078: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Field_Name) = 'PADFFATTRIBUTE8' Then

3074: End If;
3075:
3076: P_Timecard_Rec.Attribute7 := Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value;
3077:
3078: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Field_Name) = 'PADFFATTRIBUTE8' Then
3079:
3080: G_Stage := 'Got new attribute8: ' || Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value ||
3081: ' Index position: ' || to_char(i);
3082: If G_Debug_Mode = 'Y' Then

Line 3080: G_Stage := 'Got new attribute8: ' || Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value ||

3076: P_Timecard_Rec.Attribute7 := Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value;
3077:
3078: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Field_Name) = 'PADFFATTRIBUTE8' Then
3079:
3080: G_Stage := 'Got new attribute8: ' || Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value ||
3081: ' Index position: ' || to_char(i);
3082: If G_Debug_Mode = 'Y' Then
3083: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
3084: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);

Line 3087: P_Timecard_Rec.Attribute8 := Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value;

3083: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
3084: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
3085: End If;
3086:
3087: P_Timecard_Rec.Attribute8 := Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value;
3088:
3089: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Field_Name) = 'PADFFATTRIBUTE9' Then
3090:
3091: G_Stage := 'Got new attribute9: ' || Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value ||

Line 3089: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Field_Name) = 'PADFFATTRIBUTE9' Then

3085: End If;
3086:
3087: P_Timecard_Rec.Attribute8 := Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value;
3088:
3089: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Field_Name) = 'PADFFATTRIBUTE9' Then
3090:
3091: G_Stage := 'Got new attribute9: ' || Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value ||
3092: ' Index position: ' || to_char(i);
3093: If G_Debug_Mode = 'Y' Then

Line 3091: G_Stage := 'Got new attribute9: ' || Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value ||

3087: P_Timecard_Rec.Attribute8 := Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value;
3088:
3089: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Field_Name) = 'PADFFATTRIBUTE9' Then
3090:
3091: G_Stage := 'Got new attribute9: ' || Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value ||
3092: ' Index position: ' || to_char(i);
3093: If G_Debug_Mode = 'Y' Then
3094: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
3095: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);

Line 3098: P_Timecard_Rec.Attribute9 := Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value;

3094: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
3095: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
3096: End If;
3097:
3098: P_Timecard_Rec.Attribute9 := Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value;
3099:
3100: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Field_Name) = 'PADFFATTRIBUTE10' Then
3101:
3102: G_Stage := 'Got new attribute10: ' || Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value ||

Line 3100: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Field_Name) = 'PADFFATTRIBUTE10' Then

3096: End If;
3097:
3098: P_Timecard_Rec.Attribute9 := Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value;
3099:
3100: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Field_Name) = 'PADFFATTRIBUTE10' Then
3101:
3102: G_Stage := 'Got new attribute10: ' || Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value ||
3103: ' Index position: ' || to_char(i);
3104: If G_Debug_Mode = 'Y' Then

Line 3102: G_Stage := 'Got new attribute10: ' || Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value ||

3098: P_Timecard_Rec.Attribute9 := Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value;
3099:
3100: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Field_Name) = 'PADFFATTRIBUTE10' Then
3101:
3102: G_Stage := 'Got new attribute10: ' || Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value ||
3103: ' Index position: ' || to_char(i);
3104: If G_Debug_Mode = 'Y' Then
3105: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
3106: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);

Line 3109: P_Timecard_Rec.Attribute10 := Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value;

3105: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
3106: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
3107: End If;
3108:
3109: P_Timecard_Rec.Attribute10 := Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value;
3110:
3111: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Field_Name) = 'BILLABLE_FLAG' Then
3112:
3113: G_Stage := 'Got new Billable Flag: ' || Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value ||

Line 3111: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Field_Name) = 'BILLABLE_FLAG' Then

3107: End If;
3108:
3109: P_Timecard_Rec.Attribute10 := Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value;
3110:
3111: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Field_Name) = 'BILLABLE_FLAG' Then
3112:
3113: G_Stage := 'Got new Billable Flag: ' || Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value ||
3114: ' Index position: ' || to_char(i);
3115: If G_Debug_Mode = 'Y' Then

Line 3113: G_Stage := 'Got new Billable Flag: ' || Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value ||

3109: P_Timecard_Rec.Attribute10 := Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value;
3110:
3111: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Field_Name) = 'BILLABLE_FLAG' Then
3112:
3113: G_Stage := 'Got new Billable Flag: ' || Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value ||
3114: ' Index position: ' || to_char(i);
3115: If G_Debug_Mode = 'Y' Then
3116: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
3117: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);

Line 3120: P_Timecard_Rec.Billable_Flag := Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value;

3116: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
3117: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
3118: End If;
3119:
3120: P_Timecard_Rec.Billable_Flag := Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value;
3121:
3122: -- Begin PA.M/CWK changes
3123: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Field_Name) = 'PO LINE ID' Then
3124:

Line 3123: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Field_Name) = 'PO LINE ID' Then

3119:
3120: P_Timecard_Rec.Billable_Flag := Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value;
3121:
3122: -- Begin PA.M/CWK changes
3123: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Field_Name) = 'PO LINE ID' Then
3124:
3125: G_Stage := 'Retrieved Po Line Id: ' || Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value ||
3126: ' Index position: ' || to_char(i);
3127: If G_Debug_Mode = 'Y' Then

Line 3125: G_Stage := 'Retrieved Po Line Id: ' || Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value ||

3121:
3122: -- Begin PA.M/CWK changes
3123: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Field_Name) = 'PO LINE ID' Then
3124:
3125: G_Stage := 'Retrieved Po Line Id: ' || Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value ||
3126: ' Index position: ' || to_char(i);
3127: If G_Debug_Mode = 'Y' Then
3128: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
3129: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);

Line 3132: P_Timecard_Rec.PO_Line_Id := Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value;

3128: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
3129: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
3130: End If;
3131:
3132: P_Timecard_Rec.PO_Line_Id := Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value;
3133:
3134: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Field_Name) = 'PO PRICE TYPE' Then
3135:
3136: G_Stage := 'Retrieved Po Price Type: ' || Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value ||

Line 3134: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Field_Name) = 'PO PRICE TYPE' Then

3130: End If;
3131:
3132: P_Timecard_Rec.PO_Line_Id := Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value;
3133:
3134: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Field_Name) = 'PO PRICE TYPE' Then
3135:
3136: G_Stage := 'Retrieved Po Price Type: ' || Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value ||
3137: ' Index position: ' || to_char(i);
3138: If G_Debug_Mode = 'Y' Then

Line 3136: G_Stage := 'Retrieved Po Price Type: ' || Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value ||

3132: P_Timecard_Rec.PO_Line_Id := Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value;
3133:
3134: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Field_Name) = 'PO PRICE TYPE' Then
3135:
3136: G_Stage := 'Retrieved Po Price Type: ' || Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value ||
3137: ' Index position: ' || to_char(i);
3138: If G_Debug_Mode = 'Y' Then
3139: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
3140: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);

Line 3143: P_Timecard_Rec.PO_Price_Type := Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value;

3139: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
3140: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
3141: End If;
3142:
3143: P_Timecard_Rec.PO_Price_Type := Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).Value;
3144:
3145: -- End PA.M/CWK changes
3146: End If;
3147:

Line 3172: If i > Hxc_User_Type_Definition_Grp.T_Detail_Attributes.LAST Then

3168: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
3169: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
3170: End If;
3171:
3172: If i > Hxc_User_Type_Definition_Grp.T_Detail_Attributes.LAST Then
3173:
3174: G_Stage := 'Reached last record index position ' ||
3175: to_char(Hxc_User_Type_Definition_Grp.T_Detail_Attributes.LAST) || ' ' ||
3176: 'in NEW attrib pl/sql table.';

Line 3175: to_char(Hxc_User_Type_Definition_Grp.T_Detail_Attributes.LAST) || ' ' ||

3171:
3172: If i > Hxc_User_Type_Definition_Grp.T_Detail_Attributes.LAST Then
3173:
3174: G_Stage := 'Reached last record index position ' ||
3175: to_char(Hxc_User_Type_Definition_Grp.T_Detail_Attributes.LAST) || ' ' ||
3176: 'in NEW attrib pl/sql table.';
3177: If G_Debug_Mode = 'Y' Then
3178: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
3179: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);

Line 3182: ElsIf Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).BB_Id <> P_BB_Id Then

3178: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
3179: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
3180: End If;
3181:
3182: ElsIf Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).BB_Id <> P_BB_Id Then
3183:
3184: G_Stage := 'P_BB_Id: ' || to_char(P_BB_Id) || ' -- ' ||
3185: 'BB_Id in NEW attrib pl/sql: ' ||
3186: to_char(Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).BB_Id) || '. ' ||

Line 3186: to_char(Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).BB_Id) || '. ' ||

3182: ElsIf Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).BB_Id <> P_BB_Id Then
3183:
3184: G_Stage := 'P_BB_Id: ' || to_char(P_BB_Id) || ' -- ' ||
3185: 'BB_Id in NEW attrib pl/sql: ' ||
3186: to_char(Hxc_User_Type_Definition_Grp.T_Detail_Attributes(i).BB_Id) || '. ' ||
3187: 'They do not match!';
3188: If G_Debug_Mode = 'Y' Then
3189: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
3190: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);

Line 3239: to_char(Hxc_User_Type_Definition_Grp.T_Old_Detail_Bld_Blks(P_Old_Detl_Ind).Resource_Id);

3235:
3236: Elsif P_New_Old_BB = 'OLD' Then
3237:
3238: G_Stage := 'Got Old Detail Building Block data. Incurred by Person Id(Resource Id): ' ||
3239: to_char(Hxc_User_Type_Definition_Grp.T_Old_Detail_Bld_Blks(P_Old_Detl_Ind).Resource_Id);
3240: If G_Debug_Mode = 'Y' Then
3241: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
3242: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
3243: End If;

Line 3245: P_Timecard_Rec.Incurred_By_Person_Id := Hxc_User_Type_Definition_Grp.T_Old_Detail_Bld_Blks(P_Old_Detl_Ind).Resource_Id;

3241: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
3242: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
3243: End If;
3244:
3245: P_Timecard_Rec.Incurred_By_Person_Id := Hxc_User_Type_Definition_Grp.T_Old_Detail_Bld_Blks(P_Old_Detl_Ind).Resource_Id;
3246:
3247: G_Stage := 'Got Old Detail Building Block data. Incurred by Person Id';
3248: If G_Debug_Mode = 'Y' Then
3249: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;

Line 3254: to_char(Hxc_User_Type_Definition_Grp.T_Old_Detail_Bld_Blks(P_Old_Detl_Ind).Measure);

3250: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
3251: End If;
3252:
3253: G_Stage := 'Got Old Detail Building Block data. Quantity: ' ||
3254: to_char(Hxc_User_Type_Definition_Grp.T_Old_Detail_Bld_Blks(P_Old_Detl_Ind).Measure);
3255: If G_Debug_Mode = 'Y' Then
3256: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
3257: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
3258: End If;

Line 3260: P_Timecard_Rec.Quantity := Hxc_User_Type_Definition_Grp.T_Old_Detail_Bld_Blks(P_Old_Detl_Ind).Measure;

3256: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
3257: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
3258: End If;
3259:
3260: P_Timecard_Rec.Quantity := Hxc_User_Type_Definition_Grp.T_Old_Detail_Bld_Blks(P_Old_Detl_Ind).Measure;
3261:
3262: /* Begin bug 5412033 */
3263: G_Stage := 'Get Old Detail Building Block data. Expenditure Item Comment: ' ||
3264: Hxc_User_Type_Definition_Grp.T_Old_Detail_Bld_Blks(P_Old_Detl_Ind).Comment_Text ||

Line 3264: Hxc_User_Type_Definition_Grp.T_Old_Detail_Bld_Blks(P_Old_Detl_Ind).Comment_Text ||

3260: P_Timecard_Rec.Quantity := Hxc_User_Type_Definition_Grp.T_Old_Detail_Bld_Blks(P_Old_Detl_Ind).Measure;
3261:
3262: /* Begin bug 5412033 */
3263: G_Stage := 'Get Old Detail Building Block data. Expenditure Item Comment: ' ||
3264: Hxc_User_Type_Definition_Grp.T_Old_Detail_Bld_Blks(P_Old_Detl_Ind).Comment_Text ||
3265: '(End of comment)';
3266: If G_Debug_Mode = 'Y' Then
3267: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
3268: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);

Line 3276: l_comment_text := Hxc_User_Type_Definition_Grp.T_Old_Detail_Bld_Blks(P_Old_Detl_Ind).Comment_Text;

3272: If G_Debug_Mode = 'Y' Then
3273: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
3274: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
3275: End If;
3276: l_comment_text := Hxc_User_Type_Definition_Grp.T_Old_Detail_Bld_Blks(P_Old_Detl_Ind).Comment_Text;
3277:
3278: G_Stage := 'Checking if Old comment is not null.';
3279: If G_Debug_Mode = 'Y' Then
3280: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;

Line 3295: -- If length(Hxc_User_Type_Definition_Grp.T_Old_Detail_Bld_Blks(P_Old_Detl_Ind).Comment_Text) > 240 Then

3291:
3292: /* Bug 2930551 If the length of the comment_text is greater than 240 then we should only
3293: grab the first 240 characters. */
3294: -- begin bug 4926265
3295: -- If length(Hxc_User_Type_Definition_Grp.T_Old_Detail_Bld_Blks(P_Old_Detl_Ind).Comment_Text) > 240 Then
3296: -- If lengthb(Hxc_User_Type_Definition_Grp.T_Old_Detail_Bld_Blks(P_Old_Detl_Ind).Comment_Text) > 240 Then
3297: If lengthb(l_comment_text) > 240 Then
3298:
3299: If G_Debug_Mode = 'Y' Then

Line 3296: -- If lengthb(Hxc_User_Type_Definition_Grp.T_Old_Detail_Bld_Blks(P_Old_Detl_Ind).Comment_Text) > 240 Then

3292: /* Bug 2930551 If the length of the comment_text is greater than 240 then we should only
3293: grab the first 240 characters. */
3294: -- begin bug 4926265
3295: -- If length(Hxc_User_Type_Definition_Grp.T_Old_Detail_Bld_Blks(P_Old_Detl_Ind).Comment_Text) > 240 Then
3296: -- If lengthb(Hxc_User_Type_Definition_Grp.T_Old_Detail_Bld_Blks(P_Old_Detl_Ind).Comment_Text) > 240 Then
3297: If lengthb(l_comment_text) > 240 Then
3298:
3299: If G_Debug_Mode = 'Y' Then
3300: G_Stage := 'Old Comment_Text length > 240.';

Line 3306: -- substr(Hxc_User_Type_Definition_Grp.T_Old_Detail_Bld_Blks(P_Old_Detl_Ind).Comment_Text,1,240);

3302: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
3303: End If;
3304:
3305: -- P_Timecard_Rec.Expenditure_Item_Comment :=
3306: -- substr(Hxc_User_Type_Definition_Grp.T_Old_Detail_Bld_Blks(P_Old_Detl_Ind).Comment_Text,1,240);
3307: -- P_Timecard_Rec.Expenditure_Item_Comment :=
3308: -- substrb(Hxc_User_Type_Definition_Grp.T_Old_Detail_Bld_Blks(P_Old_Detl_Ind).Comment_Text,1,240);
3309: -- end bug 4926265
3310: P_Timecard_Rec.Expenditure_Item_Comment := substrb(l_comment_text,1,240);

Line 3308: -- substrb(Hxc_User_Type_Definition_Grp.T_Old_Detail_Bld_Blks(P_Old_Detl_Ind).Comment_Text,1,240);

3304:
3305: -- P_Timecard_Rec.Expenditure_Item_Comment :=
3306: -- substr(Hxc_User_Type_Definition_Grp.T_Old_Detail_Bld_Blks(P_Old_Detl_Ind).Comment_Text,1,240);
3307: -- P_Timecard_Rec.Expenditure_Item_Comment :=
3308: -- substrb(Hxc_User_Type_Definition_Grp.T_Old_Detail_Bld_Blks(P_Old_Detl_Ind).Comment_Text,1,240);
3309: -- end bug 4926265
3310: P_Timecard_Rec.Expenditure_Item_Comment := substrb(l_comment_text,1,240);
3311:
3312: Else

Line 3321: -- Hxc_User_Type_Definition_Grp.T_Old_Detail_Bld_Blks(P_Old_Detl_Ind).Comment_Text;

3317: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
3318: End If;
3319:
3320: -- P_Timecard_Rec.Expenditure_Item_Comment :=
3321: -- Hxc_User_Type_Definition_Grp.T_Old_Detail_Bld_Blks(P_Old_Detl_Ind).Comment_Text;
3322: P_Timecard_Rec.Expenditure_Item_Comment := l_comment_text;
3323:
3324: End If;
3325:

Line 3344: P_Timecard_Rec.Expenditure_Item_Date := Hxc_User_Type_Definition_Grp.T_Old_Detail_Bld_Blks(P_Old_Detl_Ind).Start_Time;

3340: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
3341: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
3342: End If;
3343:
3344: P_Timecard_Rec.Expenditure_Item_Date := Hxc_User_Type_Definition_Grp.T_Old_Detail_Bld_Blks(P_Old_Detl_Ind).Start_Time;
3345:
3346: If P_Timecard_Rec.Expenditure_Item_Date Is Null Then
3347:
3348: G_Stage := 'Get Old Day Building Block data. Exp Item Date. Second Attempt.';

Line 3362: While j <= Hxc_User_Type_Definition_Grp.T_Old_Day_Bld_Blks.LAST and NOT l_Rec_Found

3358: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
3359: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
3360: End If;
3361:
3362: While j <= Hxc_User_Type_Definition_Grp.T_Old_Day_Bld_Blks.LAST and NOT l_Rec_Found
3363: Loop
3364:
3365: G_Stage := 'Check if the current record is the correct DAY ' ||
3366: 'record to grab Exp Item Date from.';

Line 3372: If Hxc_User_Type_Definition_Grp.T_Day_Bld_Blks(j).BB_Id =

3368: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
3369: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
3370: End If;
3371:
3372: If Hxc_User_Type_Definition_Grp.T_Day_Bld_Blks(j).BB_Id =
3373: Hxc_User_Type_Definition_Grp.T_Old_Detail_Bld_Blks(P_Old_Detl_Ind).Parent_BB_Id Then
3374:
3375: G_Stage := 'Grab the Exp Item Date from old day building block record.';
3376: If G_Debug_Mode = 'Y' Then

Line 3373: Hxc_User_Type_Definition_Grp.T_Old_Detail_Bld_Blks(P_Old_Detl_Ind).Parent_BB_Id Then

3369: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
3370: End If;
3371:
3372: If Hxc_User_Type_Definition_Grp.T_Day_Bld_Blks(j).BB_Id =
3373: Hxc_User_Type_Definition_Grp.T_Old_Detail_Bld_Blks(P_Old_Detl_Ind).Parent_BB_Id Then
3374:
3375: G_Stage := 'Grab the Exp Item Date from old day building block record.';
3376: If G_Debug_Mode = 'Y' Then
3377: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;

Line 3381: P_Timecard_Rec.Expenditure_Item_Date := Trunc(Hxc_User_Type_Definition_Grp.T_Old_Day_Bld_Blks(j).Start_Time);

3377: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
3378: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
3379: End If;
3380:
3381: P_Timecard_Rec.Expenditure_Item_Date := Trunc(Hxc_User_Type_Definition_Grp.T_Old_Day_Bld_Blks(j).Start_Time);
3382: l_Rec_Found := TRUE;
3383:
3384: End If;
3385:

Line 3446: to_char(Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).BB_Id);

3442: Pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
3443: End If;
3444:
3445: G_Stage := 'Current position in OLD attribute pl/sql table bb_id value: ' ||
3446: to_char(Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).BB_Id);
3447: If G_Debug_Mode = 'Y' Then
3448: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
3449: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
3450: End If;

Line 3452: While j <= Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes.LAST and

3448: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
3449: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
3450: End If;
3451:
3452: While j <= Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes.LAST and
3453: Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).BB_Id = P_BB_Id
3454: Loop
3455:
3456: If Upper(Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Field_Name) = 'PROJECT_ID' Then

Line 3453: Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).BB_Id = P_BB_Id

3449: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
3450: End If;
3451:
3452: While j <= Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes.LAST and
3453: Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).BB_Id = P_BB_Id
3454: Loop
3455:
3456: If Upper(Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Field_Name) = 'PROJECT_ID' Then
3457:

Line 3456: If Upper(Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Field_Name) = 'PROJECT_ID' Then

3452: While j <= Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes.LAST and
3453: Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).BB_Id = P_BB_Id
3454: Loop
3455:
3456: If Upper(Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Field_Name) = 'PROJECT_ID' Then
3457:
3458: G_Stage := 'Got old Project Id: ' || Hxc_Generic_Retrieval_Pkg.T_Old_Detail_Attributes(j).Value ||
3459: ' Index position: ' || to_char(j);
3460: If G_Debug_Mode = 'Y' Then

Line 3465: P_Timecard_Rec.Project_Id := Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value;

3461: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
3462: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
3463: End If;
3464:
3465: P_Timecard_Rec.Project_Id := Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value;
3466:
3467: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Field_Name) = 'TASK_ID' Then
3468:
3469: G_Stage := 'Got old Task Id: ' || Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value ||

Line 3467: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Field_Name) = 'TASK_ID' Then

3463: End If;
3464:
3465: P_Timecard_Rec.Project_Id := Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value;
3466:
3467: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Field_Name) = 'TASK_ID' Then
3468:
3469: G_Stage := 'Got old Task Id: ' || Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value ||
3470: ' Index position: ' || to_char(j);
3471: If G_Debug_Mode = 'Y' Then

Line 3469: G_Stage := 'Got old Task Id: ' || Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value ||

3465: P_Timecard_Rec.Project_Id := Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value;
3466:
3467: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Field_Name) = 'TASK_ID' Then
3468:
3469: G_Stage := 'Got old Task Id: ' || Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value ||
3470: ' Index position: ' || to_char(j);
3471: If G_Debug_Mode = 'Y' Then
3472: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
3473: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);

Line 3476: P_Timecard_Rec.Task_Id := Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value;

3472: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
3473: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
3474: End If;
3475:
3476: P_Timecard_Rec.Task_Id := Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value;
3477:
3478: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Field_Name) = 'EXPENDITURE_TYPE' Then
3479:
3480: G_Stage := 'Got old Expenditure Type: ' ||

Line 3478: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Field_Name) = 'EXPENDITURE_TYPE' Then

3474: End If;
3475:
3476: P_Timecard_Rec.Task_Id := Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value;
3477:
3478: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Field_Name) = 'EXPENDITURE_TYPE' Then
3479:
3480: G_Stage := 'Got old Expenditure Type: ' ||
3481: Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value ||
3482: ' Index position: ' || to_char(j);

Line 3481: Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value ||

3477:
3478: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Field_Name) = 'EXPENDITURE_TYPE' Then
3479:
3480: G_Stage := 'Got old Expenditure Type: ' ||
3481: Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value ||
3482: ' Index position: ' || to_char(j);
3483: If G_Debug_Mode = 'Y' Then
3484: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
3485: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);

Line 3488: P_Timecard_Rec.Expenditure_Type := Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value;

3484: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
3485: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
3486: End If;
3487:
3488: P_Timecard_Rec.Expenditure_Type := Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value;
3489:
3490: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Field_Name) = 'SYSTEM_LINKAGE_FUNCTION' Then
3491:
3492: G_Stage := 'Got old System Linkage Function: ' ||

Line 3490: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Field_Name) = 'SYSTEM_LINKAGE_FUNCTION' Then

3486: End If;
3487:
3488: P_Timecard_Rec.Expenditure_Type := Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value;
3489:
3490: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Field_Name) = 'SYSTEM_LINKAGE_FUNCTION' Then
3491:
3492: G_Stage := 'Got old System Linkage Function: ' ||
3493: Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value ||
3494: ' Index position: ' || to_char(j);

Line 3493: Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value ||

3489:
3490: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Field_Name) = 'SYSTEM_LINKAGE_FUNCTION' Then
3491:
3492: G_Stage := 'Got old System Linkage Function: ' ||
3493: Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value ||
3494: ' Index position: ' || to_char(j);
3495: If G_Debug_Mode = 'Y' Then
3496: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
3497: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);

Line 3500: P_Timecard_Rec.System_Linkage_Function := Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value;

3496: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
3497: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
3498: End If;
3499:
3500: P_Timecard_Rec.System_Linkage_Function := Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value;
3501:
3502: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Field_Name) = 'OVERRIDING_APPROVER_PERSON_ID' Then
3503:
3504: G_Stage := 'Got old Overriding Approver Person Id: ' ||

Line 3502: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Field_Name) = 'OVERRIDING_APPROVER_PERSON_ID' Then

3498: End If;
3499:
3500: P_Timecard_Rec.System_Linkage_Function := Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value;
3501:
3502: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Field_Name) = 'OVERRIDING_APPROVER_PERSON_ID' Then
3503:
3504: G_Stage := 'Got old Overriding Approver Person Id: ' ||
3505: Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value ||
3506: ' Index position: ' || to_char(j);

Line 3505: Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value ||

3501:
3502: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Field_Name) = 'OVERRIDING_APPROVER_PERSON_ID' Then
3503:
3504: G_Stage := 'Got old Overriding Approver Person Id: ' ||
3505: Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value ||
3506: ' Index position: ' || to_char(j);
3507: If G_Debug_Mode = 'Y' Then
3508: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
3509: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);

Line 3512: P_Timecard_Rec.Override_Approver_Person_Id := Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value;

3508: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
3509: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
3510: End If;
3511:
3512: P_Timecard_Rec.Override_Approver_Person_Id := Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value;
3513:
3514: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Field_Name) = 'DUMMY PAEXPITDFF CONTEXT' Then
3515:
3516: /* The value column contains the following format:

Line 3514: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Field_Name) = 'DUMMY PAEXPITDFF CONTEXT' Then

3510: End If;
3511:
3512: P_Timecard_Rec.Override_Approver_Person_Id := Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value;
3513:
3514: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Field_Name) = 'DUMMY PAEXPITDFF CONTEXT' Then
3515:
3516: /* The value column contains the following format:
3517: * 'PAEXPITDFF - '
3518: * So to get the attribute_category out will need to find the position

Line 3523: Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value ||

3519: * for ' - ' that is: '-' and then add 3.
3520: */
3521:
3522: G_Stage := 'Get old attribute category info: ' ||
3523: Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value ||
3524: ' Index position: ' || to_char(j);
3525: If G_Debug_Mode = 'Y' Then
3526: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
3527: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);

Line 3530: l_attribute_category := Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value;

3526: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
3527: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
3528: End If;
3529:
3530: l_attribute_category := Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value;
3531:
3532: /* Need to check for null to avoid the unecessary errors using instr
3533: * avoiding unhandled exceptions.
3534: */

Line 3553: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Field_Name) = 'PADFFATTRIBUTE1' Then

3549: P_Timecard_Rec.Attribute_Category := substr(l_attribute_category,instr(l_attribute_category,' - ') + 3);
3550:
3551: End If;
3552:
3553: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Field_Name) = 'PADFFATTRIBUTE1' Then
3554:
3555: G_Stage := 'Got old Attribute1: ' ||
3556: Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value ||
3557: ' Index position: ' || to_char(j);

Line 3556: Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value ||

3552:
3553: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Field_Name) = 'PADFFATTRIBUTE1' Then
3554:
3555: G_Stage := 'Got old Attribute1: ' ||
3556: Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value ||
3557: ' Index position: ' || to_char(j);
3558: If G_Debug_Mode = 'Y' Then
3559: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
3560: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);

Line 3563: P_Timecard_Rec.Attribute1 := Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value;

3559: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
3560: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
3561: End If;
3562:
3563: P_Timecard_Rec.Attribute1 := Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value;
3564:
3565: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Field_Name) = 'PADFFATTRIBUTE2' Then
3566:
3567: G_Stage := 'Got old Attribute2: ' ||

Line 3565: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Field_Name) = 'PADFFATTRIBUTE2' Then

3561: End If;
3562:
3563: P_Timecard_Rec.Attribute1 := Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value;
3564:
3565: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Field_Name) = 'PADFFATTRIBUTE2' Then
3566:
3567: G_Stage := 'Got old Attribute2: ' ||
3568: Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value ||
3569: ' Index position: ' || to_char(j);

Line 3568: Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value ||

3564:
3565: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Field_Name) = 'PADFFATTRIBUTE2' Then
3566:
3567: G_Stage := 'Got old Attribute2: ' ||
3568: Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value ||
3569: ' Index position: ' || to_char(j);
3570: If G_Debug_Mode = 'Y' Then
3571: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
3572: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);

Line 3575: P_Timecard_Rec.Attribute2 := Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value;

3571: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
3572: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
3573: End If;
3574:
3575: P_Timecard_Rec.Attribute2 := Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value;
3576:
3577: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Field_Name) = 'PADFFATTRIBUTE3' Then
3578:
3579: G_Stage := 'Got old Attribute3: ' ||

Line 3577: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Field_Name) = 'PADFFATTRIBUTE3' Then

3573: End If;
3574:
3575: P_Timecard_Rec.Attribute2 := Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value;
3576:
3577: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Field_Name) = 'PADFFATTRIBUTE3' Then
3578:
3579: G_Stage := 'Got old Attribute3: ' ||
3580: Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value ||
3581: ' Index position: ' || to_char(j);

Line 3580: Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value ||

3576:
3577: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Field_Name) = 'PADFFATTRIBUTE3' Then
3578:
3579: G_Stage := 'Got old Attribute3: ' ||
3580: Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value ||
3581: ' Index position: ' || to_char(j);
3582: If G_Debug_Mode = 'Y' Then
3583: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
3584: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);

Line 3587: P_Timecard_Rec.Attribute3 := Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value;

3583: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
3584: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
3585: End If;
3586:
3587: P_Timecard_Rec.Attribute3 := Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value;
3588:
3589: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Field_Name) = 'PADFFATTRIBUTE4' Then
3590:
3591: G_Stage := 'Got old Attribute4: ' ||

Line 3589: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Field_Name) = 'PADFFATTRIBUTE4' Then

3585: End If;
3586:
3587: P_Timecard_Rec.Attribute3 := Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value;
3588:
3589: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Field_Name) = 'PADFFATTRIBUTE4' Then
3590:
3591: G_Stage := 'Got old Attribute4: ' ||
3592: Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value ||
3593: ' Index position: ' || to_char(j);

Line 3592: Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value ||

3588:
3589: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Field_Name) = 'PADFFATTRIBUTE4' Then
3590:
3591: G_Stage := 'Got old Attribute4: ' ||
3592: Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value ||
3593: ' Index position: ' || to_char(j);
3594: If G_Debug_Mode = 'Y' Then
3595: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
3596: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);

Line 3599: P_Timecard_Rec.Attribute4 := Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value;

3595: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
3596: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
3597: End If;
3598:
3599: P_Timecard_Rec.Attribute4 := Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value;
3600:
3601: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Field_Name) = 'PADFFATTRIBUTE5' Then
3602:
3603: G_Stage := 'Got old Attribute5: ' ||

Line 3601: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Field_Name) = 'PADFFATTRIBUTE5' Then

3597: End If;
3598:
3599: P_Timecard_Rec.Attribute4 := Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value;
3600:
3601: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Field_Name) = 'PADFFATTRIBUTE5' Then
3602:
3603: G_Stage := 'Got old Attribute5: ' ||
3604: Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value ||
3605: ' Index position: ' || to_char(j);

Line 3604: Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value ||

3600:
3601: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Field_Name) = 'PADFFATTRIBUTE5' Then
3602:
3603: G_Stage := 'Got old Attribute5: ' ||
3604: Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value ||
3605: ' Index position: ' || to_char(j);
3606: If G_Debug_Mode = 'Y' Then
3607: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
3608: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);

Line 3611: P_Timecard_Rec.Attribute5 := Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value;

3607: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
3608: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
3609: End If;
3610:
3611: P_Timecard_Rec.Attribute5 := Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value;
3612:
3613: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Field_Name) = 'PADFFATTRIBUTE6' Then
3614:
3615: G_Stage := 'Got old Attribute6: ' ||

Line 3613: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Field_Name) = 'PADFFATTRIBUTE6' Then

3609: End If;
3610:
3611: P_Timecard_Rec.Attribute5 := Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value;
3612:
3613: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Field_Name) = 'PADFFATTRIBUTE6' Then
3614:
3615: G_Stage := 'Got old Attribute6: ' ||
3616: Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value ||
3617: ' Index position: ' || to_char(j);

Line 3616: Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value ||

3612:
3613: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Field_Name) = 'PADFFATTRIBUTE6' Then
3614:
3615: G_Stage := 'Got old Attribute6: ' ||
3616: Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value ||
3617: ' Index position: ' || to_char(j);
3618: If G_Debug_Mode = 'Y' Then
3619: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
3620: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);

Line 3623: P_Timecard_Rec.Attribute6 := Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value;

3619: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
3620: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
3621: End If;
3622:
3623: P_Timecard_Rec.Attribute6 := Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value;
3624:
3625: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Field_Name) = 'PADFFATTRIBUTE7' Then
3626:
3627: G_Stage := 'Got old Attribute7: ' ||

Line 3625: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Field_Name) = 'PADFFATTRIBUTE7' Then

3621: End If;
3622:
3623: P_Timecard_Rec.Attribute6 := Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value;
3624:
3625: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Field_Name) = 'PADFFATTRIBUTE7' Then
3626:
3627: G_Stage := 'Got old Attribute7: ' ||
3628: Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value ||
3629: ' Index position: ' || to_char(j);

Line 3628: Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value ||

3624:
3625: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Field_Name) = 'PADFFATTRIBUTE7' Then
3626:
3627: G_Stage := 'Got old Attribute7: ' ||
3628: Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value ||
3629: ' Index position: ' || to_char(j);
3630: If G_Debug_Mode = 'Y' Then
3631: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
3632: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);

Line 3635: P_Timecard_Rec.Attribute7 := Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value;

3631: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
3632: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
3633: End If;
3634:
3635: P_Timecard_Rec.Attribute7 := Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value;
3636:
3637: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Field_Name) = 'PADFFATTRIBUTE8' Then
3638:
3639: G_Stage := 'Got old Attribute8: ' ||

Line 3637: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Field_Name) = 'PADFFATTRIBUTE8' Then

3633: End If;
3634:
3635: P_Timecard_Rec.Attribute7 := Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value;
3636:
3637: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Field_Name) = 'PADFFATTRIBUTE8' Then
3638:
3639: G_Stage := 'Got old Attribute8: ' ||
3640: Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value ||
3641: ' Index position: ' || to_char(j);

Line 3640: Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value ||

3636:
3637: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Field_Name) = 'PADFFATTRIBUTE8' Then
3638:
3639: G_Stage := 'Got old Attribute8: ' ||
3640: Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value ||
3641: ' Index position: ' || to_char(j);
3642: If G_Debug_Mode = 'Y' Then
3643: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
3644: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);

Line 3647: P_Timecard_Rec.Attribute8 := Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value;

3643: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
3644: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
3645: End If;
3646:
3647: P_Timecard_Rec.Attribute8 := Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value;
3648:
3649: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Field_Name) = 'PADFFATTRIBUTE9' Then
3650:
3651: G_Stage := 'Got old Attribute9: ' ||

Line 3649: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Field_Name) = 'PADFFATTRIBUTE9' Then

3645: End If;
3646:
3647: P_Timecard_Rec.Attribute8 := Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value;
3648:
3649: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Field_Name) = 'PADFFATTRIBUTE9' Then
3650:
3651: G_Stage := 'Got old Attribute9: ' ||
3652: Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value ||
3653: ' Index position: ' || to_char(j);

Line 3652: Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value ||

3648:
3649: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Field_Name) = 'PADFFATTRIBUTE9' Then
3650:
3651: G_Stage := 'Got old Attribute9: ' ||
3652: Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value ||
3653: ' Index position: ' || to_char(j);
3654: If G_Debug_Mode = 'Y' Then
3655: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
3656: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);

Line 3659: P_Timecard_Rec.Attribute9 := Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value;

3655: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
3656: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
3657: End If;
3658:
3659: P_Timecard_Rec.Attribute9 := Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value;
3660:
3661: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Field_Name) = 'PADFFATTRIBUTE10' Then
3662:
3663: G_Stage := 'Got old Attribute10: ' ||

Line 3661: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Field_Name) = 'PADFFATTRIBUTE10' Then

3657: End If;
3658:
3659: P_Timecard_Rec.Attribute9 := Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value;
3660:
3661: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Field_Name) = 'PADFFATTRIBUTE10' Then
3662:
3663: G_Stage := 'Got old Attribute10: ' ||
3664: Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value ||
3665: ' Index position: ' || to_char(j);

Line 3664: Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value ||

3660:
3661: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Field_Name) = 'PADFFATTRIBUTE10' Then
3662:
3663: G_Stage := 'Got old Attribute10: ' ||
3664: Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value ||
3665: ' Index position: ' || to_char(j);
3666: If G_Debug_Mode = 'Y' Then
3667: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
3668: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);

Line 3671: P_Timecard_Rec.Attribute10 := Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value;

3667: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
3668: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
3669: End If;
3670:
3671: P_Timecard_Rec.Attribute10 := Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value;
3672:
3673: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Field_Name) = 'BILLABLE_FLAG' Then
3674:
3675: G_Stage := 'Got old Billable Flag: ' ||

Line 3673: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Field_Name) = 'BILLABLE_FLAG' Then

3669: End If;
3670:
3671: P_Timecard_Rec.Attribute10 := Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value;
3672:
3673: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Field_Name) = 'BILLABLE_FLAG' Then
3674:
3675: G_Stage := 'Got old Billable Flag: ' ||
3676: Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value ||
3677: ' Index position: ' || to_char(j);

Line 3676: Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value ||

3672:
3673: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Field_Name) = 'BILLABLE_FLAG' Then
3674:
3675: G_Stage := 'Got old Billable Flag: ' ||
3676: Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value ||
3677: ' Index position: ' || to_char(j);
3678: If G_Debug_Mode = 'Y' Then
3679: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
3680: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);

Line 3683: P_Timecard_Rec.Billable_Flag := Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value;

3679: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
3680: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
3681: End If;
3682:
3683: P_Timecard_Rec.Billable_Flag := Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value;
3684:
3685: -- Begin PA.M/CWK changes
3686: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Field_Name) = 'PO LINE ID' Then
3687:

Line 3686: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Field_Name) = 'PO LINE ID' Then

3682:
3683: P_Timecard_Rec.Billable_Flag := Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value;
3684:
3685: -- Begin PA.M/CWK changes
3686: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Field_Name) = 'PO LINE ID' Then
3687:
3688: G_Stage := 'Got old Po Line Id: ' ||
3689: Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value ||
3690: ' Index position: ' || to_char(j);

Line 3689: Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value ||

3685: -- Begin PA.M/CWK changes
3686: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Field_Name) = 'PO LINE ID' Then
3687:
3688: G_Stage := 'Got old Po Line Id: ' ||
3689: Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value ||
3690: ' Index position: ' || to_char(j);
3691: If G_Debug_Mode = 'Y' Then
3692: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
3693: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);

Line 3696: P_Timecard_Rec.PO_Line_Id := Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value;

3692: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
3693: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
3694: End If;
3695:
3696: P_Timecard_Rec.PO_Line_Id := Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value;
3697:
3698: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Field_Name) = 'PO PRICE TYPE' Then
3699:
3700: G_Stage := 'Got old PO Price Type: ' ||

Line 3698: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Field_Name) = 'PO PRICE TYPE' Then

3694: End If;
3695:
3696: P_Timecard_Rec.PO_Line_Id := Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value;
3697:
3698: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Field_Name) = 'PO PRICE TYPE' Then
3699:
3700: G_Stage := 'Got old PO Price Type: ' ||
3701: Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value ||
3702: ' Index position: ' || to_char(j);

Line 3701: Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value ||

3697:
3698: ElsIf Upper(Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Field_Name) = 'PO PRICE TYPE' Then
3699:
3700: G_Stage := 'Got old PO Price Type: ' ||
3701: Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value ||
3702: ' Index position: ' || to_char(j);
3703: If G_Debug_Mode = 'Y' Then
3704: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
3705: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);

Line 3708: P_Timecard_Rec.PO_Price_Type := Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value;

3704: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
3705: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
3706: End If;
3707:
3708: P_Timecard_Rec.PO_Price_Type := Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).Value;
3709:
3710: -- End PA.M/CWK changes
3711: End If;
3712:

Line 3737: If j > Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes.LAST Then

3733: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
3734: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
3735: End If;
3736:
3737: If j > Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes.LAST Then
3738:
3739: G_Stage := 'Reached last record index position ' ||
3740: to_char(Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes.LAST) || ' ' ||
3741: 'in OLD attrib pl/sql table.';

Line 3740: to_char(Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes.LAST) || ' ' ||

3736:
3737: If j > Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes.LAST Then
3738:
3739: G_Stage := 'Reached last record index position ' ||
3740: to_char(Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes.LAST) || ' ' ||
3741: 'in OLD attrib pl/sql table.';
3742: If G_Debug_Mode = 'Y' Then
3743: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
3744: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);

Line 3747: ElsIf Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).BB_Id <> P_BB_Id Then

3743: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
3744: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
3745: End If;
3746:
3747: ElsIf Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).BB_Id <> P_BB_Id Then
3748:
3749: G_Stage := 'P_BB_Id: ' || to_char(P_BB_Id) || ' -- ' ||
3750: 'BB_Id in OLD attrib pl/sql: ' ||
3751: to_char(Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).BB_Id) || '. ' ||

Line 3751: to_char(Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).BB_Id) || '. ' ||

3747: ElsIf Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).BB_Id <> P_BB_Id Then
3748:
3749: G_Stage := 'P_BB_Id: ' || to_char(P_BB_Id) || ' -- ' ||
3750: 'BB_Id in OLD attrib pl/sql: ' ||
3751: to_char(Hxc_User_Type_Definition_Grp.T_Old_Detail_Attributes(j).BB_Id) || '. ' ||
3752: 'They do not match!';
3753: If G_Debug_Mode = 'Y' Then
3754: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
3755: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);

Line 3959: For i in Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks.FIRST .. Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks.LAST

3955: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
3956: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
3957: End If;
3958:
3959: For i in Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks.FIRST .. Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks.LAST
3960: Loop
3961:
3962: G_Stage := 'Determine if BB_Id in the pl/sql matches the one provided.';
3963: If G_Debug_Mode = 'Y' Then

Line 3968: If Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).BB_Id = P_Detail_BB_Id Then

3964: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;
3965: pa_cc_utils.log_message(Pa_Debug.G_Err_Stage,0);
3966: End If;
3967:
3968: If Hxc_User_Type_Definition_Grp.T_Detail_Bld_Blks(i).BB_Id = P_Detail_BB_Id Then
3969:
3970: G_Stage := 'Set Index to use since found the one needed.';
3971: If G_Debug_Mode = 'Y' Then
3972: Pa_Debug.G_err_Stage := 'Pa_Otc_Api ::: ' || G_Path || ' :: ' || G_Stage;

Line 4060: l_Blocks Hxc_User_Type_Definition_Grp.Timecard_Info;

4056: (P_Operation IN Varchar2)
4057:
4058: Is
4059:
4060: l_Blocks Hxc_User_Type_Definition_Grp.Timecard_Info;
4061: l_Attributes Hxc_User_Type_Definition_Grp.App_Attributes_Info;
4062: l_Messages Hxc_User_Type_Definition_Grp.Message_Table;
4063:
4064: Begin

Line 4061: l_Attributes Hxc_User_Type_Definition_Grp.App_Attributes_Info;

4057:
4058: Is
4059:
4060: l_Blocks Hxc_User_Type_Definition_Grp.Timecard_Info;
4061: l_Attributes Hxc_User_Type_Definition_Grp.App_Attributes_Info;
4062: l_Messages Hxc_User_Type_Definition_Grp.Message_Table;
4063:
4064: Begin
4065:

Line 4062: l_Messages Hxc_User_Type_Definition_Grp.Message_Table;

4058: Is
4059:
4060: l_Blocks Hxc_User_Type_Definition_Grp.Timecard_Info;
4061: l_Attributes Hxc_User_Type_Definition_Grp.App_Attributes_Info;
4062: l_Messages Hxc_User_Type_Definition_Grp.Message_Table;
4063:
4064: Begin
4065:
4066: G_Path := ' ';

Line 4121: -- P_Building_Blocks -- Hxc_User_Type_Definition_Grp.Timecard_Info

4117: --
4118: -- Parameters:
4119: -- IN
4120: -- P_Operation -- Varchar2
4121: -- P_Building_Blocks -- Hxc_User_Type_Definition_Grp.Timecard_Info
4122: -- P_Attribute_Table -- Hxc_User_Type_Definition_Grp.App_Attributes_Info
4123: -- OUT
4124: -- P_Building_Blocks -- Hxc_User_Type_Definition_Grp.Timecard_Info
4125: -- P_Attribute_Table -- Hxc_User_Type_Definition_Grp.App_Attributes_Info

Line 4122: -- P_Attribute_Table -- Hxc_User_Type_Definition_Grp.App_Attributes_Info

4118: -- Parameters:
4119: -- IN
4120: -- P_Operation -- Varchar2
4121: -- P_Building_Blocks -- Hxc_User_Type_Definition_Grp.Timecard_Info
4122: -- P_Attribute_Table -- Hxc_User_Type_Definition_Grp.App_Attributes_Info
4123: -- OUT
4124: -- P_Building_Blocks -- Hxc_User_Type_Definition_Grp.Timecard_Info
4125: -- P_Attribute_Table -- Hxc_User_Type_Definition_Grp.App_Attributes_Info
4126:

Line 4124: -- P_Building_Blocks -- Hxc_User_Type_Definition_Grp.Timecard_Info

4120: -- P_Operation -- Varchar2
4121: -- P_Building_Blocks -- Hxc_User_Type_Definition_Grp.Timecard_Info
4122: -- P_Attribute_Table -- Hxc_User_Type_Definition_Grp.App_Attributes_Info
4123: -- OUT
4124: -- P_Building_Blocks -- Hxc_User_Type_Definition_Grp.Timecard_Info
4125: -- P_Attribute_Table -- Hxc_User_Type_Definition_Grp.App_Attributes_Info
4126:
4127: /*------------------------------------------------------------------------- */
4128:

Line 4125: -- P_Attribute_Table -- Hxc_User_Type_Definition_Grp.App_Attributes_Info

4121: -- P_Building_Blocks -- Hxc_User_Type_Definition_Grp.Timecard_Info
4122: -- P_Attribute_Table -- Hxc_User_Type_Definition_Grp.App_Attributes_Info
4123: -- OUT
4124: -- P_Building_Blocks -- Hxc_User_Type_Definition_Grp.Timecard_Info
4125: -- P_Attribute_Table -- Hxc_User_Type_Definition_Grp.App_Attributes_Info
4126:
4127: /*------------------------------------------------------------------------- */
4128:
4129: Procedure Update_Process(

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

4127: /*------------------------------------------------------------------------- */
4128:
4129: Procedure Update_Process(
4130: P_Operation IN Varchar2,
4131: P_Building_Blocks IN OUT NOCOPY Hxc_User_Type_Definition_Grp.Timecard_Info, -- 2672653
4132: P_Attribute_Table IN OUT NOCOPY Hxc_User_Type_Definition_Grp.App_Attributes_Info) -- 2672653
4133:
4134: Is
4135:

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

4128:
4129: Procedure Update_Process(
4130: P_Operation IN Varchar2,
4131: P_Building_Blocks IN OUT NOCOPY Hxc_User_Type_Definition_Grp.Timecard_Info, -- 2672653
4132: P_Attribute_Table IN OUT NOCOPY Hxc_User_Type_Definition_Grp.App_Attributes_Info) -- 2672653
4133:
4134: Is
4135:
4136: l_Proj_Attrib_Rec Pa_Otc_Api.Project_Attribution_Rec;

Line 4139: l_Building_Block_Record Hxc_User_Type_Definition_Grp.Building_Block_Info;

4135:
4136: l_Proj_Attrib_Rec Pa_Otc_Api.Project_Attribution_Rec;
4137:
4138: /* Stores a single record from the Building Block Table */
4139: l_Building_Block_Record Hxc_User_Type_Definition_Grp.Building_Block_Info;
4140:
4141: l_BB_Detail_Changed Varchar2(1) := 'N'; -- The OTL item has changed.
4142: l_BB_Detail_Deleted Varchar2(1) := 'N'; -- The OTL item has been deleted.
4143: l_BB_Detail_Pass Varchar2(1) := 'N'; -- The OTL item has changed but values same as in Projects

Line 4349: l_Blocks Hxc_User_Type_Definition_Grp.Timecard_Info;

4345: (P_Operation IN Varchar2)
4346:
4347: Is
4348:
4349: l_Blocks Hxc_User_Type_Definition_Grp.Timecard_Info;
4350: l_Attributes Hxc_User_Type_Definition_Grp.App_Attributes_Info;
4351: l_Messages Hxc_User_Type_Definition_Grp.Message_Table;
4352:
4353: Begin

Line 4350: l_Attributes Hxc_User_Type_Definition_Grp.App_Attributes_Info;

4346:
4347: Is
4348:
4349: l_Blocks Hxc_User_Type_Definition_Grp.Timecard_Info;
4350: l_Attributes Hxc_User_Type_Definition_Grp.App_Attributes_Info;
4351: l_Messages Hxc_User_Type_Definition_Grp.Message_Table;
4352:
4353: Begin
4354:

Line 4351: l_Messages Hxc_User_Type_Definition_Grp.Message_Table;

4347: Is
4348:
4349: l_Blocks Hxc_User_Type_Definition_Grp.Timecard_Info;
4350: l_Attributes Hxc_User_Type_Definition_Grp.App_Attributes_Info;
4351: l_Messages Hxc_User_Type_Definition_Grp.Message_Table;
4352:
4353: Begin
4354:
4355: G_Path := ' ';

Line 4413: -- P_Building_Blocks -- Hxc_User_Type_Definition_Grp.Timecard_Info

4409: --
4410: -- Parameters :
4411: -- IN
4412: -- P_Operation -- Varchar2
4413: -- P_Building_Blocks -- Hxc_User_Type_Definition_Grp.Timecard_Info
4414: -- P_Attribute_Table -- Hxc_User_Type_Definition_Grp.App_Attributes_Info
4415: -- OUT
4416: -- P_Message_Table -- Hxc_User_Type_Definition_Grp.Message_Table
4417:

Line 4414: -- P_Attribute_Table -- Hxc_User_Type_Definition_Grp.App_Attributes_Info

4410: -- Parameters :
4411: -- IN
4412: -- P_Operation -- Varchar2
4413: -- P_Building_Blocks -- Hxc_User_Type_Definition_Grp.Timecard_Info
4414: -- P_Attribute_Table -- Hxc_User_Type_Definition_Grp.App_Attributes_Info
4415: -- OUT
4416: -- P_Message_Table -- Hxc_User_Type_Definition_Grp.Message_Table
4417:
4418: /*------------------------------------------------------------------------- */

Line 4416: -- P_Message_Table -- Hxc_User_Type_Definition_Grp.Message_Table

4412: -- P_Operation -- Varchar2
4413: -- P_Building_Blocks -- Hxc_User_Type_Definition_Grp.Timecard_Info
4414: -- P_Attribute_Table -- Hxc_User_Type_Definition_Grp.App_Attributes_Info
4415: -- OUT
4416: -- P_Message_Table -- Hxc_User_Type_Definition_Grp.Message_Table
4417:
4418: /*------------------------------------------------------------------------- */
4419:
4420: Procedure Validate_Process(

Line 4422: P_Building_Blocks IN Hxc_User_Type_Definition_Grp.Timecard_Info,

4418: /*------------------------------------------------------------------------- */
4419:
4420: Procedure Validate_Process(
4421: P_Operation IN Varchar2,
4422: P_Building_Blocks IN Hxc_User_Type_Definition_Grp.Timecard_Info,
4423: P_Attribute_Table IN Hxc_User_Type_Definition_Grp.App_Attributes_Info,
4424: P_Message_Table IN OUT NOCOPY Hxc_User_Type_Definition_Grp.Message_Table) -- 2672653
4425:
4426: Is

Line 4423: P_Attribute_Table IN Hxc_User_Type_Definition_Grp.App_Attributes_Info,

4419:
4420: Procedure Validate_Process(
4421: P_Operation IN Varchar2,
4422: P_Building_Blocks IN Hxc_User_Type_Definition_Grp.Timecard_Info,
4423: P_Attribute_Table IN Hxc_User_Type_Definition_Grp.App_Attributes_Info,
4424: P_Message_Table IN OUT NOCOPY Hxc_User_Type_Definition_Grp.Message_Table) -- 2672653
4425:
4426: Is
4427:

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

4420: Procedure Validate_Process(
4421: P_Operation IN Varchar2,
4422: P_Building_Blocks IN Hxc_User_Type_Definition_Grp.Timecard_Info,
4423: P_Attribute_Table IN Hxc_User_Type_Definition_Grp.App_Attributes_Info,
4424: P_Message_Table IN OUT NOCOPY Hxc_User_Type_Definition_Grp.Message_Table) -- 2672653
4425:
4426: Is
4427:
4428: l_Status Varchar2(30) := Null;

Line 4503: l_Building_Block_Record Hxc_User_Type_Definition_Grp.Building_Block_Info;

4499:
4500: l_Exp_End_Date_Tab Exp_End_Date_Tab;
4501:
4502: /* Stores a single record from the Building Block Table */
4503: l_Building_Block_Record Hxc_User_Type_Definition_Grp.Building_Block_Info;
4504:
4505: Cursor GetBillFlagMeaning(P_Lookup_Code IN VARCHAR2) Is
4506: Select
4507: Meaning

Line 6521: -- IN P_Building_Block_Rec - Hxc_User_Type_Definition_Grp.Building_Block_Info

6517: -- Function : This procedure is used to pull out the needed project specific data from
6518: -- the OTL pl/sql table P_Attribute_Table.
6519: --
6520: -- Parameters :
6521: -- IN P_Building_Block_Rec - Hxc_User_Type_Definition_Grp.Building_Block_Info
6522: -- P_Building_Block - Hxc_User_Type_Definition_Grp.Timecard_Info
6523: -- P_Attribute_Table - Hxc_User_Type_Definition_Grp.App_Attributes_Info
6524: -- X_Detail_Attr_Changed - Varchar2
6525: -- OUT

Line 6522: -- P_Building_Block - Hxc_User_Type_Definition_Grp.Timecard_Info

6518: -- the OTL pl/sql table P_Attribute_Table.
6519: --
6520: -- Parameters :
6521: -- IN P_Building_Block_Rec - Hxc_User_Type_Definition_Grp.Building_Block_Info
6522: -- P_Building_Block - Hxc_User_Type_Definition_Grp.Timecard_Info
6523: -- P_Attribute_Table - Hxc_User_Type_Definition_Grp.App_Attributes_Info
6524: -- X_Detail_Attr_Changed - Varchar2
6525: -- OUT
6526: -- X_Detail_Attr_Changed - Varchar2

Line 6523: -- P_Attribute_Table - Hxc_User_Type_Definition_Grp.App_Attributes_Info

6519: --
6520: -- Parameters :
6521: -- IN P_Building_Block_Rec - Hxc_User_Type_Definition_Grp.Building_Block_Info
6522: -- P_Building_Block - Hxc_User_Type_Definition_Grp.Timecard_Info
6523: -- P_Attribute_Table - Hxc_User_Type_Definition_Grp.App_Attributes_Info
6524: -- X_Detail_Attr_Changed - Varchar2
6525: -- OUT
6526: -- X_Detail_Attr_Changed - Varchar2
6527: -- X_Proj_Attrib_Rec - Pa_Otc_Api.Project_Attribution_Rec

Line 6533: P_Building_Block_Rec IN Hxc_User_Type_Definition_Grp.Building_Block_Info,

6529:
6530: /*--------------------------------------------------------------------------*/
6531:
6532: Procedure RetrieveProjAttribution(
6533: P_Building_Block_Rec IN Hxc_User_Type_Definition_Grp.Building_Block_Info,
6534: P_Building_Block IN Hxc_User_Type_Definition_Grp.Timecard_Info,
6535: P_Attribute_Table IN Hxc_User_Type_Definition_Grp.App_Attributes_Info,
6536: X_Detail_Attr_Changed IN OUT NOCOPY Varchar2,
6537: X_Proj_Attrib_Rec OUT NOCOPY Pa_Otc_Api.Project_Attribution_Rec) -- 2672653

Line 6534: P_Building_Block IN Hxc_User_Type_Definition_Grp.Timecard_Info,

6530: /*--------------------------------------------------------------------------*/
6531:
6532: Procedure RetrieveProjAttribution(
6533: P_Building_Block_Rec IN Hxc_User_Type_Definition_Grp.Building_Block_Info,
6534: P_Building_Block IN Hxc_User_Type_Definition_Grp.Timecard_Info,
6535: P_Attribute_Table IN Hxc_User_Type_Definition_Grp.App_Attributes_Info,
6536: X_Detail_Attr_Changed IN OUT NOCOPY Varchar2,
6537: X_Proj_Attrib_Rec OUT NOCOPY Pa_Otc_Api.Project_Attribution_Rec) -- 2672653
6538:

Line 6535: P_Attribute_Table IN Hxc_User_Type_Definition_Grp.App_Attributes_Info,

6531:
6532: Procedure RetrieveProjAttribution(
6533: P_Building_Block_Rec IN Hxc_User_Type_Definition_Grp.Building_Block_Info,
6534: P_Building_Block IN Hxc_User_Type_Definition_Grp.Timecard_Info,
6535: P_Attribute_Table IN Hxc_User_Type_Definition_Grp.App_Attributes_Info,
6536: X_Detail_Attr_Changed IN OUT NOCOPY Varchar2,
6537: X_Proj_Attrib_Rec OUT NOCOPY Pa_Otc_Api.Project_Attribution_Rec) -- 2672653
6538:
6539: Is

Line 6886: -- IN P_Building_Block_Rec - Hxc_User_Type_Definition_Grp.Building_Block_Info

6882: -- Function : This procedure is used to pull out the needed project specific data from
6883: -- the OTL pl/sql table P_Attribute_Table.
6884: --
6885: -- Parameters :
6886: -- IN P_Building_Block_Rec - Hxc_User_Type_Definition_Grp.Building_Block_Info
6887: -- P_Building_Block - Hxc_User_Type_Definition_Grp.Timecard_Info
6888: -- P_Attribute_Table - Hxc_User_Type_Definition_Grp.App_Attributes_Info
6889: -- X_Detail_Attr_Changed - Varchar2
6890: -- OUT

Line 6887: -- P_Building_Block - Hxc_User_Type_Definition_Grp.Timecard_Info

6883: -- the OTL pl/sql table P_Attribute_Table.
6884: --
6885: -- Parameters :
6886: -- IN P_Building_Block_Rec - Hxc_User_Type_Definition_Grp.Building_Block_Info
6887: -- P_Building_Block - Hxc_User_Type_Definition_Grp.Timecard_Info
6888: -- P_Attribute_Table - Hxc_User_Type_Definition_Grp.App_Attributes_Info
6889: -- X_Detail_Attr_Changed - Varchar2
6890: -- OUT
6891: -- P_Attribute_Table - Hxc_User_Type_Definition_Grp.App_Attributes_Info

Line 6888: -- P_Attribute_Table - Hxc_User_Type_Definition_Grp.App_Attributes_Info

6884: --
6885: -- Parameters :
6886: -- IN P_Building_Block_Rec - Hxc_User_Type_Definition_Grp.Building_Block_Info
6887: -- P_Building_Block - Hxc_User_Type_Definition_Grp.Timecard_Info
6888: -- P_Attribute_Table - Hxc_User_Type_Definition_Grp.App_Attributes_Info
6889: -- X_Detail_Attr_Changed - Varchar2
6890: -- OUT
6891: -- P_Attribute_Table - Hxc_User_Type_Definition_Grp.App_Attributes_Info
6892: -- X_Detail_Attr_Changed - Varchar2

Line 6891: -- P_Attribute_Table - Hxc_User_Type_Definition_Grp.App_Attributes_Info

6887: -- P_Building_Block - Hxc_User_Type_Definition_Grp.Timecard_Info
6888: -- P_Attribute_Table - Hxc_User_Type_Definition_Grp.App_Attributes_Info
6889: -- X_Detail_Attr_Changed - Varchar2
6890: -- OUT
6891: -- P_Attribute_Table - Hxc_User_Type_Definition_Grp.App_Attributes_Info
6892: -- X_Detail_Attr_Changed - Varchar2
6893: -- X_Proj_Attrib_Rec - Pa_Otc_Api.Project_Attribution_Rec
6894: --
6895:

Line 6899: P_Building_Block_Rec IN Hxc_User_Type_Definition_Grp.Building_Block_Info,

6895:
6896: /*--------------------------------------------------------------------------*/
6897:
6898: Procedure RetrieveProjAttribForUpd(
6899: P_Building_Block_Rec IN Hxc_User_Type_Definition_Grp.Building_Block_Info,
6900: P_Building_Block IN Hxc_User_Type_Definition_Grp.Timecard_Info,
6901: P_Attribute_Table IN OUT NOCOPY Hxc_User_Type_Definition_Grp.App_Attributes_Info,
6902: X_Detail_Attr_Changed IN OUT NOCOPY Varchar2,
6903: X_Proj_Attrib_Rec OUT NOCOPY Pa_Otc_Api.Project_Attribution_Rec) -- 2672653

Line 6900: P_Building_Block IN Hxc_User_Type_Definition_Grp.Timecard_Info,

6896: /*--------------------------------------------------------------------------*/
6897:
6898: Procedure RetrieveProjAttribForUpd(
6899: P_Building_Block_Rec IN Hxc_User_Type_Definition_Grp.Building_Block_Info,
6900: P_Building_Block IN Hxc_User_Type_Definition_Grp.Timecard_Info,
6901: P_Attribute_Table IN OUT NOCOPY Hxc_User_Type_Definition_Grp.App_Attributes_Info,
6902: X_Detail_Attr_Changed IN OUT NOCOPY Varchar2,
6903: X_Proj_Attrib_Rec OUT NOCOPY Pa_Otc_Api.Project_Attribution_Rec) -- 2672653
6904:

Line 6901: P_Attribute_Table IN OUT NOCOPY Hxc_User_Type_Definition_Grp.App_Attributes_Info,

6897:
6898: Procedure RetrieveProjAttribForUpd(
6899: P_Building_Block_Rec IN Hxc_User_Type_Definition_Grp.Building_Block_Info,
6900: P_Building_Block IN Hxc_User_Type_Definition_Grp.Timecard_Info,
6901: P_Attribute_Table IN OUT NOCOPY Hxc_User_Type_Definition_Grp.App_Attributes_Info,
6902: X_Detail_Attr_Changed IN OUT NOCOPY Varchar2,
6903: X_Proj_Attrib_Rec OUT NOCOPY Pa_Otc_Api.Project_Attribution_Rec) -- 2672653
6904:
6905: Is

Line 7350: l_Building_Blocks_Table Hxc_User_Type_Definition_Grp.Timecard_Info;

7346: l_Org_Id Number := Null;
7347: l_Valid_ExpTypClass_Combo Varchar2(1) := Null;
7348: l_Val_Proj_Flag Varchar2(1) := Null;
7349:
7350: l_Building_Blocks_Table Hxc_User_Type_Definition_Grp.Timecard_Info;
7351: l_Attribute_Table Hxc_User_Type_Definition_Grp.App_Attributes_info;
7352: l_Message_Table Hxc_User_Type_Definition_Grp.Message_Table;
7353:
7354: l_dummy_bb_Table Hxc_User_Type_Definition_Grp.Timecard_Info;

Line 7351: l_Attribute_Table Hxc_User_Type_Definition_Grp.App_Attributes_info;

7347: l_Valid_ExpTypClass_Combo Varchar2(1) := Null;
7348: l_Val_Proj_Flag Varchar2(1) := Null;
7349:
7350: l_Building_Blocks_Table Hxc_User_Type_Definition_Grp.Timecard_Info;
7351: l_Attribute_Table Hxc_User_Type_Definition_Grp.App_Attributes_info;
7352: l_Message_Table Hxc_User_Type_Definition_Grp.Message_Table;
7353:
7354: l_dummy_bb_Table Hxc_User_Type_Definition_Grp.Timecard_Info;
7355: l_dummy_Attrib_Table Hxc_User_Type_Definition_Grp.App_Attributes_info;

Line 7352: l_Message_Table Hxc_User_Type_Definition_Grp.Message_Table;

7348: l_Val_Proj_Flag Varchar2(1) := Null;
7349:
7350: l_Building_Blocks_Table Hxc_User_Type_Definition_Grp.Timecard_Info;
7351: l_Attribute_Table Hxc_User_Type_Definition_Grp.App_Attributes_info;
7352: l_Message_Table Hxc_User_Type_Definition_Grp.Message_Table;
7353:
7354: l_dummy_bb_Table Hxc_User_Type_Definition_Grp.Timecard_Info;
7355: l_dummy_Attrib_Table Hxc_User_Type_Definition_Grp.App_Attributes_info;
7356:

Line 7354: l_dummy_bb_Table Hxc_User_Type_Definition_Grp.Timecard_Info;

7350: l_Building_Blocks_Table Hxc_User_Type_Definition_Grp.Timecard_Info;
7351: l_Attribute_Table Hxc_User_Type_Definition_Grp.App_Attributes_info;
7352: l_Message_Table Hxc_User_Type_Definition_Grp.Message_Table;
7353:
7354: l_dummy_bb_Table Hxc_User_Type_Definition_Grp.Timecard_Info;
7355: l_dummy_Attrib_Table Hxc_User_Type_Definition_Grp.App_Attributes_info;
7356:
7357: /* If the profile value is NULL or 'N' then we want to retrieve all the records
7358: * irregardless of the value stored in column Provisional_Flag.

Line 7355: l_dummy_Attrib_Table Hxc_User_Type_Definition_Grp.App_Attributes_info;

7351: l_Attribute_Table Hxc_User_Type_Definition_Grp.App_Attributes_info;
7352: l_Message_Table Hxc_User_Type_Definition_Grp.Message_Table;
7353:
7354: l_dummy_bb_Table Hxc_User_Type_Definition_Grp.Timecard_Info;
7355: l_dummy_Attrib_Table Hxc_User_Type_Definition_Grp.App_Attributes_info;
7356:
7357: /* If the profile value is NULL or 'N' then we want to retrieve all the records
7358: * irregardless of the value stored in column Provisional_Flag.
7359: * If the profile value is 'Y' then we only want to retrieve those records

Line 7831: -- P_Building_Blocks_Table - Hxc_User_Type_Definition_Grp.Timecard_Info

7827: -- This procedure is only called when Mode is VALIDATE.
7828: --
7829: -- Parameters :
7830: -- IN
7831: -- P_Building_Blocks_Table - Hxc_User_Type_Definition_Grp.Timecard_Info
7832: -- P_Attribute_Table - Hxc_User_Type_Definition_Grp.App_Attributes_Info
7833: -- P_Message_Table - Hxc_User_Type_Definition_Grp.Message_Table
7834: -- OUT
7835: -- P_Message_Table - Hxc_User_Type_Definition_Grp.Message_Table

Line 7832: -- P_Attribute_Table - Hxc_User_Type_Definition_Grp.App_Attributes_Info

7828: --
7829: -- Parameters :
7830: -- IN
7831: -- P_Building_Blocks_Table - Hxc_User_Type_Definition_Grp.Timecard_Info
7832: -- P_Attribute_Table - Hxc_User_Type_Definition_Grp.App_Attributes_Info
7833: -- P_Message_Table - Hxc_User_Type_Definition_Grp.Message_Table
7834: -- OUT
7835: -- P_Message_Table - Hxc_User_Type_Definition_Grp.Message_Table
7836: -- X_TimeBB_Id - Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE

Line 7833: -- P_Message_Table - Hxc_User_Type_Definition_Grp.Message_Table

7829: -- Parameters :
7830: -- IN
7831: -- P_Building_Blocks_Table - Hxc_User_Type_Definition_Grp.Timecard_Info
7832: -- P_Attribute_Table - Hxc_User_Type_Definition_Grp.App_Attributes_Info
7833: -- P_Message_Table - Hxc_User_Type_Definition_Grp.Message_Table
7834: -- OUT
7835: -- P_Message_Table - Hxc_User_Type_Definition_Grp.Message_Table
7836: -- X_TimeBB_Id - Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE
7837: -- X_Ovr_Approver_Person_Id - Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE

Line 7835: -- P_Message_Table - Hxc_User_Type_Definition_Grp.Message_Table

7831: -- P_Building_Blocks_Table - Hxc_User_Type_Definition_Grp.Timecard_Info
7832: -- P_Attribute_Table - Hxc_User_Type_Definition_Grp.App_Attributes_Info
7833: -- P_Message_Table - Hxc_User_Type_Definition_Grp.Message_Table
7834: -- OUT
7835: -- P_Message_Table - Hxc_User_Type_Definition_Grp.Message_Table
7836: -- X_TimeBB_Id - Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE
7837: -- X_Ovr_Approver_Person_Id - Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE
7838: -- X_Timecard_Ending_Date - Date
7839:

Line 7844: P_Building_Blocks_Table IN Hxc_User_Type_Definition_Grp.Timecard_Info,

7840: /*--------------------------------------------------------------------------*/
7841:
7842:
7843: Procedure FindandValidateHeader(
7844: P_Building_Blocks_Table IN Hxc_User_Type_Definition_Grp.Timecard_Info,
7845: P_Attribute_Table IN Hxc_User_Type_Definition_Grp.App_Attributes_Info,
7846: P_Message_Table IN OUT NOCOPY Hxc_User_Type_Definition_Grp.Message_Table, -- 2672653
7847: X_TimeBB_Id OUT NOCOPY Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE,
7848: X_Ovr_Approver_Person_Id OUT NOCOPY Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE,

Line 7845: P_Attribute_Table IN Hxc_User_Type_Definition_Grp.App_Attributes_Info,

7841:
7842:
7843: Procedure FindandValidateHeader(
7844: P_Building_Blocks_Table IN Hxc_User_Type_Definition_Grp.Timecard_Info,
7845: P_Attribute_Table IN Hxc_User_Type_Definition_Grp.App_Attributes_Info,
7846: P_Message_Table IN OUT NOCOPY Hxc_User_Type_Definition_Grp.Message_Table, -- 2672653
7847: X_TimeBB_Id OUT NOCOPY Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE,
7848: X_Ovr_Approver_Person_Id OUT NOCOPY Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE,
7849: X_Pass_Val_Flag OUT NOCOPY Varchar2,

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

7842:
7843: Procedure FindandValidateHeader(
7844: P_Building_Blocks_Table IN Hxc_User_Type_Definition_Grp.Timecard_Info,
7845: P_Attribute_Table IN Hxc_User_Type_Definition_Grp.App_Attributes_Info,
7846: P_Message_Table IN OUT NOCOPY Hxc_User_Type_Definition_Grp.Message_Table, -- 2672653
7847: X_TimeBB_Id OUT NOCOPY Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE,
7848: X_Ovr_Approver_Person_Id OUT NOCOPY Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE,
7849: X_Pass_Val_Flag OUT NOCOPY Varchar2,
7850: X_Approval_Status OUT NOCOPY Hxc_Time_Building_Blocks.Approval_Status%TYPE)

Line 8098: l_Building_Block_Record Hxc_User_Type_Definition_Grp.Building_Block_Info;

8094: l_Inc_By_Person_Id Pa_Expenditures_All.Incurred_By_Person_Id%TYPE;
8095: l_Overriding_Approver_Id Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE;
8096:
8097: /* Stores a single record from the Building Block Table */
8098: l_Building_Block_Record Hxc_User_Type_Definition_Grp.Building_Block_Info;
8099:
8100: l_Message_Name Varchar2(30);
8101: l_Message_Table Hxc_User_Type_Definition_Grp.Message_Table;
8102:

Line 8101: l_Message_Table Hxc_User_Type_Definition_Grp.Message_Table;

8097: /* Stores a single record from the Building Block Table */
8098: l_Building_Block_Record Hxc_User_Type_Definition_Grp.Building_Block_Info;
8099:
8100: l_Message_Name Varchar2(30);
8101: l_Message_Table Hxc_User_Type_Definition_Grp.Message_Table;
8102:
8103: l_Status Number(10);
8104: l_Appl_Id Varchar2(10);
8105: l_Msg_Name Varchar2(30);

Line 8273: l_Message_Table Hxc_User_Type_Definition_Grp.Message_Table;

8269: l_Timecard_Table Pa_Otc_Api.Timecard_Table;
8270: l_Inc_By_Person_Id Pa_Expenditures_All.Incurred_By_Person_Id%TYPE;
8271: l_Overriding_Approver_Id Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE := Null;
8272:
8273: l_Message_Table Hxc_User_Type_Definition_Grp.Message_Table;
8274: l_Message_Name Varchar2(30);
8275:
8276: l_Status Number(10);
8277: l_Msg_App Varchar2(10);

Line 8538: l_Time_Building_Blocks Hxc_User_Type_Definition_Grp.Timecard_Info;

8534:
8535: l_Proj_Attrib_Rec Pa_Otc_Api.Project_Attribution_Rec;
8536: j Binary_Integer := 0;
8537:
8538: l_Time_Building_Blocks Hxc_User_Type_Definition_Grp.Timecard_Info;
8539: l_Time_Attributes Hxc_User_Type_Definition_Grp.App_Attributes_Info;
8540: l_Detail_Attr_Changed Varchar2(1) := 'N';
8541:
8542: /* Stores a single record from the Building Block Table */

Line 8539: l_Time_Attributes Hxc_User_Type_Definition_Grp.App_Attributes_Info;

8535: l_Proj_Attrib_Rec Pa_Otc_Api.Project_Attribution_Rec;
8536: j Binary_Integer := 0;
8537:
8538: l_Time_Building_Blocks Hxc_User_Type_Definition_Grp.Timecard_Info;
8539: l_Time_Attributes Hxc_User_Type_Definition_Grp.App_Attributes_Info;
8540: l_Detail_Attr_Changed Varchar2(1) := 'N';
8541:
8542: /* Stores a single record from the Building Block Table */
8543: l_Building_Block_Record Hxc_User_Type_Definition_Grp.Building_Block_Info;

Line 8543: l_Building_Block_Record Hxc_User_Type_Definition_Grp.Building_Block_Info;

8539: l_Time_Attributes Hxc_User_Type_Definition_Grp.App_Attributes_Info;
8540: l_Detail_Attr_Changed Varchar2(1) := 'N';
8541:
8542: /* Stores a single record from the Building Block Table */
8543: l_Building_Block_Record Hxc_User_Type_Definition_Grp.Building_Block_Info;
8544:
8545: Begin
8546:
8547: G_Stage := 'Entering CreateProjTimecardTable() procedure.';