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.QPR_DEAL_ETL dependencies on FND_GLOBAL

Line 121: FND_GLOBAL.USER_ID,

117: t_er_desc(i),
118: t_er_val(i),
119: t_tot_er(i),
120: SYSDATE,
121: FND_GLOBAL.USER_ID,
122: SYSDATE,
123: FND_GLOBAL.USER_ID,
124: FND_GLOBAL.CONC_LOGIN_ID);
125: t_line_id.delete;

Line 123: FND_GLOBAL.USER_ID,

119: t_tot_er(i),
120: SYSDATE,
121: FND_GLOBAL.USER_ID,
122: SYSDATE,
123: FND_GLOBAL.USER_ID,
124: FND_GLOBAL.CONC_LOGIN_ID);
125: t_line_id.delete;
126: t_er_typ.delete;
127: t_er_name.delete;

Line 124: FND_GLOBAL.CONC_LOGIN_ID);

120: SYSDATE,
121: FND_GLOBAL.USER_ID,
122: SYSDATE,
123: FND_GLOBAL.USER_ID,
124: FND_GLOBAL.CONC_LOGIN_ID);
125: t_line_id.delete;
126: t_er_typ.delete;
127: t_er_name.delete;
128: t_er_desc.delete;

Line 176: FND_GLOBAL.USER_ID,

172: t_er_desc(i),
173: t_er_val(i),
174: t_tot_er(i),
175: SYSDATE,
176: FND_GLOBAL.USER_ID,
177: SYSDATE,
178: FND_GLOBAL.USER_ID,
179: FND_GLOBAL.CONC_LOGIN_ID);
180: log_debug('Inserted ' || sql%rowcount || ' adjustment rows in qpr_pn_pr_details');

Line 178: FND_GLOBAL.USER_ID,

174: t_tot_er(i),
175: SYSDATE,
176: FND_GLOBAL.USER_ID,
177: SYSDATE,
178: FND_GLOBAL.USER_ID,
179: FND_GLOBAL.CONC_LOGIN_ID);
180: log_debug('Inserted ' || sql%rowcount || ' adjustment rows in qpr_pn_pr_details');
181:
182: t_er_typ.delete;

Line 179: FND_GLOBAL.CONC_LOGIN_ID);

175: SYSDATE,
176: FND_GLOBAL.USER_ID,
177: SYSDATE,
178: FND_GLOBAL.USER_ID,
179: FND_GLOBAL.CONC_LOGIN_ID);
180: log_debug('Inserted ' || sql%rowcount || ' adjustment rows in qpr_pn_pr_details');
181:
182: t_er_typ.delete;
183: t_er_name.delete;

Line 261: FND_GLOBAL.USER_ID,

257: r_hdr_pric.unit_price,
258: r_hdr_pric.amount,
259: r_hdr_pric.percent_price,
260: SYSDATE,
261: FND_GLOBAL.USER_ID,
262: SYSDATE,
263: FND_GLOBAL.USER_ID,
264: FND_GLOBAL.CONC_LOGIN_ID);
265: end loop;

Line 263: FND_GLOBAL.USER_ID,

259: r_hdr_pric.percent_price,
260: SYSDATE,
261: FND_GLOBAL.USER_ID,
262: SYSDATE,
263: FND_GLOBAL.USER_ID,
264: FND_GLOBAL.CONC_LOGIN_ID);
265: end loop;
266: else
267: for r_pr_types in c_price_types loop

Line 264: FND_GLOBAL.CONC_LOGIN_ID);

260: SYSDATE,
261: FND_GLOBAL.USER_ID,
262: SYSDATE,
263: FND_GLOBAL.USER_ID,
264: FND_GLOBAL.CONC_LOGIN_ID);
265: end loop;
266: else
267: for r_pr_types in c_price_types loop
268: if r_pr_types.column_name is not null then

Line 342: FND_GLOBAL.USER_ID,

338: p_pn_line_id,
339: r_pr_types.pn_pr_type_id,
340: l_price, l_amount,l_price_perc,
341: SYSDATE,
342: FND_GLOBAL.USER_ID,
343: SYSDATE,
344: FND_GLOBAL.USER_ID,
345: FND_GLOBAL.CONC_LOGIN_ID);
346: log_debug('Inserted Price Type = ' || r_pr_types.pn_pr_type_id

Line 344: FND_GLOBAL.USER_ID,

340: l_price, l_amount,l_price_perc,
341: SYSDATE,
342: FND_GLOBAL.USER_ID,
343: SYSDATE,
344: FND_GLOBAL.USER_ID,
345: FND_GLOBAL.CONC_LOGIN_ID);
346: log_debug('Inserted Price Type = ' || r_pr_types.pn_pr_type_id
347: || ' ;Unit Price = ' || l_price);
348: end loop;

Line 345: FND_GLOBAL.CONC_LOGIN_ID);

341: SYSDATE,
342: FND_GLOBAL.USER_ID,
343: SYSDATE,
344: FND_GLOBAL.USER_ID,
345: FND_GLOBAL.CONC_LOGIN_ID);
346: log_debug('Inserted Price Type = ' || r_pr_types.pn_pr_type_id
347: || ' ;Unit Price = ' || l_price);
348: end loop;
349: end if;

Line 476: FND_GLOBAL.USER_ID,

472: rec_pn_pol_ins.policy_line_id(i),
473: rec_pn_pol_ins.policy_price(i),
474: rec_pn_pol_ins.policy_amount(i),
475: sysdate,
476: FND_GLOBAL.USER_ID,
477: SYSDATE,
478: FND_GLOBAL.USER_ID,
479: FND_GLOBAL.CONC_LOGIN_ID);
480: log_debug('Inserted ' || sql%rowcount || ' policy records');

Line 478: FND_GLOBAL.USER_ID,

474: rec_pn_pol_ins.policy_amount(i),
475: sysdate,
476: FND_GLOBAL.USER_ID,
477: SYSDATE,
478: FND_GLOBAL.USER_ID,
479: FND_GLOBAL.CONC_LOGIN_ID);
480: log_debug('Inserted ' || sql%rowcount || ' policy records');
481: end if;
482: exception

Line 479: FND_GLOBAL.CONC_LOGIN_ID);

475: sysdate,
476: FND_GLOBAL.USER_ID,
477: SYSDATE,
478: FND_GLOBAL.USER_ID,
479: FND_GLOBAL.CONC_LOGIN_ID);
480: log_debug('Inserted ' || sql%rowcount || ' policy records');
481: end if;
482: exception
483: when others then

Line 867: FND_GLOBAL.USER_ID,

863: c_int_header_rec.INVOICE_TO_PARTY_SITE_ADDRESS,
864: p_simulation,
865: c_int_header_rec.COMMENTS,
866: SYSDATE,
867: FND_GLOBAL.USER_ID,
868: SYSDATE,
869: FND_GLOBAL.USER_ID,
870: FND_GLOBAL.CONC_LOGIN_ID
871: ) returning REQUEST_HEADER_ID into l_request_id;

Line 869: FND_GLOBAL.USER_ID,

865: c_int_header_rec.COMMENTS,
866: SYSDATE,
867: FND_GLOBAL.USER_ID,
868: SYSDATE,
869: FND_GLOBAL.USER_ID,
870: FND_GLOBAL.CONC_LOGIN_ID
871: ) returning REQUEST_HEADER_ID into l_request_id;
872:
873: l_reference_name :=

Line 870: FND_GLOBAL.CONC_LOGIN_ID

866: SYSDATE,
867: FND_GLOBAL.USER_ID,
868: SYSDATE,
869: FND_GLOBAL.USER_ID,
870: FND_GLOBAL.CONC_LOGIN_ID
871: ) returning REQUEST_HEADER_ID into l_request_id;
872:
873: l_reference_name :=
874: substr(nvl(c_int_header_rec.source_short_desc||': '||

Line 894: FND_GLOBAL.USER_ID,

890: select L.LANGUAGE_CODE ,l_request_id,
891: l_reference_name,
892: userenv('LANG'),
893: SYSDATE,
894: FND_GLOBAL.USER_ID,
895: SYSDATE,
896: FND_GLOBAL.USER_ID,
897: FND_GLOBAL.CONC_LOGIN_ID
898: from FND_LANGUAGES L

Line 896: FND_GLOBAL.USER_ID,

892: userenv('LANG'),
893: SYSDATE,
894: FND_GLOBAL.USER_ID,
895: SYSDATE,
896: FND_GLOBAL.USER_ID,
897: FND_GLOBAL.CONC_LOGIN_ID
898: from FND_LANGUAGES L
899: where L.INSTALLED_FLAG in ('I', 'B');
900:

Line 897: FND_GLOBAL.CONC_LOGIN_ID

893: SYSDATE,
894: FND_GLOBAL.USER_ID,
895: SYSDATE,
896: FND_GLOBAL.USER_ID,
897: FND_GLOBAL.CONC_LOGIN_ID
898: from FND_LANGUAGES L
899: where L.INSTALLED_FLAG in ('I', 'B');
900:
901: log_debug('Inserted Request header TL values');

Line 923: l_request_id, fnd_global.user_id,

919: LAST_UPDATED_BY,
920: LAST_UPDATE_LOGIN
921: ) values
922: (qpr_pn_response_hdrs_s.nextval,
923: l_request_id, fnd_global.user_id,
924: null,
925: 'APPROVE_REQ',
926: null,
927: fnd_global.user_id,

Line 927: fnd_global.user_id,

923: l_request_id, fnd_global.user_id,
924: null,
925: 'APPROVE_REQ',
926: null,
927: fnd_global.user_id,
928: sysdate,
929: null,
930: 1,
931: 'N',

Line 933: FND_GLOBAL.USER_ID,

929: null,
930: 1,
931: 'N',
932: SYSDATE,
933: FND_GLOBAL.USER_ID,
934: SYSDATE,
935: FND_GLOBAL.USER_ID,
936: FND_GLOBAL.CONC_LOGIN_ID)
937: returning RESPONSE_HEADER_ID into l_response_id;

Line 935: FND_GLOBAL.USER_ID,

931: 'N',
932: SYSDATE,
933: FND_GLOBAL.USER_ID,
934: SYSDATE,
935: FND_GLOBAL.USER_ID,
936: FND_GLOBAL.CONC_LOGIN_ID)
937: returning RESPONSE_HEADER_ID into l_response_id;
938:
939: log_debug('Inserted Response Id: '||l_response_id);

Line 936: FND_GLOBAL.CONC_LOGIN_ID)

932: SYSDATE,
933: FND_GLOBAL.USER_ID,
934: SYSDATE,
935: FND_GLOBAL.USER_ID,
936: FND_GLOBAL.CONC_LOGIN_ID)
937: returning RESPONSE_HEADER_ID into l_response_id;
938:
939: log_debug('Inserted Response Id: '||l_response_id);
940:

Line 1054: FND_GLOBAL.USER_ID,

1050: 'PR_SEGMENT_L_' || int_lines_rec.pr_segment_id, null),
1051: int_lines_rec.PAYMENT_TERM_ID,
1052: int_lines_rec.SHIP_METHOD_CODE,
1053: SYSDATE,
1054: FND_GLOBAL.USER_ID,
1055: SYSDATE,
1056: FND_GLOBAL.USER_ID,
1057: FND_GLOBAL.CONC_LOGIN_ID)
1058: returning PN_LINE_ID into l_line_id;

Line 1056: FND_GLOBAL.USER_ID,

1052: int_lines_rec.SHIP_METHOD_CODE,
1053: SYSDATE,
1054: FND_GLOBAL.USER_ID,
1055: SYSDATE,
1056: FND_GLOBAL.USER_ID,
1057: FND_GLOBAL.CONC_LOGIN_ID)
1058: returning PN_LINE_ID into l_line_id;
1059: log_debug('Inserted rolled up model' || l_line_id);
1060: end if;

Line 1057: FND_GLOBAL.CONC_LOGIN_ID)

1053: SYSDATE,
1054: FND_GLOBAL.USER_ID,
1055: SYSDATE,
1056: FND_GLOBAL.USER_ID,
1057: FND_GLOBAL.CONC_LOGIN_ID)
1058: returning PN_LINE_ID into l_line_id;
1059: log_debug('Inserted rolled up model' || l_line_id);
1060: end if;
1061:

Line 1216: FND_GLOBAL.USER_ID,

1212: 'PR_SEGMENT_L_' || int_lines_rec.pr_segment_id, null),
1213: int_lines_rec.PAYMENT_TERM_ID,
1214: int_lines_rec.SHIP_METHOD_CODE,
1215: SYSDATE,
1216: FND_GLOBAL.USER_ID,
1217: SYSDATE,
1218: FND_GLOBAL.USER_ID,
1219: FND_GLOBAL.CONC_LOGIN_ID)
1220: returning PN_LINE_ID into l_line_id;

Line 1218: FND_GLOBAL.USER_ID,

1214: int_lines_rec.SHIP_METHOD_CODE,
1215: SYSDATE,
1216: FND_GLOBAL.USER_ID,
1217: SYSDATE,
1218: FND_GLOBAL.USER_ID,
1219: FND_GLOBAL.CONC_LOGIN_ID)
1220: returning PN_LINE_ID into l_line_id;
1221:
1222: log_debug('Inserted line: pn_line_id = ' || l_line_id);

Line 1219: FND_GLOBAL.CONC_LOGIN_ID)

1215: SYSDATE,
1216: FND_GLOBAL.USER_ID,
1217: SYSDATE,
1218: FND_GLOBAL.USER_ID,
1219: FND_GLOBAL.CONC_LOGIN_ID)
1220: returning PN_LINE_ID into l_line_id;
1221:
1222: log_debug('Inserted line: pn_line_id = ' || l_line_id);
1223:

Line 1289: fnd_global.user_id,

1285: where response_header_id = l_response_id;
1286:
1287: log_debug('Check compliance and fetch approvers if needed...');
1288: qpr_deal_approvals_pvt.init_approvals(l_response_id,
1289: fnd_global.user_id,
1290: p_is_deal_compliant,
1291: l_return_status);
1292: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1293: retcode := 2;

Line 1429: FND_GLOBAL.USER_ID,

1425: 'QPR_WHATIF',
1426: l_er_name,
1427: 0, 0,
1428: SYSDATE,
1429: FND_GLOBAL.USER_ID,
1430: SYSDATE,
1431: FND_GLOBAL.USER_ID,
1432: FND_GLOBAL.CONC_LOGIN_ID);
1433:

Line 1431: FND_GLOBAL.USER_ID,

1427: 0, 0,
1428: SYSDATE,
1429: FND_GLOBAL.USER_ID,
1430: SYSDATE,
1431: FND_GLOBAL.USER_ID,
1432: FND_GLOBAL.CONC_LOGIN_ID);
1433:
1434: log_debug('Inserted oninvoice modifier QPR_WHATIF for use in whatif');
1435:

Line 1432: FND_GLOBAL.CONC_LOGIN_ID);

1428: SYSDATE,
1429: FND_GLOBAL.USER_ID,
1430: SYSDATE,
1431: FND_GLOBAL.USER_ID,
1432: FND_GLOBAL.CONC_LOGIN_ID);
1433:
1434: log_debug('Inserted oninvoice modifier QPR_WHATIF for use in whatif');
1435:
1436: -- Insert offinvoice modifiers ----

Line 1477: FND_GLOBAL.USER_ID,

1473: t_er_desc(i),
1474: t_er_val(i),
1475: t_tot_er(i),
1476: SYSDATE,
1477: FND_GLOBAL.USER_ID,
1478: SYSDATE,
1479: FND_GLOBAL.USER_ID,
1480: FND_GLOBAL.CONC_LOGIN_ID);
1481: for i in t_er_name.first..t_er_name.last loop

Line 1479: FND_GLOBAL.USER_ID,

1475: t_tot_er(i),
1476: SYSDATE,
1477: FND_GLOBAL.USER_ID,
1478: SYSDATE,
1479: FND_GLOBAL.USER_ID,
1480: FND_GLOBAL.CONC_LOGIN_ID);
1481: for i in t_er_name.first..t_er_name.last loop
1482: log_debug('Inserted Offinvoice modifier ' || t_er_name(i)
1483: || ': Erosion per unit=' || t_er_val(i));

Line 1480: FND_GLOBAL.CONC_LOGIN_ID);

1476: SYSDATE,
1477: FND_GLOBAL.USER_ID,
1478: SYSDATE,
1479: FND_GLOBAL.USER_ID,
1480: FND_GLOBAL.CONC_LOGIN_ID);
1481: for i in t_er_name.first..t_er_name.last loop
1482: log_debug('Inserted Offinvoice modifier ' || t_er_name(i)
1483: || ': Erosion per unit=' || t_er_val(i));
1484: end loop;

Line 1803: l_request_id := fnd_global.conc_request_id;

1799:
1800: begin
1801: log_debug('Starting..');
1802:
1803: l_request_id := fnd_global.conc_request_id;
1804:
1805: update qpr_pn_int_headers rih
1806: set rih.request_id = l_request_id
1807: where rih.source_ref_header_id between

Line 2110: fnd_global.user_id,

2106: l_request_hdr_id,
2107: l_hdr_score,
2108: l_response_stat,
2109: p_response_hdr_id,
2110: fnd_global.user_id,
2111: sysdate,
2112: fnd_global.user_id,
2113: SYSDATE,
2114: FND_GLOBAL.USER_ID,

Line 2112: fnd_global.user_id,

2108: l_response_stat,
2109: p_response_hdr_id,
2110: fnd_global.user_id,
2111: sysdate,
2112: fnd_global.user_id,
2113: SYSDATE,
2114: FND_GLOBAL.USER_ID,
2115: SYSDATE,
2116: FND_GLOBAL.USER_ID,

Line 2114: FND_GLOBAL.USER_ID,

2110: fnd_global.user_id,
2111: sysdate,
2112: fnd_global.user_id,
2113: SYSDATE,
2114: FND_GLOBAL.USER_ID,
2115: SYSDATE,
2116: FND_GLOBAL.USER_ID,
2117: FND_GLOBAL.CONC_LOGIN_ID,
2118: l_comments,

Line 2116: FND_GLOBAL.USER_ID,

2112: fnd_global.user_id,
2113: SYSDATE,
2114: FND_GLOBAL.USER_ID,
2115: SYSDATE,
2116: FND_GLOBAL.USER_ID,
2117: FND_GLOBAL.CONC_LOGIN_ID,
2118: l_comments,
2119: l_description,
2120: l_version_no + 1,

Line 2117: FND_GLOBAL.CONC_LOGIN_ID,

2113: SYSDATE,
2114: FND_GLOBAL.USER_ID,
2115: SYSDATE,
2116: FND_GLOBAL.USER_ID,
2117: FND_GLOBAL.CONC_LOGIN_ID,
2118: l_comments,
2119: l_description,
2120: l_version_no + 1,
2121: 'N')

Line 2230: FND_GLOBAL.USER_ID,

2226: lines_rec.LINE_PRICING_SCORE,
2227: lines_rec.ORIG_PAYMENT_TERM_ID,
2228: lines_rec.ORIG_SHIP_METHOD_CODE,
2229: SYSDATE,
2230: FND_GLOBAL.USER_ID,
2231: SYSDATE,
2232: FND_GLOBAL.USER_ID,
2233: FND_GLOBAL.CONC_LOGIN_ID);
2234: end loop;

Line 2232: FND_GLOBAL.USER_ID,

2228: lines_rec.ORIG_SHIP_METHOD_CODE,
2229: SYSDATE,
2230: FND_GLOBAL.USER_ID,
2231: SYSDATE,
2232: FND_GLOBAL.USER_ID,
2233: FND_GLOBAL.CONC_LOGIN_ID);
2234: end loop;
2235:
2236: open c_pn_pr_det(l_response_id);

Line 2233: FND_GLOBAL.CONC_LOGIN_ID);

2229: SYSDATE,
2230: FND_GLOBAL.USER_ID,
2231: SYSDATE,
2232: FND_GLOBAL.USER_ID,
2233: FND_GLOBAL.CONC_LOGIN_ID);
2234: end loop;
2235:
2236: open c_pn_pr_det(l_response_id);
2237: loop

Line 2265: FND_GLOBAL.USER_ID,

2261: t_er_desc(i),
2262: t_unit_val(i),
2263: t_amnt(i),
2264: SYSDATE,
2265: FND_GLOBAL.USER_ID,
2266: SYSDATE,
2267: FND_GLOBAL.USER_ID,
2268: FND_GLOBAL.CONC_LOGIN_ID);
2269: t_line_id.delete;

Line 2267: FND_GLOBAL.USER_ID,

2263: t_amnt(i),
2264: SYSDATE,
2265: FND_GLOBAL.USER_ID,
2266: SYSDATE,
2267: FND_GLOBAL.USER_ID,
2268: FND_GLOBAL.CONC_LOGIN_ID);
2269: t_line_id.delete;
2270: t_er_type.delete;
2271: t_er_name.delete;

Line 2268: FND_GLOBAL.CONC_LOGIN_ID);

2264: SYSDATE,
2265: FND_GLOBAL.USER_ID,
2266: SYSDATE,
2267: FND_GLOBAL.USER_ID,
2268: FND_GLOBAL.CONC_LOGIN_ID);
2269: t_line_id.delete;
2270: t_er_type.delete;
2271: t_er_name.delete;
2272: t_er_desc.delete;

Line 2304: FND_GLOBAL.USER_ID,

2300: t_line_id(i),
2301: t_pr_typ_id(i),
2302: t_unit_val(i), t_amnt(i), t_percent(i),
2303: SYSDATE,
2304: FND_GLOBAL.USER_ID,
2305: SYSDATE,
2306: FND_GLOBAL.USER_ID,
2307: FND_GLOBAL.CONC_LOGIN_ID);
2308: t_line_id.delete;

Line 2306: FND_GLOBAL.USER_ID,

2302: t_unit_val(i), t_amnt(i), t_percent(i),
2303: SYSDATE,
2304: FND_GLOBAL.USER_ID,
2305: SYSDATE,
2306: FND_GLOBAL.USER_ID,
2307: FND_GLOBAL.CONC_LOGIN_ID);
2308: t_line_id.delete;
2309: t_unit_val.delete;
2310: t_amnt.delete;

Line 2307: FND_GLOBAL.CONC_LOGIN_ID);

2303: SYSDATE,
2304: FND_GLOBAL.USER_ID,
2305: SYSDATE,
2306: FND_GLOBAL.USER_ID,
2307: FND_GLOBAL.CONC_LOGIN_ID);
2308: t_line_id.delete;
2309: t_unit_val.delete;
2310: t_amnt.delete;
2311: t_percent.delete;

Line 2341: FND_GLOBAL.USER_ID,

2337: t_unit_val(i),
2338: t_amnt(i),
2339: t_pol_line_id(i),
2340: sysdate,
2341: FND_GLOBAL.USER_ID,
2342: SYSDATE,
2343: FND_GLOBAL.USER_ID,
2344: FND_GLOBAL.CONC_LOGIN_ID);
2345: t_pr_typ_id.delete;

Line 2343: FND_GLOBAL.USER_ID,

2339: t_pol_line_id(i),
2340: sysdate,
2341: FND_GLOBAL.USER_ID,
2342: SYSDATE,
2343: FND_GLOBAL.USER_ID,
2344: FND_GLOBAL.CONC_LOGIN_ID);
2345: t_pr_typ_id.delete;
2346: t_pol_id.delete;
2347: t_pol_line_id.delete;

Line 2344: FND_GLOBAL.CONC_LOGIN_ID);

2340: sysdate,
2341: FND_GLOBAL.USER_ID,
2342: SYSDATE,
2343: FND_GLOBAL.USER_ID,
2344: FND_GLOBAL.CONC_LOGIN_ID);
2345: t_pr_typ_id.delete;
2346: t_pol_id.delete;
2347: t_pol_line_id.delete;
2348: t_unit_val.delete;