eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_AM_TERMNT_INTERFACE_PVT dependencies on FND_LOOKUPS

Line 126: /* gets the meaning for each quote_type_code from FND_LOOKUPS*/

122: SELECT name
123: FROM hr_operating_units
124: WHERE organization_id = l_org_id;
125:
126: /* gets the meaning for each quote_type_code from FND_LOOKUPS*/
127: CURSOR get_quote_type_meaning_csr(p_quote_type IN VARCHAR2) IS
128: SELECT meaning
129: FROM FND_LOOKUPS
130: WHERE lookup_code = p_quote_type AND lookup_type = 'OKL_QUOTE_TYPE' AND enabled_flag = 'Y';

Line 129: FROM FND_LOOKUPS

125:
126: /* gets the meaning for each quote_type_code from FND_LOOKUPS*/
127: CURSOR get_quote_type_meaning_csr(p_quote_type IN VARCHAR2) IS
128: SELECT meaning
129: FROM FND_LOOKUPS
130: WHERE lookup_code = p_quote_type AND lookup_type = 'OKL_QUOTE_TYPE' AND enabled_flag = 'Y';
131:
132: /* gets the meaning for each quote_reason from FND_LOOKUPS*/
133: CURSOR get_quote_reason_meaning_csr(p_quote_reason IN VARCHAR2) IS

Line 132: /* gets the meaning for each quote_reason from FND_LOOKUPS*/

128: SELECT meaning
129: FROM FND_LOOKUPS
130: WHERE lookup_code = p_quote_type AND lookup_type = 'OKL_QUOTE_TYPE' AND enabled_flag = 'Y';
131:
132: /* gets the meaning for each quote_reason from FND_LOOKUPS*/
133: CURSOR get_quote_reason_meaning_csr(p_quote_reason IN VARCHAR2) IS
134: SELECT meaning
135: FROM FND_LOOKUPS
136: WHERE lookup_code = p_quote_reason AND lookup_type = 'OKL_QUOTE_REASON' AND enabled_flag = 'Y';

Line 135: FROM FND_LOOKUPS

131:
132: /* gets the meaning for each quote_reason from FND_LOOKUPS*/
133: CURSOR get_quote_reason_meaning_csr(p_quote_reason IN VARCHAR2) IS
134: SELECT meaning
135: FROM FND_LOOKUPS
136: WHERE lookup_code = p_quote_reason AND lookup_type = 'OKL_QUOTE_REASON' AND enabled_flag = 'Y';
137:
138: BEGIN
139: -- transactions which are not processed due to errors will be inserted in to val_msg_tbl

Line 496: /* validates each quote_type in INTERFACE table against FND_LOOKUPS*/

492: SELECT DISTINCT(quote_type_code) quote_type
493: FROM OKL_TERMNT_INTERFACE
494: WHERE status = 'ENTERED' AND quote_type_code IS NOT NULL;
495:
496: /* validates each quote_type in INTERFACE table against FND_LOOKUPS*/
497: CURSOR validate_quote_type_csr(p_quote_type IN VARCHAR2) IS
498: SELECT COUNT(lookup_code) code
499: FROM FND_LOOKUPS
500: WHERE lookup_code = p_quote_type AND lookup_type = 'OKL_QUOTE_TYPE' AND enabled_flag = 'Y';

Line 499: FROM FND_LOOKUPS

495:
496: /* validates each quote_type in INTERFACE table against FND_LOOKUPS*/
497: CURSOR validate_quote_type_csr(p_quote_type IN VARCHAR2) IS
498: SELECT COUNT(lookup_code) code
499: FROM FND_LOOKUPS
500: WHERE lookup_code = p_quote_type AND lookup_type = 'OKL_QUOTE_TYPE' AND enabled_flag = 'Y';
501:
502: /* cursor retrives the distinct quote_reason from INTERFACE TABLE*/
503: CURSOR get_quote_reason_csr IS

Line 508: /* validates each quote_reason in INTERFACE table against FND_LOOKUPS*/

504: SELECT DISTINCT(quote_reason_code) quote_reason
505: FROM OKL_TERMNT_INTERFACE
506: WHERE status = 'ENTERED' AND quote_reason_code IS NOT NULL;
507:
508: /* validates each quote_reason in INTERFACE table against FND_LOOKUPS*/
509: CURSOR validate_quote_reason_csr(p_quote_reason IN VARCHAR2) IS
510: SELECT COUNT(lookup_code) code
511: FROM FND_LOOKUPS
512: WHERE lookup_code = p_quote_reason AND lookup_type = 'OKL_QUOTE_REASON' AND enabled_flag = 'Y';

Line 511: FROM FND_LOOKUPS

507:
508: /* validates each quote_reason in INTERFACE table against FND_LOOKUPS*/
509: CURSOR validate_quote_reason_csr(p_quote_reason IN VARCHAR2) IS
510: SELECT COUNT(lookup_code) code
511: FROM FND_LOOKUPS
512: WHERE lookup_code = p_quote_reason AND lookup_type = 'OKL_QUOTE_REASON' AND enabled_flag = 'Y';
513:
514: l_quote_type VARCHAR2(20) :='';
515: l_quote_reason VARCHAR2(30) :='';

Line 535: /* validates each quote_type in INTERFACE table against FND_LOOKUPS*/

531: FOR term_rec IN get_quote_type_csr
532: LOOP
533: l_quote_type := term_rec.quote_type;
534: l_code := 0;
535: /* validates each quote_type in INTERFACE table against FND_LOOKUPS*/
536: FOR check_type IN validate_quote_type_csr(p_quote_type => l_quote_type)
537: LOOP
538: l_code := check_type.code;
539: END LOOP;

Line 540: /* if quote_type not exists in FND_LOOKUPS then ERROR out corresponding columns */

536: FOR check_type IN validate_quote_type_csr(p_quote_type => l_quote_type)
537: LOOP
538: l_code := check_type.code;
539: END LOOP;
540: /* if quote_type not exists in FND_LOOKUPS then ERROR out corresponding columns */
541: IF(l_code = 0)THEN
542: IF(lp_tif_tbl.COUNT>0) THEN
543: /*loops through the interface table records */
544: FOR record_number IN lp_tif_tbl.FIRST..lp_tif_tbl.LAST

Line 614: /* validates each quote_reason in INTERFACE table against FND_LOOKUPS*/

610: FOR term_rec IN get_quote_reason_csr
611: LOOP
612: l_quote_reason := term_rec.quote_reason;
613: l_code := 0;
614: /* validates each quote_reason in INTERFACE table against FND_LOOKUPS*/
615: FOR check_reason IN validate_quote_reason_csr(p_quote_reason => l_quote_reason)
616: LOOP
617: l_code := check_reason.code;
618: END LOOP;

Line 619: /* if quote_reason not exists in FND_LOOKUPS then ERROR out corresponding columns */

615: FOR check_reason IN validate_quote_reason_csr(p_quote_reason => l_quote_reason)
616: LOOP
617: l_code := check_reason.code;
618: END LOOP;
619: /* if quote_reason not exists in FND_LOOKUPS then ERROR out corresponding columns */
620: IF(l_code = 0)THEN
621: IF(lp_tif_tbl.COUNT>0) THEN
622: /*loops through the interface table records */
623: FOR record_number IN lp_tif_tbl.FIRST..lp_tif_tbl.LAST