APPS.HR_PAY_RATE_GSP_SS dependencies on PER_PAY_TRANSACTIONS

Line 580: select pay_transaction_id from per_pay_transactions where

576: )
577: is
578:
579: cursor pay_txn is
580: select pay_transaction_id from per_pay_transactions where
581: item_type=p_item_type and item_key=p_item_key and status='NEW';
582:
583: cursor proposals_id is
584: select pay_proposal_id from per_pay_proposals where assignment_id=p_assignment_id and

Line 590: pay_txn_id per_pay_transactions.pay_transaction_id%type;

586:
587: message VARCHAR2(10000) := '';
588: l_pay_basis_id Per_All_Assignments_F.pay_basis_id%TYPE;
589: l_old_pay_basis_id Per_All_Assignments_F.pay_basis_id%TYPE;
590: pay_txn_id per_pay_transactions.pay_transaction_id%type;
591: pay_prop_id per_pay_proposals.pay_proposal_id%type;
592:
593: begin
594: l_pay_basis_id := p_pay_basis_id;

Line 609: update per_pay_transactions set

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

Line 626: insert into per_pay_transactions(

622: fetch proposals_id into pay_prop_id;
623: close proposals_id;
624:
625: if pay_prop_id is not null then
626: insert into per_pay_transactions(
627: PAY_TRANSACTION_ID ,--PAY_TRANSACTION_ID,
628: TRANSACTION_ID, -- TRANSACTION_ID,
629: TRANSACTION_STEP_ID,-- TRANSACTION_STEP_ID,
630: ITEM_TYPE,-- ITEM_TYPE,

Line 654: PER_PAY_TRANSACTIONS_S.NEXTVAL ,--PAY_TRANSACTION_ID,

650: STATUS,-- STATUS,
651: DML_OPERATION,-- DML_OPERATION,
652: object_version_number)
653: values(
654: PER_PAY_TRANSACTIONS_S.NEXTVAL ,--PAY_TRANSACTION_ID,
655: p_transaction_id, -- TRANSACTION_ID,
656: p_transaction_step_id,-- TRANSACTION_STEP_ID,
657: p_item_type,-- ITEM_TYPE,
658: p_item_key,-- ITEM_KEY,

Line 683: insert into per_pay_transactions(

679: 1);
680:
681: end if;
682:
683: insert into per_pay_transactions(
684: PAY_TRANSACTION_ID ,--PAY_TRANSACTION_ID,
685: TRANSACTION_ID, -- TRANSACTION_ID,
686: TRANSACTION_STEP_ID,-- TRANSACTION_STEP_ID,
687: ITEM_TYPE,-- ITEM_TYPE,

Line 711: PER_PAY_TRANSACTIONS_S.NEXTVAL ,--PAY_TRANSACTION_ID,

707: STATUS,-- STATUS,
708: DML_OPERATION,-- DML_OPERATION,
709: object_version_number)
710: values(
711: PER_PAY_TRANSACTIONS_S.NEXTVAL ,--PAY_TRANSACTION_ID,
712: p_transaction_id, -- TRANSACTION_ID,
713: p_transaction_step_id,-- TRANSACTION_STEP_ID,
714: p_item_type,-- ITEM_TYPE,
715: p_item_key,-- ITEM_KEY,