DBA Data[Home] [Help]

APPS.PQH_PTX_UTL dependencies on PQH_POSITION_TRANSACTIONS

Line 21: p_position_transaction_id out nocopy pqh_position_transactions.position_transaction_id%TYPE,

17: -- ----------------------------------------------------------------------------
18:
19: procedure fetch_position
20: (
21: p_position_transaction_id out nocopy pqh_position_transactions.position_transaction_id%TYPE,
22: p_position_id in pqh_position_transactions.position_id%TYPE,
23: p_action_date in date,
24: p_review_flag in pqh_position_transactions.review_flag%type
25: );

Line 22: p_position_id in pqh_position_transactions.position_id%TYPE,

18:
19: procedure fetch_position
20: (
21: p_position_transaction_id out nocopy pqh_position_transactions.position_transaction_id%TYPE,
22: p_position_id in pqh_position_transactions.position_id%TYPE,
23: p_action_date in date,
24: p_review_flag in pqh_position_transactions.review_flag%type
25: );
26: --

Line 24: p_review_flag in pqh_position_transactions.review_flag%type

20: (
21: p_position_transaction_id out nocopy pqh_position_transactions.position_transaction_id%TYPE,
22: p_position_id in pqh_position_transactions.position_id%TYPE,
23: p_action_date in date,
24: p_review_flag in pqh_position_transactions.review_flag%type
25: );
26: --
27: --PROCEDURE create_shadow_record(p_position_transaction_id number,p_position_id number);
28: --

Line 35: p_position_transaction_id in pqh_position_transactions.position_transaction_id%TYPE,

31: -- ----------------------------------------------------------------------------
32:
33: procedure populate_pei
34: (
35: p_position_transaction_id in pqh_position_transactions.position_transaction_id%TYPE,
36: p_position_id in pqh_position_transactions.position_id%TYPE,
37: p_populated in out nocopy varchar2
38: );
39:

Line 36: p_position_id in pqh_position_transactions.position_id%TYPE,

32:
33: procedure populate_pei
34: (
35: p_position_transaction_id in pqh_position_transactions.position_transaction_id%TYPE,
36: p_position_id in pqh_position_transactions.position_id%TYPE,
37: p_populated in out nocopy varchar2
38: );
39:
40: -- ----------------------------------------------------------------------------

Line 51: ( p_transaction_id in pqh_position_transactions.position_transaction_id%TYPE ,

47: -- |------------------------< apply_transaction >------------------------|
48: -- ----------------------------------------------------------------------------
49:
50: function apply_transaction
51: ( p_transaction_id in pqh_position_transactions.position_transaction_id%TYPE ,
52: p_validate_only in varchar2 default 'NO'
53: ) return varchar2;
54:
55: --------------------------------------------------------------------------------

Line 114: p_position_transaction_id in pqh_position_transactions.position_transaction_id%TYPE,

110: -- ----------------------------------------------------------------------------
111: --
112: procedure populate_job_requirements
113: (
114: p_position_transaction_id in pqh_position_transactions.position_transaction_id%TYPE,
115: p_position_id in pqh_position_transactions.position_id%TYPE,
116: p_populated in out nocopy varchar2
117: );
118: --

Line 115: p_position_id in pqh_position_transactions.position_id%TYPE,

111: --
112: procedure populate_job_requirements
113: (
114: p_position_transaction_id in pqh_position_transactions.position_transaction_id%TYPE,
115: p_position_id in pqh_position_transactions.position_id%TYPE,
116: p_populated in out nocopy varchar2
117: );
118: --
119: --------------------------------------------------------------------------------