DBA Data[Home] [Help]

APPS.HR_KI_WF_MISC dependencies on ECX_TP_DETAILS_V

Line 98: l_trans_type ecx_tp_details_v.transaction_type%type;

94: funcmode in VARCHAR2,
95: result in out NOCOPY VARCHAR2)
96: IS
97:
98: l_trans_type ecx_tp_details_v.transaction_type%type;
99: l_trans_subtype ecx_tp_details_v.transaction_subtype%type;
100: l_party_id ecx_tp_headers_v.party_id%type;
101: l_party_site_id ecx_tp_headers_v.party_site_id%type;
102:

Line 99: l_trans_subtype ecx_tp_details_v.transaction_subtype%type;

95: result in out NOCOPY VARCHAR2)
96: IS
97:
98: l_trans_type ecx_tp_details_v.transaction_type%type;
99: l_trans_subtype ecx_tp_details_v.transaction_subtype%type;
100: l_party_id ecx_tp_headers_v.party_id%type;
101: l_party_site_id ecx_tp_headers_v.party_site_id%type;
102:
103: l_enabled number;

Line 127: ,ecx_tp_details_v etd

123:
124: select etd.confirmation
125: into l_enabled
126: from ecx_tp_headers_v eth
127: ,ecx_tp_details_v etd
128: where eth.tp_header_id=etd.tp_header_id
129: and eth.party_id = l_party_id
130: and eth.party_site_id =l_party_site_id
131: and etd.transaction_type=l_trans_type