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.PON_OPEN_INTERFACE_PVT dependencies on DUAL

Line 442: FROM dual

438: pon_auc_interface_table_pkg.validate_header_attributes_api(NULL,batchId,-1);
439: BEGIN
440: SELECT 'N' status
441: INTO l_status
442: FROM dual
443: WHERE EXISTS
444: (SELECT * FROM pon_interface_errors WHERE BATCH_ID=batchId
445: );
446: EXCEPTION

Line 1011: FROM dual;

1007: SELECT To_Number(NVL(p_attr_score_rec.l_from_range,0)),
1008: To_Number(NVL(p_attr_score_rec.l_to_range,0))
1009: INTO l_from_range_num,
1010: l_to_range_num
1011: FROM dual;
1012: EXCEPTION
1013: WHEN OTHERS THEN
1014: print_log('Invalid number value');
1015: l_status:='N';

Line 1064: FROM dual

1060: IF(l_from_range_num IS NOT NULL AND l_to_range_num IS NOT NULL AND t_from_range_num IS NOT NULL AND t_to_range_num IS NOT NULL ) THEN
1061: BEGIN
1062: SELECT 'N'
1063: INTO l_status
1064: FROM dual
1065: WHERE (l_from_range_num BETWEEN t_from_range_num AND t_to_range_num)
1066: OR (l_to_range_num BETWEEN t_from_range_num AND t_to_range_num);
1067: EXCEPTION
1068: WHEN No_Data_Found THEN

Line 1088: FROM dual;

1084: SELECT To_date(NVL(p_attr_score_rec.l_from_range,sysdate),'dd-mm-yyyy'),
1085: To_date(NVL(p_attr_score_rec.l_to_range,sysdate),'dd-mm-yyyy')
1086: INTO l_from_range_dat,
1087: l_to_range_dat
1088: FROM dual;
1089: EXCEPTION
1090: WHEN OTHERS THEN
1091: print_log('Invalid date value');
1092: l_status:='N';

Line 1140: FROM dual

1136: IF(l_from_range_dat IS NOT NULL AND l_to_range_dat IS NOT NULL AND t_from_range_dat IS NOT NULL AND t_to_range_dat IS NOT NULL ) THEN
1137: BEGIN
1138: SELECT 'N'
1139: INTO l_status
1140: FROM dual
1141: WHERE (l_from_range_dat BETWEEN t_from_range_dat AND t_to_range_dat)
1142: OR (l_to_range_dat BETWEEN t_from_range_dat AND t_to_range_dat);
1143: EXCEPTION
1144: WHEN No_Data_Found THEN

Line 1628: FROM dual

1624:
1625: BEGIN
1626: SELECT 'E' status
1627: INTO x_return_status
1628: FROM dual
1629: WHERE EXISTS
1630: (SELECT * FROM pon_interface_errors WHERE BATCH_ID= p_batch_Id
1631: );
1632: EXCEPTION

Line 2286: --SELECT fnd_global.user_id INTO g_user_id FROM dual;

2282: l_price_break_response ,
2283: l_price_tiers_indicator
2284: FROM pon_auction_headers_all
2285: WHERE auction_header_id = p_auction_header_id;
2286: --SELECT fnd_global.user_id INTO g_user_id FROM dual;
2287: SELECT fnd_global.login_id,
2288: fnd_global.CURRENT_LANGUAGE
2289: INTO g_login_id,
2290: g_curr_lang

Line 2291: FROM dual;

2287: SELECT fnd_global.login_id,
2288: fnd_global.CURRENT_LANGUAGE
2289: INTO g_login_id,
2290: g_curr_lang
2291: FROM dual;
2292:
2293: g_user_id := fnd_global.user_id;
2294: /*select fnd_currency.GET_INFO(l_currency_code,l_precision,l_ext_precision,l_minAcctUnit)
2295: INTO l_price_precision FROM dual;*/

Line 2295: INTO l_price_precision FROM dual;*/

2291: FROM dual;
2292:
2293: g_user_id := fnd_global.user_id;
2294: /*select fnd_currency.GET_INFO(l_currency_code,l_precision,l_ext_precision,l_minAcctUnit)
2295: INTO l_price_precision FROM dual;*/
2296: fnd_currency.GET_INFO(l_currency_code,l_precision,l_ext_precision,l_minAcctUnit);
2297: print_log('create_lines_with_children: before calling line_level_validation');
2298:
2299:

Line 2318: FROM dual

2314: print_log('create_lines_with_children validations complete ');
2315: BEGIN
2316: SELECT 'N' status
2317: INTO l_status
2318: FROM dual
2319: WHERE EXISTS
2320: (SELECT * FROM pon_interface_errors WHERE BATCH_ID= p_batch_Id
2321: );
2322: EXCEPTION

Line 2480: FROM dual

2476: );
2477: BEGIN
2478: SELECT 'N' status
2479: INTO l_status
2480: FROM dual
2481: WHERE EXISTS
2482: (SELECT * FROM pon_interface_errors WHERE BATCH_ID=p_batch_Id
2483: );
2484: EXCEPTION

Line 2575: FROM dual

2571: );
2572: BEGIN
2573: SELECT 'N' status
2574: INTO l_status
2575: FROM dual
2576: WHERE EXISTS
2577: (SELECT * FROM pon_interface_errors WHERE BATCH_ID=p_batch_Id
2578: );
2579: EXCEPTION

Line 4043: FROM dual

4039:
4040: BEGIN
4041: SELECT 'E' status
4042: INTO x_return_status
4043: FROM dual
4044: WHERE EXISTS
4045: (SELECT * FROM pon_interface_errors WHERE BATCH_ID= p_batch_Id
4046: );
4047: EXCEPTION

Line 5185: SELECT 1 FROM dual;

5181: l_cp_user_id,
5182: SYSDATE,
5183: l_cp_login_id
5184: )
5185: SELECT 1 FROM dual;
5186: --l_val_err := 'Y';
5187: --END IF;
5188:
5189: BEGIN

Line 5192: FROM dual

5188:
5189: BEGIN
5190: SELECT 'E' status
5191: INTO x_return_status
5192: FROM dual
5193: WHERE EXISTS
5194: (SELECT * FROM pon_interface_errors WHERE BATCH_ID= p_batch_Id
5195: );
5196: EXCEPTION

Line 5256: FROM dual

5252:
5253: BEGIN
5254: SELECT 'E' status
5255: INTO x_return_status
5256: FROM dual
5257: WHERE EXISTS
5258: (SELECT * FROM pon_interface_errors WHERE BATCH_ID= p_batch_Id
5259: );
5260: EXCEPTION

Line 5317: FROM dual

5313: END IF;
5314:
5315: BEGIN
5316: SELECT 'Y' INTO approval_required_flag
5317: FROM dual
5318: WHERE
5319: EXISTS(SELECT 1 FROM pon_neg_team_members
5320: WHERE auctioN_header_id = neg_header_record_data.auction_header_id
5321: and approver_flag = 'Y');

Line 5415: INTO l_is_complex FROM dual;

5411: END IF;
5412:
5413:
5414: select DECODE(NVL(neg_header_record_data.progress_payment_type,'NONE'),'NONE','N','Y')
5415: INTO l_is_complex FROM dual;
5416:
5417: -- Below call populates columns and the possible values
5418: populate_column_test_table(
5419: neg_header_record_data.contract_type,

Line 5929: SELECT 1 from dual;

5925: l_cp_user_id,
5926: SYSDATE,
5927: l_cp_login_id)
5928:
5929: SELECT 1 from dual;
5930:
5931: IF(PON_CLM_UTIL_PKG.IS_DOCUMENT_FEDERAL(neg_header_record_data.doctype_id)=1) THEN
5932:
5933: IF ( p_is_amendment <> 'Y' AND

Line 6268: SELECT neg_header_record_data.org_id FROM dual ;

6264: SYSDATE,
6265: l_cp_user_id,
6266: SYSDATE,
6267: l_cp_login_id)
6268: SELECT neg_header_record_data.org_id FROM dual ;
6269:
6270: print_Log('validate_header completed ');
6271:
6272: EXCEPTION

Line 6312: SELECT pon_auction_headers_all_s.NEXTVAL INTO neg_header_record_data.auction_header_id FROM dual;

6308: print_log('populate_neg_header_rec begin ');
6309:
6310: -- For amendment neg_header_record_data.auction_header_id will not be used
6311: IF ( p_is_amendment <> 'Y' ) THEN
6312: SELECT pon_auction_headers_all_s.NEXTVAL INTO neg_header_record_data.auction_header_id FROM dual;
6313: END IF;
6314:
6315: SELECT person_party_id,user_name
6316: INTO neg_header_record_data.trading_partner_contact_id,neg_header_record_data.trading_partner_contact_name

Line 7242: FROM dual

7238:
7239: BEGIN
7240: SELECT 'E' status
7241: INTO x_return_status
7242: FROM dual
7243: WHERE EXISTS
7244: (SELECT * FROM pon_interface_errors WHERE BATCH_ID= p_batch_Id
7245: );
7246: EXCEPTION

Line 7711: SELECT 1 INTO dummy FROM dual

7707: WHERE batch_id = p_batch_id;
7708:
7709: BEGIN
7710:
7711: SELECT 1 INTO dummy FROM dual
7712: WHERE NOT EXISTS (SELECT interface_line_id FROM pon_item_prices_interface
7713: WHERE batch_id = p_batch_id AND interface_line_id = 1);
7714:
7715: INSERT INTO PON_INTERFACE_ERRORS