DBA Data[Home] [Help]

APPS.PV_AME_API_W dependencies on PVX_UTILITY_PVT

Line 73: l_log_params_tbl pvx_utility_pvt.log_params_tbl_type;

69: FOR UPDATE NOWAIT;
70:
71: l_message_name VARCHAR2(30);
72: l_partner_id NUMBER;
73: l_log_params_tbl pvx_utility_pvt.log_params_tbl_type;
74: l_approver_name varchar2(50);
75: l_return_status VARCHAR2(30);
76: l_msg_count NUMBER;
77: l_msg_data VARCHAR2(1000);

Line 177: PVX_Utility_PVT.create_history_log(

173: l_log_params_tbl(2).param_value := l_approver_name;
174:
175: update pv_referrals_b set customer_country = p_country_code where referral_id = p_referral_id;
176:
177: PVX_Utility_PVT.create_history_log(
178: p_arc_history_for_entity_code => p_approval_entity,
179: p_history_for_entity_id => p_referral_id,
180: p_history_category_code => 'GENERAL',
181: p_message_code => l_message_name,

Line 184: p_interaction_level => pvx_utility_pvt.G_INTERACTION_LEVEL_10,

180: p_history_category_code => 'GENERAL',
181: p_message_code => l_message_name,
182: p_partner_id => l_partner_id,
183: p_access_level_flag => 'V',
184: p_interaction_level => pvx_utility_pvt.G_INTERACTION_LEVEL_10,
185: p_comments => NULL,
186: p_log_params_tbl => l_log_params_tbl,
187: x_return_status => l_return_status,
188: x_msg_count => l_msg_count,

Line 367: PVX_Utility_PVT.create_history_log(

363: END LOOP;
364:
365: l_log_params_tbl(1).param_name := 'APPROVER';
366:
367: PVX_Utility_PVT.create_history_log(
368: p_arc_history_for_entity_code => l_benefit_type_code,
369: p_history_for_entity_id => p_referral_id,
370: p_history_category_code => 'GENERAL',
371: p_message_code => l_message_name,

Line 374: p_interaction_level => pvx_utility_pvt.G_INTERACTION_LEVEL_10,

370: p_history_category_code => 'GENERAL',
371: p_message_code => l_message_name,
372: p_partner_id => l_partner_id,
373: p_access_level_flag => 'V',
374: p_interaction_level => pvx_utility_pvt.G_INTERACTION_LEVEL_10,
375: p_comments => NULL,
376: p_log_params_tbl => l_log_params_tbl,
377: x_return_status => l_return_status,
378: x_msg_count => l_msg_count,

Line 474: l_log_params_tbl pvx_utility_pvt.log_params_tbl_type;

470: l_sec_lvl_reject BOOLEAN;
471: l_temp VARCHAR2(5);
472: l_isDefAppr BOOLEAN;
473: l_appr_status VARCHAR2(20);
474: l_log_params_tbl pvx_utility_pvt.log_params_tbl_type;
475: l_message_code VARCHAR2(30);
476: l_approver_name VARCHAR2(100);
477: l_approver_category VARCHAR2(30);
478: l_approver_source_id NUMBER;

Line 748: PVX_Utility_PVT.create_history_log(

744: );
745: END IF;
746:
747:
748: PVX_Utility_PVT.create_history_log(
749: p_arc_history_for_entity_code => p_approval_entity,
750: p_history_for_entity_id => p_referral_id,
751: p_history_category_code => 'GENERAL',
752: p_message_code => l_message_code,

Line 755: p_interaction_level => pvx_utility_pvt.G_INTERACTION_LEVEL_10,

751: p_history_category_code => 'GENERAL',
752: p_message_code => l_message_code,
753: p_partner_id => l_partner_id,
754: p_access_level_flag => 'V',
755: p_interaction_level => pvx_utility_pvt.G_INTERACTION_LEVEL_10,
756: p_comments => NULL,
757: p_log_params_tbl => l_log_params_tbl,
758: x_return_status => l_return_status,
759: x_msg_count => l_msg_count,

Line 1109: PVX_Utility_PVT.create_history_log(

1105: ,'Logging who the next approver is: ' || l_approver_name
1106: );
1107: END IF;
1108:
1109: PVX_Utility_PVT.create_history_log(
1110: p_arc_history_for_entity_code => p_approval_entity,
1111: p_history_for_entity_id => p_referral_id,
1112: p_history_category_code => 'GENERAL',
1113: p_message_code => l_message_code,

Line 1116: p_interaction_level => pvx_utility_pvt.G_INTERACTION_LEVEL_10,

1112: p_history_category_code => 'GENERAL',
1113: p_message_code => l_message_code,
1114: p_partner_id => l_partner_id,
1115: p_access_level_flag => 'V',
1116: p_interaction_level => pvx_utility_pvt.G_INTERACTION_LEVEL_10,
1117: p_comments => NULL,
1118: p_log_params_tbl => l_log_params_tbl,
1119: x_return_status => l_return_status,
1120: x_msg_count => l_msg_count,