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 137: /* gets the meaning for each quote_type_code from FND_LOOKUPS*/

133: SELECT name
134: FROM hr_operating_units
135: WHERE organization_id = l_org_id;
136:
137: /* gets the meaning for each quote_type_code from FND_LOOKUPS*/
138: CURSOR get_quote_type_meaning_csr(p_quote_type IN VARCHAR2) IS
139: SELECT meaning
140: FROM FND_LOOKUPS
141: WHERE lookup_code = p_quote_type AND lookup_type = 'OKL_QUOTE_TYPE' AND enabled_flag = 'Y';

Line 140: FROM FND_LOOKUPS

136:
137: /* gets the meaning for each quote_type_code from FND_LOOKUPS*/
138: CURSOR get_quote_type_meaning_csr(p_quote_type IN VARCHAR2) IS
139: SELECT meaning
140: FROM FND_LOOKUPS
141: WHERE lookup_code = p_quote_type AND lookup_type = 'OKL_QUOTE_TYPE' AND enabled_flag = 'Y';
142:
143: /* gets the meaning for each quote_reason from FND_LOOKUPS*/
144: CURSOR get_quote_reason_meaning_csr(p_quote_reason IN VARCHAR2) IS

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

139: SELECT meaning
140: FROM FND_LOOKUPS
141: WHERE lookup_code = p_quote_type AND lookup_type = 'OKL_QUOTE_TYPE' AND enabled_flag = 'Y';
142:
143: /* gets the meaning for each quote_reason from FND_LOOKUPS*/
144: CURSOR get_quote_reason_meaning_csr(p_quote_reason IN VARCHAR2) IS
145: SELECT meaning
146: FROM FND_LOOKUPS
147: WHERE lookup_code = p_quote_reason AND lookup_type = 'OKL_QUOTE_REASON' AND enabled_flag = 'Y';

Line 146: FROM FND_LOOKUPS

142:
143: /* gets the meaning for each quote_reason from FND_LOOKUPS*/
144: CURSOR get_quote_reason_meaning_csr(p_quote_reason IN VARCHAR2) IS
145: SELECT meaning
146: FROM FND_LOOKUPS
147: WHERE lookup_code = p_quote_reason AND lookup_type = 'OKL_QUOTE_REASON' AND enabled_flag = 'Y';
148:
149: BEGIN
150: -- transactions which are not processed due to errors will be inserted in to val_msg_tbl

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

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

Line 511: FROM FND_LOOKUPS

507:
508: /* validates each quote_type in INTERFACE table against FND_LOOKUPS*/
509: CURSOR validate_quote_type_csr(p_quote_type IN VARCHAR2) IS
510: SELECT COUNT(lookup_code) code
511: FROM FND_LOOKUPS
512: WHERE lookup_code = p_quote_type AND lookup_type = 'OKL_QUOTE_TYPE' AND enabled_flag = 'Y';
513:
514: /* cursor retrives the distinct quote_reason from INTERFACE TABLE*/
515: CURSOR get_quote_reason_csr IS

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

516: SELECT DISTINCT(quote_reason_code) quote_reason
517: FROM OKL_TERMNT_INTERFACE
518: WHERE status = 'ENTERED' AND quote_reason_code IS NOT NULL;
519:
520: /* validates each quote_reason in INTERFACE table against FND_LOOKUPS*/
521: CURSOR validate_quote_reason_csr(p_quote_reason IN VARCHAR2) IS
522: SELECT COUNT(lookup_code) code
523: FROM FND_LOOKUPS
524: WHERE lookup_code = p_quote_reason AND lookup_type = 'OKL_QUOTE_REASON' AND enabled_flag = 'Y';

Line 523: FROM FND_LOOKUPS

519:
520: /* validates each quote_reason in INTERFACE table against FND_LOOKUPS*/
521: CURSOR validate_quote_reason_csr(p_quote_reason IN VARCHAR2) IS
522: SELECT COUNT(lookup_code) code
523: FROM FND_LOOKUPS
524: WHERE lookup_code = p_quote_reason AND lookup_type = 'OKL_QUOTE_REASON' AND enabled_flag = 'Y';
525:
526: l_quote_type VARCHAR2(20) :='';
527: l_quote_reason VARCHAR2(30) :='';

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

558: FOR term_rec IN get_quote_type_csr
559: LOOP
560: l_quote_type := term_rec.quote_type;
561: l_code := 0;
562: /* validates each quote_type in INTERFACE table against FND_LOOKUPS*/
563: FOR check_type IN validate_quote_type_csr(p_quote_type => l_quote_type)
564: LOOP
565: l_code := check_type.code;
566: END LOOP;

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

563: FOR check_type IN validate_quote_type_csr(p_quote_type => l_quote_type)
564: LOOP
565: l_code := check_type.code;
566: END LOOP;
567: /* if quote_type not exists in FND_LOOKUPS then ERROR out corresponding columns */
568: IF(l_code = 0)THEN
569: IF(lp_tif_tbl.COUNT>0) THEN
570: /*loops through the interface table records */
571: FOR record_number IN lp_tif_tbl.FIRST..lp_tif_tbl.LAST

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

637: FOR term_rec IN get_quote_reason_csr
638: LOOP
639: l_quote_reason := term_rec.quote_reason;
640: l_code := 0;
641: /* validates each quote_reason in INTERFACE table against FND_LOOKUPS*/
642: FOR check_reason IN validate_quote_reason_csr(p_quote_reason => l_quote_reason)
643: LOOP
644: l_code := check_reason.code;
645: END LOOP;

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

642: FOR check_reason IN validate_quote_reason_csr(p_quote_reason => l_quote_reason)
643: LOOP
644: l_code := check_reason.code;
645: END LOOP;
646: /* if quote_reason not exists in FND_LOOKUPS then ERROR out corresponding columns */
647: IF(l_code = 0)THEN
648: IF(lp_tif_tbl.COUNT>0) THEN
649: /*loops through the interface table records */
650: FOR record_number IN lp_tif_tbl.FIRST..lp_tif_tbl.LAST