APPS.QA_SAMPLING_PKG dependencies on PO_LOOKUP_CODES

Line 1300: -- po_lookup_codes otherwise it was causing an unhandled exception

1296: in_str varchar2(3000);
1297:
1298: -- anagarwa Fri Mar 29 11:56:16 PST 2002
1299: -- result_column needs to be same length as being selected from
1300: -- po_lookup_codes otherwise it was causing an unhandled exception
1301: -- on the click of OK button in RCV TXN form if sampling was involved.
1302:
1303: -- result_column varchar2(10);
1304: result_column po_lookup_codes.displayed_field%type;

Line 1304: result_column po_lookup_codes.displayed_field%type;

1300: -- po_lookup_codes otherwise it was causing an unhandled exception
1301: -- on the click of OK button in RCV TXN form if sampling was involved.
1302:
1303: -- result_column varchar2(10);
1304: result_column po_lookup_codes.displayed_field%type;
1305:
1306: sql_str varchar2(5000);
1307: result varchar2(20);
1308: reject_qty number;

Line 1350: -- displayed_field in po_lookup_codes is traslatable string

1346: -- proceed beyond this point means sampling_flag is Y
1347: result_column := get_softcoded_column (p_coll_plan_id);
1348:
1349: -- select in_str from po_lookupcodes instead of fnd_lookup_values as
1350: -- displayed_field in po_lookup_codes is traslatable string
1351: -- anagarwa Thu Oct 25 11:08:47 PDT 2001
1352:
1353: in_str :=
1354: 'select displayed_field ' ||

Line 1355: ' from po_lookup_codes ' ||

1351: -- anagarwa Thu Oct 25 11:08:47 PDT 2001
1352:
1353: in_str :=
1354: 'select displayed_field ' ||
1355: ' from po_lookup_codes ' ||
1356: ' where lookup_type = ''ERT RESULTS ACTION''' ||
1357: ' and lookup_code = ''REJECT''';
1358: /*
1359: in_str :=

Line 2099: l_result_column po_lookup_codes.displayed_field%type;

2095: TYPE insp_cur IS REF CURSOR;
2096: insp_acc insp_cur;
2097: insp_rej insp_cur;
2098:
2099: l_result_column po_lookup_codes.displayed_field%type;
2100:
2101: l_occurrence NUMBER;
2102: l_org_id NUMBER;
2103: l_item_id NUMBER;

Line 2143: ' from po_lookup_codes' ||

2139: -- the results entered in Inspection Plan in qa_results.
2140:
2141: in_str_reject :=
2142: ' select displayed_field' ||
2143: ' from po_lookup_codes' ||
2144: ' where lookup_type = ''ERT RESULTS ACTION''' ||
2145: ' and lookup_code = ''REJECT''';
2146:
2147:

Line 2150: ' from po_lookup_codes ' ||

2146:
2147:
2148: in_str_accept :=
2149: ' select displayed_field' ||
2150: ' from po_lookup_codes ' ||
2151: ' where lookup_type = ''ERT RESULTS ACTION''' ||
2152: ' and lookup_code = ''ACCEPT''';
2153:
2154: