APPS.HR_PAY_RATE_GSP_SS dependencies on PER_PAY_TRANSACTIONS

Line 584: select pay_transaction_id from per_pay_transactions where

580: )
581: is
582:
583: cursor pay_txn is
584: select pay_transaction_id from per_pay_transactions where
585: item_type=p_item_type and item_key=p_item_key and status='NEW';
586:
587: cursor proposals_id is
588: select pay_proposal_id from per_pay_proposals where assignment_id=p_assignment_id and

Line 594: pay_txn_id per_pay_transactions.pay_transaction_id%type;

590:
591: message VARCHAR2(10000) := '';
592: l_pay_basis_id Per_All_Assignments_F.pay_basis_id%TYPE;
593: l_old_pay_basis_id Per_All_Assignments_F.pay_basis_id%TYPE;
594: pay_txn_id per_pay_transactions.pay_transaction_id%type;
595: pay_prop_id per_pay_proposals.pay_proposal_id%type;
596:
597: begin
598: l_pay_basis_id := p_pay_basis_id;

Line 613: update per_pay_transactions set

609: open pay_txn;
610: fetch pay_txn into pay_txn_id;
611:
612: if pay_txn%found then
613: update per_pay_transactions set
614: PAY_BASIS_ID = l_pay_basis_id,
615: change_amount_n = p_ltt_salary_data(1).salary_change_amount,
616: change_percentage = p_ltt_salary_data(1).salary_change_percent,
617: PROPOSED_SALARY_N = p_ltt_salary_data(1).proposed_salary

Line 630: insert into per_pay_transactions(

626: fetch proposals_id into pay_prop_id;
627: close proposals_id;
628:
629: if pay_prop_id is not null then
630: insert into per_pay_transactions(
631: PAY_TRANSACTION_ID ,--PAY_TRANSACTION_ID,
632: TRANSACTION_ID, -- TRANSACTION_ID,
633: TRANSACTION_STEP_ID,-- TRANSACTION_STEP_ID,
634: ITEM_TYPE,-- ITEM_TYPE,

Line 658: PER_PAY_TRANSACTIONS_S.NEXTVAL ,--PAY_TRANSACTION_ID,

654: STATUS,-- STATUS,
655: DML_OPERATION,-- DML_OPERATION,
656: object_version_number)
657: values(
658: PER_PAY_TRANSACTIONS_S.NEXTVAL ,--PAY_TRANSACTION_ID,
659: p_transaction_id, -- TRANSACTION_ID,
660: p_transaction_step_id,-- TRANSACTION_STEP_ID,
661: p_item_type,-- ITEM_TYPE,
662: p_item_key,-- ITEM_KEY,

Line 687: insert into per_pay_transactions(

683: 1);
684:
685: end if;
686:
687: insert into per_pay_transactions(
688: PAY_TRANSACTION_ID ,--PAY_TRANSACTION_ID,
689: TRANSACTION_ID, -- TRANSACTION_ID,
690: TRANSACTION_STEP_ID,-- TRANSACTION_STEP_ID,
691: ITEM_TYPE,-- ITEM_TYPE,

Line 715: PER_PAY_TRANSACTIONS_S.NEXTVAL ,--PAY_TRANSACTION_ID,

711: STATUS,-- STATUS,
712: DML_OPERATION,-- DML_OPERATION,
713: object_version_number)
714: values(
715: PER_PAY_TRANSACTIONS_S.NEXTVAL ,--PAY_TRANSACTION_ID,
716: p_transaction_id, -- TRANSACTION_ID,
717: p_transaction_step_id,-- TRANSACTION_STEP_ID,
718: p_item_type,-- ITEM_TYPE,
719: p_item_key,-- ITEM_KEY,