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.PAY_ASSG_COST_SS dependencies on HR_API

Line 55: l_transaction_id HR_API_TRANSACTIONS.TRANSACTION_ID%TYPE;

51: ,P_TRANSACTION_STEP_ID OUT NOCOPY NUMBER
52: ) is
53: l_proc varchar2(100) := g_package||'CREATE_ASSG_COST';
54:
55: l_transaction_id HR_API_TRANSACTIONS.TRANSACTION_ID%TYPE;
56: l_transaction_step_id HR_API_TRANSACTION_STEPS.TRANSACTION_STEP_ID%TYPE;
57: l_trs_object_version_number HR_API_TRANSACTION_STEPS.OBJECT_VERSION_NUMBER%TYPE;
58: l_transaction_table HR_TRANSACTION_SS.TRANSACTION_TABLE;
59: l_count NUMBER;

Line 56: l_transaction_step_id HR_API_TRANSACTION_STEPS.TRANSACTION_STEP_ID%TYPE;

52: ) is
53: l_proc varchar2(100) := g_package||'CREATE_ASSG_COST';
54:
55: l_transaction_id HR_API_TRANSACTIONS.TRANSACTION_ID%TYPE;
56: l_transaction_step_id HR_API_TRANSACTION_STEPS.TRANSACTION_STEP_ID%TYPE;
57: l_trs_object_version_number HR_API_TRANSACTION_STEPS.OBJECT_VERSION_NUMBER%TYPE;
58: l_transaction_table HR_TRANSACTION_SS.TRANSACTION_TABLE;
59: l_count NUMBER;
60: l_result VARCHAR2(100);

Line 57: l_trs_object_version_number HR_API_TRANSACTION_STEPS.OBJECT_VERSION_NUMBER%TYPE;

53: l_proc varchar2(100) := g_package||'CREATE_ASSG_COST';
54:
55: l_transaction_id HR_API_TRANSACTIONS.TRANSACTION_ID%TYPE;
56: l_transaction_step_id HR_API_TRANSACTION_STEPS.TRANSACTION_STEP_ID%TYPE;
57: l_trs_object_version_number HR_API_TRANSACTION_STEPS.OBJECT_VERSION_NUMBER%TYPE;
58: l_transaction_table HR_TRANSACTION_SS.TRANSACTION_TABLE;
59: l_count NUMBER;
60: l_result VARCHAR2(100);
61: L_EFFECTIVE_DATE DATE;

Line 359: l_login_person_id HR_API_TRANSACTIONS.CREATOR_PERSON_ID%TYPE;

355: l_cost_allocation_keyflex_id PAY_COST_ALLOCATION_KEYFLEX.COST_ALLOCATION_KEYFLEX_ID%TYPE;
356: l_object_version_number PAY_COST_ALLOCATIONS_F.OBJECT_VERSION_NUMBER%TYPE;
357: l_combination_name PAY_COST_ALLOCATION_KEYFLEX.CONCATENATED_SEGMENTS%TYPE;
358: l_cost_allocation_id PAY_COST_ALLOCATIONS_F.COST_ALLOCATION_ID%TYPE;
359: l_login_person_id HR_API_TRANSACTIONS.CREATOR_PERSON_ID%TYPE;
360:
361: BEGIN
362: IF g_debug THEN
363: hr_utility.set_location('Entering '||l_proc,10);

Line 541: ,P_PROPORTION IN NUMBER default hr_api.g_number

537: ,P_COST_ALLOCATION_ID IN NUMBER
538: ,P_BUSINESS_GROUP_ID IN NUMBER
539: ,P_COST_ALLOCATION_KEYFLEX_ID IN NUMBER
540: ,P_OBJECT_VERSION_NUMBER IN NUMBER
541: ,P_PROPORTION IN NUMBER default hr_api.g_number
542: ,P_SEGMENT1 IN VARCHAR2 default hr_api.g_varchar2
543: ,P_SEGMENT2 IN VARCHAR2 default hr_api.g_varchar2
544: ,P_SEGMENT3 IN VARCHAR2 default hr_api.g_varchar2
545: ,P_SEGMENT4 IN VARCHAR2 default hr_api.g_varchar2

Line 542: ,P_SEGMENT1 IN VARCHAR2 default hr_api.g_varchar2

538: ,P_BUSINESS_GROUP_ID IN NUMBER
539: ,P_COST_ALLOCATION_KEYFLEX_ID IN NUMBER
540: ,P_OBJECT_VERSION_NUMBER IN NUMBER
541: ,P_PROPORTION IN NUMBER default hr_api.g_number
542: ,P_SEGMENT1 IN VARCHAR2 default hr_api.g_varchar2
543: ,P_SEGMENT2 IN VARCHAR2 default hr_api.g_varchar2
544: ,P_SEGMENT3 IN VARCHAR2 default hr_api.g_varchar2
545: ,P_SEGMENT4 IN VARCHAR2 default hr_api.g_varchar2
546: ,P_SEGMENT5 IN VARCHAR2 default hr_api.g_varchar2

Line 543: ,P_SEGMENT2 IN VARCHAR2 default hr_api.g_varchar2

539: ,P_COST_ALLOCATION_KEYFLEX_ID IN NUMBER
540: ,P_OBJECT_VERSION_NUMBER IN NUMBER
541: ,P_PROPORTION IN NUMBER default hr_api.g_number
542: ,P_SEGMENT1 IN VARCHAR2 default hr_api.g_varchar2
543: ,P_SEGMENT2 IN VARCHAR2 default hr_api.g_varchar2
544: ,P_SEGMENT3 IN VARCHAR2 default hr_api.g_varchar2
545: ,P_SEGMENT4 IN VARCHAR2 default hr_api.g_varchar2
546: ,P_SEGMENT5 IN VARCHAR2 default hr_api.g_varchar2
547: ,P_SEGMENT6 IN VARCHAR2 default hr_api.g_varchar2

Line 544: ,P_SEGMENT3 IN VARCHAR2 default hr_api.g_varchar2

540: ,P_OBJECT_VERSION_NUMBER IN NUMBER
541: ,P_PROPORTION IN NUMBER default hr_api.g_number
542: ,P_SEGMENT1 IN VARCHAR2 default hr_api.g_varchar2
543: ,P_SEGMENT2 IN VARCHAR2 default hr_api.g_varchar2
544: ,P_SEGMENT3 IN VARCHAR2 default hr_api.g_varchar2
545: ,P_SEGMENT4 IN VARCHAR2 default hr_api.g_varchar2
546: ,P_SEGMENT5 IN VARCHAR2 default hr_api.g_varchar2
547: ,P_SEGMENT6 IN VARCHAR2 default hr_api.g_varchar2
548: ,P_SEGMENT7 IN VARCHAR2 default hr_api.g_varchar2

Line 545: ,P_SEGMENT4 IN VARCHAR2 default hr_api.g_varchar2

541: ,P_PROPORTION IN NUMBER default hr_api.g_number
542: ,P_SEGMENT1 IN VARCHAR2 default hr_api.g_varchar2
543: ,P_SEGMENT2 IN VARCHAR2 default hr_api.g_varchar2
544: ,P_SEGMENT3 IN VARCHAR2 default hr_api.g_varchar2
545: ,P_SEGMENT4 IN VARCHAR2 default hr_api.g_varchar2
546: ,P_SEGMENT5 IN VARCHAR2 default hr_api.g_varchar2
547: ,P_SEGMENT6 IN VARCHAR2 default hr_api.g_varchar2
548: ,P_SEGMENT7 IN VARCHAR2 default hr_api.g_varchar2
549: ,P_SEGMENT8 IN VARCHAR2 default hr_api.g_varchar2

Line 546: ,P_SEGMENT5 IN VARCHAR2 default hr_api.g_varchar2

542: ,P_SEGMENT1 IN VARCHAR2 default hr_api.g_varchar2
543: ,P_SEGMENT2 IN VARCHAR2 default hr_api.g_varchar2
544: ,P_SEGMENT3 IN VARCHAR2 default hr_api.g_varchar2
545: ,P_SEGMENT4 IN VARCHAR2 default hr_api.g_varchar2
546: ,P_SEGMENT5 IN VARCHAR2 default hr_api.g_varchar2
547: ,P_SEGMENT6 IN VARCHAR2 default hr_api.g_varchar2
548: ,P_SEGMENT7 IN VARCHAR2 default hr_api.g_varchar2
549: ,P_SEGMENT8 IN VARCHAR2 default hr_api.g_varchar2
550: ,P_SEGMENT9 IN VARCHAR2 default hr_api.g_varchar2

Line 547: ,P_SEGMENT6 IN VARCHAR2 default hr_api.g_varchar2

543: ,P_SEGMENT2 IN VARCHAR2 default hr_api.g_varchar2
544: ,P_SEGMENT3 IN VARCHAR2 default hr_api.g_varchar2
545: ,P_SEGMENT4 IN VARCHAR2 default hr_api.g_varchar2
546: ,P_SEGMENT5 IN VARCHAR2 default hr_api.g_varchar2
547: ,P_SEGMENT6 IN VARCHAR2 default hr_api.g_varchar2
548: ,P_SEGMENT7 IN VARCHAR2 default hr_api.g_varchar2
549: ,P_SEGMENT8 IN VARCHAR2 default hr_api.g_varchar2
550: ,P_SEGMENT9 IN VARCHAR2 default hr_api.g_varchar2
551: ,P_SEGMENT10 IN VARCHAR2 default hr_api.g_varchar2

Line 548: ,P_SEGMENT7 IN VARCHAR2 default hr_api.g_varchar2

544: ,P_SEGMENT3 IN VARCHAR2 default hr_api.g_varchar2
545: ,P_SEGMENT4 IN VARCHAR2 default hr_api.g_varchar2
546: ,P_SEGMENT5 IN VARCHAR2 default hr_api.g_varchar2
547: ,P_SEGMENT6 IN VARCHAR2 default hr_api.g_varchar2
548: ,P_SEGMENT7 IN VARCHAR2 default hr_api.g_varchar2
549: ,P_SEGMENT8 IN VARCHAR2 default hr_api.g_varchar2
550: ,P_SEGMENT9 IN VARCHAR2 default hr_api.g_varchar2
551: ,P_SEGMENT10 IN VARCHAR2 default hr_api.g_varchar2
552: ,P_SEGMENT11 IN VARCHAR2 default hr_api.g_varchar2

Line 549: ,P_SEGMENT8 IN VARCHAR2 default hr_api.g_varchar2

545: ,P_SEGMENT4 IN VARCHAR2 default hr_api.g_varchar2
546: ,P_SEGMENT5 IN VARCHAR2 default hr_api.g_varchar2
547: ,P_SEGMENT6 IN VARCHAR2 default hr_api.g_varchar2
548: ,P_SEGMENT7 IN VARCHAR2 default hr_api.g_varchar2
549: ,P_SEGMENT8 IN VARCHAR2 default hr_api.g_varchar2
550: ,P_SEGMENT9 IN VARCHAR2 default hr_api.g_varchar2
551: ,P_SEGMENT10 IN VARCHAR2 default hr_api.g_varchar2
552: ,P_SEGMENT11 IN VARCHAR2 default hr_api.g_varchar2
553: ,P_SEGMENT12 IN VARCHAR2 default hr_api.g_varchar2

Line 550: ,P_SEGMENT9 IN VARCHAR2 default hr_api.g_varchar2

546: ,P_SEGMENT5 IN VARCHAR2 default hr_api.g_varchar2
547: ,P_SEGMENT6 IN VARCHAR2 default hr_api.g_varchar2
548: ,P_SEGMENT7 IN VARCHAR2 default hr_api.g_varchar2
549: ,P_SEGMENT8 IN VARCHAR2 default hr_api.g_varchar2
550: ,P_SEGMENT9 IN VARCHAR2 default hr_api.g_varchar2
551: ,P_SEGMENT10 IN VARCHAR2 default hr_api.g_varchar2
552: ,P_SEGMENT11 IN VARCHAR2 default hr_api.g_varchar2
553: ,P_SEGMENT12 IN VARCHAR2 default hr_api.g_varchar2
554: ,P_SEGMENT13 IN VARCHAR2 default hr_api.g_varchar2

Line 551: ,P_SEGMENT10 IN VARCHAR2 default hr_api.g_varchar2

547: ,P_SEGMENT6 IN VARCHAR2 default hr_api.g_varchar2
548: ,P_SEGMENT7 IN VARCHAR2 default hr_api.g_varchar2
549: ,P_SEGMENT8 IN VARCHAR2 default hr_api.g_varchar2
550: ,P_SEGMENT9 IN VARCHAR2 default hr_api.g_varchar2
551: ,P_SEGMENT10 IN VARCHAR2 default hr_api.g_varchar2
552: ,P_SEGMENT11 IN VARCHAR2 default hr_api.g_varchar2
553: ,P_SEGMENT12 IN VARCHAR2 default hr_api.g_varchar2
554: ,P_SEGMENT13 IN VARCHAR2 default hr_api.g_varchar2
555: ,P_SEGMENT14 IN VARCHAR2 default hr_api.g_varchar2

Line 552: ,P_SEGMENT11 IN VARCHAR2 default hr_api.g_varchar2

548: ,P_SEGMENT7 IN VARCHAR2 default hr_api.g_varchar2
549: ,P_SEGMENT8 IN VARCHAR2 default hr_api.g_varchar2
550: ,P_SEGMENT9 IN VARCHAR2 default hr_api.g_varchar2
551: ,P_SEGMENT10 IN VARCHAR2 default hr_api.g_varchar2
552: ,P_SEGMENT11 IN VARCHAR2 default hr_api.g_varchar2
553: ,P_SEGMENT12 IN VARCHAR2 default hr_api.g_varchar2
554: ,P_SEGMENT13 IN VARCHAR2 default hr_api.g_varchar2
555: ,P_SEGMENT14 IN VARCHAR2 default hr_api.g_varchar2
556: ,P_SEGMENT15 IN VARCHAR2 default hr_api.g_varchar2

Line 553: ,P_SEGMENT12 IN VARCHAR2 default hr_api.g_varchar2

549: ,P_SEGMENT8 IN VARCHAR2 default hr_api.g_varchar2
550: ,P_SEGMENT9 IN VARCHAR2 default hr_api.g_varchar2
551: ,P_SEGMENT10 IN VARCHAR2 default hr_api.g_varchar2
552: ,P_SEGMENT11 IN VARCHAR2 default hr_api.g_varchar2
553: ,P_SEGMENT12 IN VARCHAR2 default hr_api.g_varchar2
554: ,P_SEGMENT13 IN VARCHAR2 default hr_api.g_varchar2
555: ,P_SEGMENT14 IN VARCHAR2 default hr_api.g_varchar2
556: ,P_SEGMENT15 IN VARCHAR2 default hr_api.g_varchar2
557: ,P_SEGMENT16 IN VARCHAR2 default hr_api.g_varchar2

Line 554: ,P_SEGMENT13 IN VARCHAR2 default hr_api.g_varchar2

550: ,P_SEGMENT9 IN VARCHAR2 default hr_api.g_varchar2
551: ,P_SEGMENT10 IN VARCHAR2 default hr_api.g_varchar2
552: ,P_SEGMENT11 IN VARCHAR2 default hr_api.g_varchar2
553: ,P_SEGMENT12 IN VARCHAR2 default hr_api.g_varchar2
554: ,P_SEGMENT13 IN VARCHAR2 default hr_api.g_varchar2
555: ,P_SEGMENT14 IN VARCHAR2 default hr_api.g_varchar2
556: ,P_SEGMENT15 IN VARCHAR2 default hr_api.g_varchar2
557: ,P_SEGMENT16 IN VARCHAR2 default hr_api.g_varchar2
558: ,P_SEGMENT17 IN VARCHAR2 default hr_api.g_varchar2

Line 555: ,P_SEGMENT14 IN VARCHAR2 default hr_api.g_varchar2

551: ,P_SEGMENT10 IN VARCHAR2 default hr_api.g_varchar2
552: ,P_SEGMENT11 IN VARCHAR2 default hr_api.g_varchar2
553: ,P_SEGMENT12 IN VARCHAR2 default hr_api.g_varchar2
554: ,P_SEGMENT13 IN VARCHAR2 default hr_api.g_varchar2
555: ,P_SEGMENT14 IN VARCHAR2 default hr_api.g_varchar2
556: ,P_SEGMENT15 IN VARCHAR2 default hr_api.g_varchar2
557: ,P_SEGMENT16 IN VARCHAR2 default hr_api.g_varchar2
558: ,P_SEGMENT17 IN VARCHAR2 default hr_api.g_varchar2
559: ,P_SEGMENT18 IN VARCHAR2 default hr_api.g_varchar2

Line 556: ,P_SEGMENT15 IN VARCHAR2 default hr_api.g_varchar2

552: ,P_SEGMENT11 IN VARCHAR2 default hr_api.g_varchar2
553: ,P_SEGMENT12 IN VARCHAR2 default hr_api.g_varchar2
554: ,P_SEGMENT13 IN VARCHAR2 default hr_api.g_varchar2
555: ,P_SEGMENT14 IN VARCHAR2 default hr_api.g_varchar2
556: ,P_SEGMENT15 IN VARCHAR2 default hr_api.g_varchar2
557: ,P_SEGMENT16 IN VARCHAR2 default hr_api.g_varchar2
558: ,P_SEGMENT17 IN VARCHAR2 default hr_api.g_varchar2
559: ,P_SEGMENT18 IN VARCHAR2 default hr_api.g_varchar2
560: ,P_SEGMENT19 IN VARCHAR2 default hr_api.g_varchar2

Line 557: ,P_SEGMENT16 IN VARCHAR2 default hr_api.g_varchar2

553: ,P_SEGMENT12 IN VARCHAR2 default hr_api.g_varchar2
554: ,P_SEGMENT13 IN VARCHAR2 default hr_api.g_varchar2
555: ,P_SEGMENT14 IN VARCHAR2 default hr_api.g_varchar2
556: ,P_SEGMENT15 IN VARCHAR2 default hr_api.g_varchar2
557: ,P_SEGMENT16 IN VARCHAR2 default hr_api.g_varchar2
558: ,P_SEGMENT17 IN VARCHAR2 default hr_api.g_varchar2
559: ,P_SEGMENT18 IN VARCHAR2 default hr_api.g_varchar2
560: ,P_SEGMENT19 IN VARCHAR2 default hr_api.g_varchar2
561: ,P_SEGMENT20 IN VARCHAR2 default hr_api.g_varchar2

Line 558: ,P_SEGMENT17 IN VARCHAR2 default hr_api.g_varchar2

554: ,P_SEGMENT13 IN VARCHAR2 default hr_api.g_varchar2
555: ,P_SEGMENT14 IN VARCHAR2 default hr_api.g_varchar2
556: ,P_SEGMENT15 IN VARCHAR2 default hr_api.g_varchar2
557: ,P_SEGMENT16 IN VARCHAR2 default hr_api.g_varchar2
558: ,P_SEGMENT17 IN VARCHAR2 default hr_api.g_varchar2
559: ,P_SEGMENT18 IN VARCHAR2 default hr_api.g_varchar2
560: ,P_SEGMENT19 IN VARCHAR2 default hr_api.g_varchar2
561: ,P_SEGMENT20 IN VARCHAR2 default hr_api.g_varchar2
562: ,P_SEGMENT21 IN VARCHAR2 default hr_api.g_varchar2

Line 559: ,P_SEGMENT18 IN VARCHAR2 default hr_api.g_varchar2

555: ,P_SEGMENT14 IN VARCHAR2 default hr_api.g_varchar2
556: ,P_SEGMENT15 IN VARCHAR2 default hr_api.g_varchar2
557: ,P_SEGMENT16 IN VARCHAR2 default hr_api.g_varchar2
558: ,P_SEGMENT17 IN VARCHAR2 default hr_api.g_varchar2
559: ,P_SEGMENT18 IN VARCHAR2 default hr_api.g_varchar2
560: ,P_SEGMENT19 IN VARCHAR2 default hr_api.g_varchar2
561: ,P_SEGMENT20 IN VARCHAR2 default hr_api.g_varchar2
562: ,P_SEGMENT21 IN VARCHAR2 default hr_api.g_varchar2
563: ,P_SEGMENT22 IN VARCHAR2 default hr_api.g_varchar2

Line 560: ,P_SEGMENT19 IN VARCHAR2 default hr_api.g_varchar2

556: ,P_SEGMENT15 IN VARCHAR2 default hr_api.g_varchar2
557: ,P_SEGMENT16 IN VARCHAR2 default hr_api.g_varchar2
558: ,P_SEGMENT17 IN VARCHAR2 default hr_api.g_varchar2
559: ,P_SEGMENT18 IN VARCHAR2 default hr_api.g_varchar2
560: ,P_SEGMENT19 IN VARCHAR2 default hr_api.g_varchar2
561: ,P_SEGMENT20 IN VARCHAR2 default hr_api.g_varchar2
562: ,P_SEGMENT21 IN VARCHAR2 default hr_api.g_varchar2
563: ,P_SEGMENT22 IN VARCHAR2 default hr_api.g_varchar2
564: ,P_SEGMENT23 IN VARCHAR2 default hr_api.g_varchar2

Line 561: ,P_SEGMENT20 IN VARCHAR2 default hr_api.g_varchar2

557: ,P_SEGMENT16 IN VARCHAR2 default hr_api.g_varchar2
558: ,P_SEGMENT17 IN VARCHAR2 default hr_api.g_varchar2
559: ,P_SEGMENT18 IN VARCHAR2 default hr_api.g_varchar2
560: ,P_SEGMENT19 IN VARCHAR2 default hr_api.g_varchar2
561: ,P_SEGMENT20 IN VARCHAR2 default hr_api.g_varchar2
562: ,P_SEGMENT21 IN VARCHAR2 default hr_api.g_varchar2
563: ,P_SEGMENT22 IN VARCHAR2 default hr_api.g_varchar2
564: ,P_SEGMENT23 IN VARCHAR2 default hr_api.g_varchar2
565: ,P_SEGMENT24 IN VARCHAR2 default hr_api.g_varchar2

Line 562: ,P_SEGMENT21 IN VARCHAR2 default hr_api.g_varchar2

558: ,P_SEGMENT17 IN VARCHAR2 default hr_api.g_varchar2
559: ,P_SEGMENT18 IN VARCHAR2 default hr_api.g_varchar2
560: ,P_SEGMENT19 IN VARCHAR2 default hr_api.g_varchar2
561: ,P_SEGMENT20 IN VARCHAR2 default hr_api.g_varchar2
562: ,P_SEGMENT21 IN VARCHAR2 default hr_api.g_varchar2
563: ,P_SEGMENT22 IN VARCHAR2 default hr_api.g_varchar2
564: ,P_SEGMENT23 IN VARCHAR2 default hr_api.g_varchar2
565: ,P_SEGMENT24 IN VARCHAR2 default hr_api.g_varchar2
566: ,P_SEGMENT25 IN VARCHAR2 default hr_api.g_varchar2

Line 563: ,P_SEGMENT22 IN VARCHAR2 default hr_api.g_varchar2

559: ,P_SEGMENT18 IN VARCHAR2 default hr_api.g_varchar2
560: ,P_SEGMENT19 IN VARCHAR2 default hr_api.g_varchar2
561: ,P_SEGMENT20 IN VARCHAR2 default hr_api.g_varchar2
562: ,P_SEGMENT21 IN VARCHAR2 default hr_api.g_varchar2
563: ,P_SEGMENT22 IN VARCHAR2 default hr_api.g_varchar2
564: ,P_SEGMENT23 IN VARCHAR2 default hr_api.g_varchar2
565: ,P_SEGMENT24 IN VARCHAR2 default hr_api.g_varchar2
566: ,P_SEGMENT25 IN VARCHAR2 default hr_api.g_varchar2
567: ,P_SEGMENT26 IN VARCHAR2 default hr_api.g_varchar2

Line 564: ,P_SEGMENT23 IN VARCHAR2 default hr_api.g_varchar2

560: ,P_SEGMENT19 IN VARCHAR2 default hr_api.g_varchar2
561: ,P_SEGMENT20 IN VARCHAR2 default hr_api.g_varchar2
562: ,P_SEGMENT21 IN VARCHAR2 default hr_api.g_varchar2
563: ,P_SEGMENT22 IN VARCHAR2 default hr_api.g_varchar2
564: ,P_SEGMENT23 IN VARCHAR2 default hr_api.g_varchar2
565: ,P_SEGMENT24 IN VARCHAR2 default hr_api.g_varchar2
566: ,P_SEGMENT25 IN VARCHAR2 default hr_api.g_varchar2
567: ,P_SEGMENT26 IN VARCHAR2 default hr_api.g_varchar2
568: ,P_SEGMENT27 IN VARCHAR2 default hr_api.g_varchar2

Line 565: ,P_SEGMENT24 IN VARCHAR2 default hr_api.g_varchar2

561: ,P_SEGMENT20 IN VARCHAR2 default hr_api.g_varchar2
562: ,P_SEGMENT21 IN VARCHAR2 default hr_api.g_varchar2
563: ,P_SEGMENT22 IN VARCHAR2 default hr_api.g_varchar2
564: ,P_SEGMENT23 IN VARCHAR2 default hr_api.g_varchar2
565: ,P_SEGMENT24 IN VARCHAR2 default hr_api.g_varchar2
566: ,P_SEGMENT25 IN VARCHAR2 default hr_api.g_varchar2
567: ,P_SEGMENT26 IN VARCHAR2 default hr_api.g_varchar2
568: ,P_SEGMENT27 IN VARCHAR2 default hr_api.g_varchar2
569: ,P_SEGMENT28 IN VARCHAR2 default hr_api.g_varchar2

Line 566: ,P_SEGMENT25 IN VARCHAR2 default hr_api.g_varchar2

562: ,P_SEGMENT21 IN VARCHAR2 default hr_api.g_varchar2
563: ,P_SEGMENT22 IN VARCHAR2 default hr_api.g_varchar2
564: ,P_SEGMENT23 IN VARCHAR2 default hr_api.g_varchar2
565: ,P_SEGMENT24 IN VARCHAR2 default hr_api.g_varchar2
566: ,P_SEGMENT25 IN VARCHAR2 default hr_api.g_varchar2
567: ,P_SEGMENT26 IN VARCHAR2 default hr_api.g_varchar2
568: ,P_SEGMENT27 IN VARCHAR2 default hr_api.g_varchar2
569: ,P_SEGMENT28 IN VARCHAR2 default hr_api.g_varchar2
570: ,P_SEGMENT29 IN VARCHAR2 default hr_api.g_varchar2

Line 567: ,P_SEGMENT26 IN VARCHAR2 default hr_api.g_varchar2

563: ,P_SEGMENT22 IN VARCHAR2 default hr_api.g_varchar2
564: ,P_SEGMENT23 IN VARCHAR2 default hr_api.g_varchar2
565: ,P_SEGMENT24 IN VARCHAR2 default hr_api.g_varchar2
566: ,P_SEGMENT25 IN VARCHAR2 default hr_api.g_varchar2
567: ,P_SEGMENT26 IN VARCHAR2 default hr_api.g_varchar2
568: ,P_SEGMENT27 IN VARCHAR2 default hr_api.g_varchar2
569: ,P_SEGMENT28 IN VARCHAR2 default hr_api.g_varchar2
570: ,P_SEGMENT29 IN VARCHAR2 default hr_api.g_varchar2
571: ,P_SEGMENT30 IN VARCHAR2 default hr_api.g_varchar2

Line 568: ,P_SEGMENT27 IN VARCHAR2 default hr_api.g_varchar2

564: ,P_SEGMENT23 IN VARCHAR2 default hr_api.g_varchar2
565: ,P_SEGMENT24 IN VARCHAR2 default hr_api.g_varchar2
566: ,P_SEGMENT25 IN VARCHAR2 default hr_api.g_varchar2
567: ,P_SEGMENT26 IN VARCHAR2 default hr_api.g_varchar2
568: ,P_SEGMENT27 IN VARCHAR2 default hr_api.g_varchar2
569: ,P_SEGMENT28 IN VARCHAR2 default hr_api.g_varchar2
570: ,P_SEGMENT29 IN VARCHAR2 default hr_api.g_varchar2
571: ,P_SEGMENT30 IN VARCHAR2 default hr_api.g_varchar2
572: ,P_CONCATENATED_SEGMENTS IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2

Line 569: ,P_SEGMENT28 IN VARCHAR2 default hr_api.g_varchar2

565: ,P_SEGMENT24 IN VARCHAR2 default hr_api.g_varchar2
566: ,P_SEGMENT25 IN VARCHAR2 default hr_api.g_varchar2
567: ,P_SEGMENT26 IN VARCHAR2 default hr_api.g_varchar2
568: ,P_SEGMENT27 IN VARCHAR2 default hr_api.g_varchar2
569: ,P_SEGMENT28 IN VARCHAR2 default hr_api.g_varchar2
570: ,P_SEGMENT29 IN VARCHAR2 default hr_api.g_varchar2
571: ,P_SEGMENT30 IN VARCHAR2 default hr_api.g_varchar2
572: ,P_CONCATENATED_SEGMENTS IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
573: ,P_EFFECTIVE_START_DATE IN DATE DEFAULT NULL

Line 570: ,P_SEGMENT29 IN VARCHAR2 default hr_api.g_varchar2

566: ,P_SEGMENT25 IN VARCHAR2 default hr_api.g_varchar2
567: ,P_SEGMENT26 IN VARCHAR2 default hr_api.g_varchar2
568: ,P_SEGMENT27 IN VARCHAR2 default hr_api.g_varchar2
569: ,P_SEGMENT28 IN VARCHAR2 default hr_api.g_varchar2
570: ,P_SEGMENT29 IN VARCHAR2 default hr_api.g_varchar2
571: ,P_SEGMENT30 IN VARCHAR2 default hr_api.g_varchar2
572: ,P_CONCATENATED_SEGMENTS IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
573: ,P_EFFECTIVE_START_DATE IN DATE DEFAULT NULL
574: ,P_EFFECTIVE_END_DATE IN DATE DEFAULT NULL

Line 571: ,P_SEGMENT30 IN VARCHAR2 default hr_api.g_varchar2

567: ,P_SEGMENT26 IN VARCHAR2 default hr_api.g_varchar2
568: ,P_SEGMENT27 IN VARCHAR2 default hr_api.g_varchar2
569: ,P_SEGMENT28 IN VARCHAR2 default hr_api.g_varchar2
570: ,P_SEGMENT29 IN VARCHAR2 default hr_api.g_varchar2
571: ,P_SEGMENT30 IN VARCHAR2 default hr_api.g_varchar2
572: ,P_CONCATENATED_SEGMENTS IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
573: ,P_EFFECTIVE_START_DATE IN DATE DEFAULT NULL
574: ,P_EFFECTIVE_END_DATE IN DATE DEFAULT NULL
575: ,P_TRANSACTION_ID OUT NOCOPY NUMBER

Line 572: ,P_CONCATENATED_SEGMENTS IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2

568: ,P_SEGMENT27 IN VARCHAR2 default hr_api.g_varchar2
569: ,P_SEGMENT28 IN VARCHAR2 default hr_api.g_varchar2
570: ,P_SEGMENT29 IN VARCHAR2 default hr_api.g_varchar2
571: ,P_SEGMENT30 IN VARCHAR2 default hr_api.g_varchar2
572: ,P_CONCATENATED_SEGMENTS IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
573: ,P_EFFECTIVE_START_DATE IN DATE DEFAULT NULL
574: ,P_EFFECTIVE_END_DATE IN DATE DEFAULT NULL
575: ,P_TRANSACTION_ID OUT NOCOPY NUMBER
576: ,P_TRANSACTION_STEP_ID OUT NOCOPY NUMBER

Line 580: l_transaction_id HR_API_TRANSACTIONS.TRANSACTION_ID%TYPE;

576: ,P_TRANSACTION_STEP_ID OUT NOCOPY NUMBER
577: ) as
578: l_proc varchar2(100) := g_package||'UPDATE_ASSG_COST';
579:
580: l_transaction_id HR_API_TRANSACTIONS.TRANSACTION_ID%TYPE;
581: l_transaction_step_id HR_API_TRANSACTION_STEPS.TRANSACTION_STEP_ID%TYPE;
582: l_trs_object_version_number HR_API_TRANSACTION_STEPS.OBJECT_VERSION_NUMBER%TYPE;
583: l_transaction_table HR_TRANSACTION_SS.TRANSACTION_TABLE;
584: l_count NUMBER;

Line 581: l_transaction_step_id HR_API_TRANSACTION_STEPS.TRANSACTION_STEP_ID%TYPE;

577: ) as
578: l_proc varchar2(100) := g_package||'UPDATE_ASSG_COST';
579:
580: l_transaction_id HR_API_TRANSACTIONS.TRANSACTION_ID%TYPE;
581: l_transaction_step_id HR_API_TRANSACTION_STEPS.TRANSACTION_STEP_ID%TYPE;
582: l_trs_object_version_number HR_API_TRANSACTION_STEPS.OBJECT_VERSION_NUMBER%TYPE;
583: l_transaction_table HR_TRANSACTION_SS.TRANSACTION_TABLE;
584: l_count NUMBER;
585: l_effective_date date;

Line 582: l_trs_object_version_number HR_API_TRANSACTION_STEPS.OBJECT_VERSION_NUMBER%TYPE;

578: l_proc varchar2(100) := g_package||'UPDATE_ASSG_COST';
579:
580: l_transaction_id HR_API_TRANSACTIONS.TRANSACTION_ID%TYPE;
581: l_transaction_step_id HR_API_TRANSACTION_STEPS.TRANSACTION_STEP_ID%TYPE;
582: l_trs_object_version_number HR_API_TRANSACTION_STEPS.OBJECT_VERSION_NUMBER%TYPE;
583: l_transaction_table HR_TRANSACTION_SS.TRANSACTION_TABLE;
584: l_count NUMBER;
585: l_effective_date date;
586: l_result varchar2(2000);

Line 887: l_login_person_id HR_API_TRANSACTIONS.CREATOR_PERSON_ID%TYPE;

883: l_cost_allocation_keyflex_id PAY_COST_ALLOCATION_KEYFLEX.COST_ALLOCATION_KEYFLEX_ID%TYPE;
884: l_object_version_number PAY_COST_ALLOCATIONS_F.OBJECT_VERSION_NUMBER%TYPE;
885: l_combination_name PAY_COST_ALLOCATION_KEYFLEX.CONCATENATED_SEGMENTS%TYPE;
886: l_cost_allocation_id PAY_COST_ALLOCATIONS_F.COST_ALLOCATION_ID%TYPE;
887: l_login_person_id HR_API_TRANSACTIONS.CREATOR_PERSON_ID%TYPE;
888: l_update_datetrack_mode VARCHAR2(20);
889: BEGIN
890:
891: if g_debug then

Line 1075: l_transaction_id HR_API_TRANSACTIONS.TRANSACTION_ID%TYPE;

1071: ,P_TRANSACTION_STEP_ID OUT NOCOPY NUMBER
1072: ) is
1073: l_proc varchar2(100) := g_package||'DELETE_ASSG_COST';
1074:
1075: l_transaction_id HR_API_TRANSACTIONS.TRANSACTION_ID%TYPE;
1076: l_transaction_step_id HR_API_TRANSACTION_STEPS.TRANSACTION_STEP_ID%TYPE;
1077: l_trs_object_version_number HR_API_TRANSACTION_STEPS.OBJECT_VERSION_NUMBER%TYPE;
1078: l_transaction_table HR_TRANSACTION_SS.TRANSACTION_TABLE;
1079: l_count NUMBER;

Line 1076: l_transaction_step_id HR_API_TRANSACTION_STEPS.TRANSACTION_STEP_ID%TYPE;

1072: ) is
1073: l_proc varchar2(100) := g_package||'DELETE_ASSG_COST';
1074:
1075: l_transaction_id HR_API_TRANSACTIONS.TRANSACTION_ID%TYPE;
1076: l_transaction_step_id HR_API_TRANSACTION_STEPS.TRANSACTION_STEP_ID%TYPE;
1077: l_trs_object_version_number HR_API_TRANSACTION_STEPS.OBJECT_VERSION_NUMBER%TYPE;
1078: l_transaction_table HR_TRANSACTION_SS.TRANSACTION_TABLE;
1079: l_count NUMBER;
1080: l_result VARCHAR2(100);

Line 1077: l_trs_object_version_number HR_API_TRANSACTION_STEPS.OBJECT_VERSION_NUMBER%TYPE;

1073: l_proc varchar2(100) := g_package||'DELETE_ASSG_COST';
1074:
1075: l_transaction_id HR_API_TRANSACTIONS.TRANSACTION_ID%TYPE;
1076: l_transaction_step_id HR_API_TRANSACTION_STEPS.TRANSACTION_STEP_ID%TYPE;
1077: l_trs_object_version_number HR_API_TRANSACTION_STEPS.OBJECT_VERSION_NUMBER%TYPE;
1078: l_transaction_table HR_TRANSACTION_SS.TRANSACTION_TABLE;
1079: l_count NUMBER;
1080: l_result VARCHAR2(100);
1081: L_EFFECTIVE_DATE DATE;

Line 1215: l_login_person_id HR_API_TRANSACTIONS.CREATOR_PERSON_ID%TYPE;

1211: l_effective_end_date date;
1212: l_object_version_number PAY_COST_ALLOCATIONS_F.OBJECT_VERSION_NUMBER%TYPE;
1213: l_combination_name PAY_COST_ALLOCATION_KEYFLEX.CONCATENATED_SEGMENTS%TYPE;
1214: l_cost_allocation_id PAY_COST_ALLOCATIONS_F.COST_ALLOCATION_ID%TYPE;
1215: l_login_person_id HR_API_TRANSACTIONS.CREATOR_PERSON_ID%TYPE;
1216: l_datetrack_delete_mode VARCHAR2(20);
1217:
1218: BEGIN
1219: IF g_debug THEN