APPS.PQH_UTILITY dependencies on PQH_POSITION_TRANSACTIONS

Line 1178: from pqh_position_transactions ptx

1174: l_count_pending_txns number:=0;
1175: --
1176: cursor c_count_pending_txns(p_position_id number) is
1177: select count(*)
1178: from pqh_position_transactions ptx
1179: where position_id = p_position_id
1180: and nvl(ptx.transaction_status,'PENDING') in ('APPROVED','SUBMITTED','PENDING')
1181: and position_transaction_id <> nvl(p_position_transaction_id, -1);
1182: --

Line 1219: l_review_flag pqh_position_transactions.review_flag%TYPE; -- bug 6112935

1215: p_transaction_status varchar2,
1216: p_effective_date date default sysdate) is
1217: --
1218: l_object_version_number number;
1219: l_review_flag pqh_position_transactions.review_flag%TYPE; -- bug 6112935
1220: --
1221: cursor c_position_transactions(p_position_transaction_id number) is
1222: select object_version_number
1223: from pqh_position_transactions ptx

Line 1223: from pqh_position_transactions ptx

1219: l_review_flag pqh_position_transactions.review_flag%TYPE; -- bug 6112935
1220: --
1221: cursor c_position_transactions(p_position_transaction_id number) is
1222: select object_version_number
1223: from pqh_position_transactions ptx
1224: where position_transaction_id = p_position_transaction_id;
1225: --
1226: begin
1227: open c_position_transactions(p_position_transaction_id);

Line 1245: pqh_position_transactions_api.update_position_transaction

1241: end if;
1242: hr_utility.set_location('p_status '||p_transaction_status||'l_review_flag '||l_review_flag, 25);
1243:
1244: -- Update the position transaction
1245: pqh_position_transactions_api.update_position_transaction
1246: (
1247: p_validate => false
1248: ,p_position_transaction_id => p_position_transaction_id
1249: ,p_object_version_number => l_object_version_number

Line 1864: from pqh_position_transactions

1860: where position_id = p_position_id
1861: and effective_start_date > p_start_date
1862: union
1863: select action_date effective_start_date
1864: from pqh_position_transactions
1865: where position_id = p_position_id
1866: and action_date > p_start_date
1867: and transaction_status = 'SUBMITTED'
1868: );