APPS.HZ_PARTY_ACQUIRE dependencies on DBMS_SQL

Line 462: c := dbms_sql.open_cursor;

458:
459: FETCH custom_attribs INTO g_party_custom_attrs(NUM), g_party_custom_procs(NUM);
460: EXIT WHEN custom_attribs%NOTFOUND;
461:
462: c := dbms_sql.open_cursor;
463: l_sql := 'select '|| g_party_custom_procs(NUM) || '(:record_id, :entity_name, :attribute_name) from dual';
464: BEGIN
465: dbms_sql.parse(c,l_sql,2);
466: g_party_custom_valid(NUM) := 'Y';

Line 465: dbms_sql.parse(c,l_sql,2);

461:
462: c := dbms_sql.open_cursor;
463: l_sql := 'select '|| g_party_custom_procs(NUM) || '(:record_id, :entity_name, :attribute_name) from dual';
464: BEGIN
465: dbms_sql.parse(c,l_sql,2);
466: g_party_custom_valid(NUM) := 'Y';
467: EXCEPTION
468: WHEN OTHERS THEN
469: g_party_custom_valid(NUM) := 'N';

Line 473: dbms_sql.close_cursor(c);

469: g_party_custom_valid(NUM) := 'N';
470: FND_FILE.put_line(fnd_file.log,'Error parsing custom attribute procedure ' || g_party_custom_procs(NUM) ||
471: ' for attribute PARTY.'||g_party_custom_attrs(NUM));
472: END;
473: dbms_sql.close_cursor(c);
474:
475: NUM := NUM+1;
476: END LOOP;
477: CLOSE custom_attribs;

Line 712: c := dbms_sql.open_cursor;

708:
709: FETCH custom_attribs INTO g_ps_custom_attrs(NUM), g_ps_custom_procs(NUM);
710: EXIT WHEN custom_attribs%NOTFOUND;
711:
712: c := dbms_sql.open_cursor;
713: l_sql := 'select '|| g_ps_custom_procs(NUM) || '(:record_id, :entity_name, :attribute_name) from dual';
714: BEGIN
715: dbms_sql.parse(c,l_sql,2);
716: g_ps_custom_valid(NUM) := 'Y';

Line 715: dbms_sql.parse(c,l_sql,2);

711:
712: c := dbms_sql.open_cursor;
713: l_sql := 'select '|| g_ps_custom_procs(NUM) || '(:record_id, :entity_name, :attribute_name) from dual';
714: BEGIN
715: dbms_sql.parse(c,l_sql,2);
716: g_ps_custom_valid(NUM) := 'Y';
717: EXCEPTION
718: WHEN OTHERS THEN
719: g_ps_custom_valid(NUM) := 'N';

Line 723: dbms_sql.close_cursor(c);

719: g_ps_custom_valid(NUM) := 'N';
720: FND_FILE.put_line(fnd_file.log,'Error parsing custom attribute procedure ' || g_ps_custom_procs(NUM) ||
721: ' for attribute PARTY.'||g_ps_custom_attrs(NUM));
722: END;
723: dbms_sql.close_cursor(c);
724:
725: NUM := NUM+1;
726: END LOOP;
727: CLOSE custom_attribs;

Line 965: c := dbms_sql.open_cursor;

961:
962: FETCH custom_attribs INTO g_cont_custom_attrs(NUM), g_cont_custom_procs(NUM);
963: EXIT WHEN custom_attribs%NOTFOUND;
964:
965: c := dbms_sql.open_cursor;
966: l_sql := 'select '|| g_cont_custom_procs(NUM) || '(:record_id, :entity_name, :attribute_name) from dual';
967: BEGIN
968: dbms_sql.parse(c,l_sql,2);
969: g_cont_custom_valid(NUM) := 'Y';

Line 968: dbms_sql.parse(c,l_sql,2);

964:
965: c := dbms_sql.open_cursor;
966: l_sql := 'select '|| g_cont_custom_procs(NUM) || '(:record_id, :entity_name, :attribute_name) from dual';
967: BEGIN
968: dbms_sql.parse(c,l_sql,2);
969: g_cont_custom_valid(NUM) := 'Y';
970: EXCEPTION
971: WHEN OTHERS THEN
972: g_cont_custom_valid(NUM) := 'N';

Line 976: dbms_sql.close_cursor(c);

972: g_cont_custom_valid(NUM) := 'N';
973: FND_FILE.put_line(fnd_file.log,'Error parsing custom attribute procedure ' || g_cont_custom_procs(NUM) ||
974: ' for attribute PARTY.'||g_cont_custom_attrs(NUM));
975: END;
976: dbms_sql.close_cursor(c);
977:
978: NUM := NUM+1;
979: END LOOP;
980: CLOSE custom_attribs;

Line 1191: c := dbms_sql.open_cursor;

1187:
1188: FETCH custom_attribs INTO g_cpt_custom_attrs(NUM), g_cpt_custom_procs(NUM);
1189: EXIT WHEN custom_attribs%NOTFOUND;
1190:
1191: c := dbms_sql.open_cursor;
1192:
1193: l_sql := 'select '|| g_cpt_custom_procs(NUM) || '(:record_id, :entity_name, :attribute_name) from dual';
1194: BEGIN
1195: dbms_sql.parse(c,l_sql,2);

Line 1195: dbms_sql.parse(c,l_sql,2);

1191: c := dbms_sql.open_cursor;
1192:
1193: l_sql := 'select '|| g_cpt_custom_procs(NUM) || '(:record_id, :entity_name, :attribute_name) from dual';
1194: BEGIN
1195: dbms_sql.parse(c,l_sql,2);
1196: g_cpt_custom_valid(NUM) := 'Y';
1197: EXCEPTION
1198: WHEN OTHERS THEN
1199: g_cpt_custom_valid(NUM) := 'N';

Line 1204: dbms_sql.close_cursor(c);

1200: FND_FILE.put_line(fnd_file.log,'Error parsing custom attribute procedure '
1201: || g_cpt_custom_procs(NUM) ||
1202: ' for attribute PARTY.'||g_cpt_custom_attrs(NUM));
1203: END;
1204: dbms_sql.close_cursor(c);
1205:
1206:
1207: NUM := NUM+1;
1208: END LOOP;