APPS.PA_ADVERTISEMENTS_PVT dependencies on PA_NUM_TBL_TYPE

Line 1055: l_ntf_recipient_person_id_tbl system.pa_num_tbl_type;

1051: AND trunc(sysdate) BETWEEN per.effective_start_date
1052: AND per.effective_end_date;
1053: -- End of Performance Fix 4898314 SQL ID 14906422
1054:
1055: l_ntf_recipient_person_id_tbl system.pa_num_tbl_type;
1056: l_ntf_recipient_name_tbl system.pa_varchar2_240_tbl_type;
1057: l_return_status VARCHAR2(1);
1058: l_wf_process VARCHAR2(30);
1059: l_encoded_message_text VARCHAR2(2000);

Line 1193: , p_ntf_recipient_person_id_tbl IN system.pa_num_tbl_type := NULL

1189: -- Start Workflow process to send advertisement notification
1190: ----------------------------------------------------------------------
1191: PROCEDURE Start_Adv_Notification_WF (
1192: p_action_code IN pa_action_set_lines.action_code%TYPE
1193: , p_ntf_recipient_person_id_tbl IN system.pa_num_tbl_type := NULL
1194: , p_ntf_recipient_name_tbl IN system.pa_varchar2_240_tbl_type := NULL
1195: , p_wf_user_name IN VARCHAR2 := NULL
1196: , p_wf_process IN VARCHAR2
1197: , p_wf_item_type IN VARCHAR2 := 'PARADVWF'

Line 1204: l_ntf_recipient_person_id_tbl system.pa_num_tbl_type;

1200: , p_insert_audit_flag IN VARCHAR2 := 'T'
1201: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1202: ) IS
1203:
1204: l_ntf_recipient_person_id_tbl system.pa_num_tbl_type;
1205: l_wf_item_key NUMBER;
1206: l_set_text_attr_name_tbl Wf_Engine.NameTabTyp;
1207: l_set_text_attr_value_tbl Wf_Engine.TextTabTyp;
1208: l_set_num_attr_name_tbl Wf_Engine.NameTabTyp;