APPS.QA_SAMPLING_PKG dependencies on PO_LOOKUP_CODES

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

1357: in_str varchar2(3000);
1358:
1359: -- anagarwa Fri Mar 29 11:56:16 PST 2002
1360: -- result_column needs to be same length as being selected from
1361: -- po_lookup_codes otherwise it was causing an unhandled exception
1362: -- on the click of OK button in RCV TXN form if sampling was involved.
1363:
1364: -- result_column varchar2(10);
1365: result_column po_lookup_codes.displayed_field%type;

Line 1365: result_column po_lookup_codes.displayed_field%type;

1361: -- po_lookup_codes otherwise it was causing an unhandled exception
1362: -- on the click of OK button in RCV TXN form if sampling was involved.
1363:
1364: -- result_column varchar2(10);
1365: result_column po_lookup_codes.displayed_field%type;
1366:
1367: sql_str varchar2(5000);
1368: result varchar2(20);
1369: reject_qty number;

Line 1411: -- displayed_field in po_lookup_codes is traslatable string

1407: -- proceed beyond this point means sampling_flag is Y
1408: result_column := get_softcoded_column (p_coll_plan_id);
1409:
1410: -- select in_str from po_lookupcodes instead of fnd_lookup_values as
1411: -- displayed_field in po_lookup_codes is traslatable string
1412: -- anagarwa Thu Oct 25 11:08:47 PDT 2001
1413:
1414: in_str :=
1415: 'select displayed_field ' ||

Line 1416: ' from po_lookup_codes ' ||

1412: -- anagarwa Thu Oct 25 11:08:47 PDT 2001
1413:
1414: in_str :=
1415: 'select displayed_field ' ||
1416: ' from po_lookup_codes ' ||
1417: ' where lookup_type = ''ERT RESULTS ACTION''' ||
1418: ' and lookup_code = ''REJECT''';
1419: /*
1420: in_str :=

Line 2176: l_result_column po_lookup_codes.displayed_field%type;

2172: TYPE insp_cur IS REF CURSOR;
2173: insp_acc insp_cur;
2174: insp_rej insp_cur;
2175:
2176: l_result_column po_lookup_codes.displayed_field%type;
2177:
2178: l_occurrence NUMBER;
2179: l_org_id NUMBER;
2180: l_item_id NUMBER;

Line 2220: ' from po_lookup_codes' ||

2216: -- the results entered in Inspection Plan in qa_results.
2217:
2218: in_str_reject :=
2219: ' select displayed_field' ||
2220: ' from po_lookup_codes' ||
2221: ' where lookup_type = ''ERT RESULTS ACTION''' ||
2222: ' and lookup_code = ''REJECT''';
2223:
2224:

Line 2227: ' from po_lookup_codes ' ||

2223:
2224:
2225: in_str_accept :=
2226: ' select displayed_field' ||
2227: ' from po_lookup_codes ' ||
2228: ' where lookup_type = ''ERT RESULTS ACTION''' ||
2229: ' and lookup_code = ''ACCEPT''';
2230:
2231: