DBA Data[Home] [Help]

APPS.PA_PROJECT_REQUEST_PVT dependencies on PA_PLSQL_DATATYPES

Line 270: l_object_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;

266: CONNECT BY (PRIOR object_id_to1 = object_id_from1
267: AND PRIOR object_type_to = object_type_from
268: AND PRIOR object_id_from1 <> object_id_to1);
269:
270: l_object_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
271: l_object_id1_tbl PA_PLSQL_DATATYPES.Char240TabTyp;
272: l_object_id2_tbl PA_PLSQL_DATATYPES.Char240TabTyp;
273: l_object_id3_tbl PA_PLSQL_DATATYPES.Char240TabTyp;
274: l_object_id4_tbl PA_PLSQL_DATATYPES.Char240TabTyp;

Line 271: l_object_id1_tbl PA_PLSQL_DATATYPES.Char240TabTyp;

267: AND PRIOR object_type_to = object_type_from
268: AND PRIOR object_id_from1 <> object_id_to1);
269:
270: l_object_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
271: l_object_id1_tbl PA_PLSQL_DATATYPES.Char240TabTyp;
272: l_object_id2_tbl PA_PLSQL_DATATYPES.Char240TabTyp;
273: l_object_id3_tbl PA_PLSQL_DATATYPES.Char240TabTyp;
274: l_object_id4_tbl PA_PLSQL_DATATYPES.Char240TabTyp;
275: l_object_id5_tbl PA_PLSQL_DATATYPES.Char240TabTyp;

Line 272: l_object_id2_tbl PA_PLSQL_DATATYPES.Char240TabTyp;

268: AND PRIOR object_id_from1 <> object_id_to1);
269:
270: l_object_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
271: l_object_id1_tbl PA_PLSQL_DATATYPES.Char240TabTyp;
272: l_object_id2_tbl PA_PLSQL_DATATYPES.Char240TabTyp;
273: l_object_id3_tbl PA_PLSQL_DATATYPES.Char240TabTyp;
274: l_object_id4_tbl PA_PLSQL_DATATYPES.Char240TabTyp;
275: l_object_id5_tbl PA_PLSQL_DATATYPES.Char240TabTyp;
276: l_object_name_tbl PA_PLSQL_DATATYPES.Char80TabTyp;

Line 273: l_object_id3_tbl PA_PLSQL_DATATYPES.Char240TabTyp;

269:
270: l_object_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
271: l_object_id1_tbl PA_PLSQL_DATATYPES.Char240TabTyp;
272: l_object_id2_tbl PA_PLSQL_DATATYPES.Char240TabTyp;
273: l_object_id3_tbl PA_PLSQL_DATATYPES.Char240TabTyp;
274: l_object_id4_tbl PA_PLSQL_DATATYPES.Char240TabTyp;
275: l_object_id5_tbl PA_PLSQL_DATATYPES.Char240TabTyp;
276: l_object_name_tbl PA_PLSQL_DATATYPES.Char80TabTyp;
277: l_object_number_tbl PA_PLSQL_DATATYPES.Char80TabTyp;

Line 274: l_object_id4_tbl PA_PLSQL_DATATYPES.Char240TabTyp;

270: l_object_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
271: l_object_id1_tbl PA_PLSQL_DATATYPES.Char240TabTyp;
272: l_object_id2_tbl PA_PLSQL_DATATYPES.Char240TabTyp;
273: l_object_id3_tbl PA_PLSQL_DATATYPES.Char240TabTyp;
274: l_object_id4_tbl PA_PLSQL_DATATYPES.Char240TabTyp;
275: l_object_id5_tbl PA_PLSQL_DATATYPES.Char240TabTyp;
276: l_object_name_tbl PA_PLSQL_DATATYPES.Char80TabTyp;
277: l_object_number_tbl PA_PLSQL_DATATYPES.Char80TabTyp;
278: l_object_type_name_tbl PA_PLSQL_DATATYPES.Char80TabTyp;

Line 275: l_object_id5_tbl PA_PLSQL_DATATYPES.Char240TabTyp;

271: l_object_id1_tbl PA_PLSQL_DATATYPES.Char240TabTyp;
272: l_object_id2_tbl PA_PLSQL_DATATYPES.Char240TabTyp;
273: l_object_id3_tbl PA_PLSQL_DATATYPES.Char240TabTyp;
274: l_object_id4_tbl PA_PLSQL_DATATYPES.Char240TabTyp;
275: l_object_id5_tbl PA_PLSQL_DATATYPES.Char240TabTyp;
276: l_object_name_tbl PA_PLSQL_DATATYPES.Char80TabTyp;
277: l_object_number_tbl PA_PLSQL_DATATYPES.Char80TabTyp;
278: l_object_type_name_tbl PA_PLSQL_DATATYPES.Char80TabTyp;
279: l_object_subtype_tbl PA_PLSQL_DATATYPES.Char80TabTyp;

Line 276: l_object_name_tbl PA_PLSQL_DATATYPES.Char80TabTyp;

272: l_object_id2_tbl PA_PLSQL_DATATYPES.Char240TabTyp;
273: l_object_id3_tbl PA_PLSQL_DATATYPES.Char240TabTyp;
274: l_object_id4_tbl PA_PLSQL_DATATYPES.Char240TabTyp;
275: l_object_id5_tbl PA_PLSQL_DATATYPES.Char240TabTyp;
276: l_object_name_tbl PA_PLSQL_DATATYPES.Char80TabTyp;
277: l_object_number_tbl PA_PLSQL_DATATYPES.Char80TabTyp;
278: l_object_type_name_tbl PA_PLSQL_DATATYPES.Char80TabTyp;
279: l_object_subtype_tbl PA_PLSQL_DATATYPES.Char80TabTyp;
280: l_status_name_tbl PA_PLSQL_DATATYPES.Char80TabTyp;

Line 277: l_object_number_tbl PA_PLSQL_DATATYPES.Char80TabTyp;

273: l_object_id3_tbl PA_PLSQL_DATATYPES.Char240TabTyp;
274: l_object_id4_tbl PA_PLSQL_DATATYPES.Char240TabTyp;
275: l_object_id5_tbl PA_PLSQL_DATATYPES.Char240TabTyp;
276: l_object_name_tbl PA_PLSQL_DATATYPES.Char80TabTyp;
277: l_object_number_tbl PA_PLSQL_DATATYPES.Char80TabTyp;
278: l_object_type_name_tbl PA_PLSQL_DATATYPES.Char80TabTyp;
279: l_object_subtype_tbl PA_PLSQL_DATATYPES.Char80TabTyp;
280: l_status_name_tbl PA_PLSQL_DATATYPES.Char80TabTyp;
281: l_description_tbl PA_PLSQL_DATATYPES.Char250TabTyp;

Line 278: l_object_type_name_tbl PA_PLSQL_DATATYPES.Char80TabTyp;

274: l_object_id4_tbl PA_PLSQL_DATATYPES.Char240TabTyp;
275: l_object_id5_tbl PA_PLSQL_DATATYPES.Char240TabTyp;
276: l_object_name_tbl PA_PLSQL_DATATYPES.Char80TabTyp;
277: l_object_number_tbl PA_PLSQL_DATATYPES.Char80TabTyp;
278: l_object_type_name_tbl PA_PLSQL_DATATYPES.Char80TabTyp;
279: l_object_subtype_tbl PA_PLSQL_DATATYPES.Char80TabTyp;
280: l_status_name_tbl PA_PLSQL_DATATYPES.Char80TabTyp;
281: l_description_tbl PA_PLSQL_DATATYPES.Char250TabTyp;
282:

Line 279: l_object_subtype_tbl PA_PLSQL_DATATYPES.Char80TabTyp;

275: l_object_id5_tbl PA_PLSQL_DATATYPES.Char240TabTyp;
276: l_object_name_tbl PA_PLSQL_DATATYPES.Char80TabTyp;
277: l_object_number_tbl PA_PLSQL_DATATYPES.Char80TabTyp;
278: l_object_type_name_tbl PA_PLSQL_DATATYPES.Char80TabTyp;
279: l_object_subtype_tbl PA_PLSQL_DATATYPES.Char80TabTyp;
280: l_status_name_tbl PA_PLSQL_DATATYPES.Char80TabTyp;
281: l_description_tbl PA_PLSQL_DATATYPES.Char250TabTyp;
282:
283: j NUMBER := 1;

Line 280: l_status_name_tbl PA_PLSQL_DATATYPES.Char80TabTyp;

276: l_object_name_tbl PA_PLSQL_DATATYPES.Char80TabTyp;
277: l_object_number_tbl PA_PLSQL_DATATYPES.Char80TabTyp;
278: l_object_type_name_tbl PA_PLSQL_DATATYPES.Char80TabTyp;
279: l_object_subtype_tbl PA_PLSQL_DATATYPES.Char80TabTyp;
280: l_status_name_tbl PA_PLSQL_DATATYPES.Char80TabTyp;
281: l_description_tbl PA_PLSQL_DATATYPES.Char250TabTyp;
282:
283: j NUMBER := 1;
284:

Line 281: l_description_tbl PA_PLSQL_DATATYPES.Char250TabTyp;

277: l_object_number_tbl PA_PLSQL_DATATYPES.Char80TabTyp;
278: l_object_type_name_tbl PA_PLSQL_DATATYPES.Char80TabTyp;
279: l_object_subtype_tbl PA_PLSQL_DATATYPES.Char80TabTyp;
280: l_status_name_tbl PA_PLSQL_DATATYPES.Char80TabTyp;
281: l_description_tbl PA_PLSQL_DATATYPES.Char250TabTyp;
282:
283: j NUMBER := 1;
284:
285: BEGIN

Line 511: l_person_role_type_tab PA_PLSQL_DATATYPES.Char250TabTyp;

507: l_dest_value_pk5 NUMBER;
508: -- added for Bug Fix: 4537865
509: l_new_msg_data VARCHAR2(2000);
510: -- added for Bug Fix: 4537865
511: l_person_role_type_tab PA_PLSQL_DATATYPES.Char250TabTyp;
512: l_key_member_tab PA_PLSQL_DATATYPES.Char250TabTyp;
513:
514: l_lead_number AS_LEADS_ALL.lead_number%TYPE;
515: l_lead_description AS_LEADS_ALL.description%TYPE;

Line 512: l_key_member_tab PA_PLSQL_DATATYPES.Char250TabTyp;

508: -- added for Bug Fix: 4537865
509: l_new_msg_data VARCHAR2(2000);
510: -- added for Bug Fix: 4537865
511: l_person_role_type_tab PA_PLSQL_DATATYPES.Char250TabTyp;
512: l_key_member_tab PA_PLSQL_DATATYPES.Char250TabTyp;
513:
514: l_lead_number AS_LEADS_ALL.lead_number%TYPE;
515: l_lead_description AS_LEADS_ALL.description%TYPE;
516: l_request_type_meaning FND_LOOKUPS.meaning%TYPE;

Line 1716: l_recipient_tab pa_plsql_datatypes.Char240TabTyp;

1712: l_new_opportunity_value pa_project_opp_attrs.opportunity_value%TYPE;
1713: l_new_opp_value_currency_code pa_project_opp_attrs.opp_value_currency_code%TYPE;
1714: l_new_expected_approval_date pa_projects_all.expected_approval_date%TYPE;
1715:
1716: l_recipient_tab pa_plsql_datatypes.Char240TabTyp;
1717: l_project_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1718: l_lead_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1719: l_project_count_tab PA_PLSQL_DATATYPES.IdTabTyp;
1720:

Line 1717: l_project_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

1713: l_new_opp_value_currency_code pa_project_opp_attrs.opp_value_currency_code%TYPE;
1714: l_new_expected_approval_date pa_projects_all.expected_approval_date%TYPE;
1715:
1716: l_recipient_tab pa_plsql_datatypes.Char240TabTyp;
1717: l_project_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1718: l_lead_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1719: l_project_count_tab PA_PLSQL_DATATYPES.IdTabTyp;
1720:
1721: l_record_version_number NUMBER;

Line 1718: l_lead_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

1714: l_new_expected_approval_date pa_projects_all.expected_approval_date%TYPE;
1715:
1716: l_recipient_tab pa_plsql_datatypes.Char240TabTyp;
1717: l_project_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1718: l_lead_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1719: l_project_count_tab PA_PLSQL_DATATYPES.IdTabTyp;
1720:
1721: l_record_version_number NUMBER;
1722: l_dest_value_pk2 NUMBER;

Line 1719: l_project_count_tab PA_PLSQL_DATATYPES.IdTabTyp;

1715:
1716: l_recipient_tab pa_plsql_datatypes.Char240TabTyp;
1717: l_project_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1718: l_lead_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1719: l_project_count_tab PA_PLSQL_DATATYPES.IdTabTyp;
1720:
1721: l_record_version_number NUMBER;
1722: l_dest_value_pk2 NUMBER;
1723: l_dest_value_pk3 NUMBER;