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

Line 576: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

572:
573: l_freight_rec ASO_QUOTE_PUB.shipment_rec_type;
574: lx_freight_shipment_id ASO_SHIPMENTS.shipment_id%TYPE;
575:
576: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
577: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
578:
579:
580: BEGIN

Line 577: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

573: l_freight_rec ASO_QUOTE_PUB.shipment_rec_type;
574: lx_freight_shipment_id ASO_SHIPMENTS.shipment_id%TYPE;
575:
576: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
577: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
578:
579:
580: BEGIN
581:

Line 1052: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

1048: l_payment_rec ASO_QUOTE_PUB.payment_rec_type;
1049: lx_payment_id ASO_PAYMENTS.payment_id%TYPE;
1050: l_payment_id NUMBER;
1051: l_req_payment_term_id NUMBER;
1052: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
1053: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
1054:
1055: CURSOR c_line_pyt_exists (p_quote_line_id NUMBER) IS
1056: SELECT payment_id

Line 1053: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

1049: lx_payment_id ASO_PAYMENTS.payment_id%TYPE;
1050: l_payment_id NUMBER;
1051: l_req_payment_term_id NUMBER;
1052: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
1053: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
1054:
1055: CURSOR c_line_pyt_exists (p_quote_line_id NUMBER) IS
1056: SELECT payment_id
1057: FROM ASO_PAYMENTS

Line 9275: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

9271: l_api_version_number CONSTANT NUMBER := 1.0;
9272: l_line_shipping_charge number := 0;
9273: l_hdr_shipping_charge number := 0;
9274: l_message_text VARCHAR2(2000);
9275: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
9276: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
9277: l_last_update_date Date := SYSDATE;
9278: l BINARY_INTEGER;
9279: l_total_list_price NUMBER;

Line 9276: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

9272: l_line_shipping_charge number := 0;
9273: l_hdr_shipping_charge number := 0;
9274: l_message_text VARCHAR2(2000);
9275: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
9276: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
9277: l_last_update_date Date := SYSDATE;
9278: l BINARY_INTEGER;
9279: l_total_list_price NUMBER;
9280: l_ln_total_discount NUMBER;

Line 9609: ,fnd_global.user_id

9605: )(
9606: SELECT
9607: nvl(ldets_v.PRICE_ADJUSTMENT_ID,ASO_PRICE_ADJUSTMENTS_S.nextval),
9608: sysdate
9609: ,fnd_global.user_id
9610: ,sysdate
9611: ,fnd_global.user_id
9612: ,fnd_global.login_id
9613: ,p_qte_header_rec.quote_header_id,

Line 9611: ,fnd_global.user_id

9607: nvl(ldets_v.PRICE_ADJUSTMENT_ID,ASO_PRICE_ADJUSTMENTS_S.nextval),
9608: sysdate
9609: ,fnd_global.user_id
9610: ,sysdate
9611: ,fnd_global.user_id
9612: ,fnd_global.login_id
9613: ,p_qte_header_rec.quote_header_id,
9614: decode(ldets_v.modifier_level_code,'ORDER',NULL,lines.line_id),
9615: ldets_v.list_header_id,

Line 9612: ,fnd_global.login_id

9608: sysdate
9609: ,fnd_global.user_id
9610: ,sysdate
9611: ,fnd_global.user_id
9612: ,fnd_global.login_id
9613: ,p_qte_header_rec.quote_header_id,
9614: decode(ldets_v.modifier_level_code,'ORDER',NULL,lines.line_id),
9615: ldets_v.list_header_id,
9616: ldets_v.list_line_id,

Line 9715: ,fnd_global.user_id

9711: rltd_price_adj_id
9712: )
9713: (SELECT ASO_PRICE_RELATIONSHIPS_S.nextval
9714: ,sysdate
9715: ,fnd_global.user_id
9716: ,sysdate
9717: ,fnd_global.user_id
9718: ,fnd_global.login_id
9719: ,adj.QUOTE_LINE_ID

Line 9717: ,fnd_global.user_id

9713: (SELECT ASO_PRICE_RELATIONSHIPS_S.nextval
9714: ,sysdate
9715: ,fnd_global.user_id
9716: ,sysdate
9717: ,fnd_global.user_id
9718: ,fnd_global.login_id
9719: ,adj.QUOTE_LINE_ID
9720: ,ADJ.PRICE_ADJUSTMENT_ID
9721: ,RADJ.PRICE_ADJUSTMENT_ID

Line 9718: ,fnd_global.login_id

9714: ,sysdate
9715: ,fnd_global.user_id
9716: ,sysdate
9717: ,fnd_global.user_id
9718: ,fnd_global.login_id
9719: ,adj.QUOTE_LINE_ID
9720: ,ADJ.PRICE_ADJUSTMENT_ID
9721: ,RADJ.PRICE_ADJUSTMENT_ID
9722: FROM

Line 9772: ,fnd_global.user_id

9768: flex_title)
9769: (SELECT /*+ ORDERED USE_NL(LINES LDETS QPLAT ADJ) INDEX(LINES) INDEX(LDETS) INDEX(QPLAT QP_PREQ_LINE_ATTRS_TMP_N3) */
9770: ASO_PRICE_ADJ_ATTRIBS_S.nextval,
9771: sysdate
9772: ,fnd_global.user_id
9773: ,sysdate
9774: ,fnd_global.user_id
9775: ,fnd_global.login_id
9776: ,ADJ.PRICE_ADJUSTMENT_ID

Line 9774: ,fnd_global.user_id

9770: ASO_PRICE_ADJ_ATTRIBS_S.nextval,
9771: sysdate
9772: ,fnd_global.user_id
9773: ,sysdate
9774: ,fnd_global.user_id
9775: ,fnd_global.login_id
9776: ,ADJ.PRICE_ADJUSTMENT_ID
9777: ,QPLAT.CONTEXT
9778: ,QPLAT.ATTRIBUTE

Line 9775: ,fnd_global.login_id

9771: sysdate
9772: ,fnd_global.user_id
9773: ,sysdate
9774: ,fnd_global.user_id
9775: ,fnd_global.login_id
9776: ,ADJ.PRICE_ADJUSTMENT_ID
9777: ,QPLAT.CONTEXT
9778: ,QPLAT.ATTRIBUTE
9779: ,nvl(QPLAT.SETUP_VALUE_FROM,QPLAT.VALUE_FROM)

Line 9823: ,fnd_global.user_id

9819: comparison_operator,
9820: flex_title)
9821: (SELECT /*+ ORDERED USE_NL(LINES LDETS QPLAT ADJ) INDEX(LINES) INDEX(LDETS) INDEX(QPLAT QP_PREQ_LINE_ATTRS_TMP_N3) */ ASO_PRICE_ADJ_ATTRIBS_S.nextval,
9822: sysdate
9823: ,fnd_global.user_id
9824: ,sysdate
9825: ,fnd_global.user_id
9826: ,fnd_global.login_id
9827: ,ADJ.PRICE_ADJUSTMENT_ID

Line 9825: ,fnd_global.user_id

9821: (SELECT /*+ ORDERED USE_NL(LINES LDETS QPLAT ADJ) INDEX(LINES) INDEX(LDETS) INDEX(QPLAT QP_PREQ_LINE_ATTRS_TMP_N3) */ ASO_PRICE_ADJ_ATTRIBS_S.nextval,
9822: sysdate
9823: ,fnd_global.user_id
9824: ,sysdate
9825: ,fnd_global.user_id
9826: ,fnd_global.login_id
9827: ,ADJ.PRICE_ADJUSTMENT_ID
9828: ,QPLAT.CONTEXT
9829: ,QPLAT.ATTRIBUTE

Line 9826: ,fnd_global.login_id

9822: sysdate
9823: ,fnd_global.user_id
9824: ,sysdate
9825: ,fnd_global.user_id
9826: ,fnd_global.login_id
9827: ,ADJ.PRICE_ADJUSTMENT_ID
9828: ,QPLAT.CONTEXT
9829: ,QPLAT.ATTRIBUTE
9830: ,nvl(QPLAT.SETUP_VALUE_FROM,QPLAT.VALUE_FROM)

Line 9927: ,fnd_global.user_id

9923: )(
9924: SELECT
9925: nvl(ldets_v.PRICE_ADJUSTMENT_ID,ASO_PRICE_ADJUSTMENTS_S.nextval),
9926: sysdate
9927: ,fnd_global.user_id
9928: ,sysdate
9929: ,fnd_global.user_id
9930: ,fnd_global.login_id
9931: ,p_qte_header_rec.quote_header_id,

Line 9929: ,fnd_global.user_id

9925: nvl(ldets_v.PRICE_ADJUSTMENT_ID,ASO_PRICE_ADJUSTMENTS_S.nextval),
9926: sysdate
9927: ,fnd_global.user_id
9928: ,sysdate
9929: ,fnd_global.user_id
9930: ,fnd_global.login_id
9931: ,p_qte_header_rec.quote_header_id,
9932: lines.line_id,
9933: ldets_v.list_header_id,

Line 9930: ,fnd_global.login_id

9926: sysdate
9927: ,fnd_global.user_id
9928: ,sysdate
9929: ,fnd_global.user_id
9930: ,fnd_global.login_id
9931: ,p_qte_header_rec.quote_header_id,
9932: lines.line_id,
9933: ldets_v.list_header_id,
9934: ldets_v.list_line_id,

Line 10035: ,fnd_global.user_id

10031: rltd_price_adj_id
10032: )
10033: (SELECT ASO_PRICE_RELATIONSHIPS_S.nextval
10034: ,sysdate
10035: ,fnd_global.user_id
10036: ,sysdate
10037: ,fnd_global.user_id
10038: ,fnd_global.login_id
10039: ,adj.QUOTE_LINE_ID

Line 10037: ,fnd_global.user_id

10033: (SELECT ASO_PRICE_RELATIONSHIPS_S.nextval
10034: ,sysdate
10035: ,fnd_global.user_id
10036: ,sysdate
10037: ,fnd_global.user_id
10038: ,fnd_global.login_id
10039: ,adj.QUOTE_LINE_ID
10040: ,ADJ.PRICE_ADJUSTMENT_ID
10041: ,RADJ.PRICE_ADJUSTMENT_ID

Line 10038: ,fnd_global.login_id

10034: ,sysdate
10035: ,fnd_global.user_id
10036: ,sysdate
10037: ,fnd_global.user_id
10038: ,fnd_global.login_id
10039: ,adj.QUOTE_LINE_ID
10040: ,ADJ.PRICE_ADJUSTMENT_ID
10041: ,RADJ.PRICE_ADJUSTMENT_ID
10042: FROM

Line 10090: ,fnd_global.user_id

10086: comparison_operator,
10087: flex_title)
10088: (SELECT /*+ ORDERED USE_NL(LINES LDETS QPLAT ADJ) INDEX(LINES) INDEX(LDETS) INDEX(QPLAT QP_PREQ_LINE_ATTRS_TMP_N3) */ ASO_PRICE_ADJ_ATTRIBS_S.nextval,
10089: sysdate
10090: ,fnd_global.user_id
10091: ,sysdate
10092: ,fnd_global.user_id
10093: ,fnd_global.login_id
10094: ,ADJ.PRICE_ADJUSTMENT_ID

Line 10092: ,fnd_global.user_id

10088: (SELECT /*+ ORDERED USE_NL(LINES LDETS QPLAT ADJ) INDEX(LINES) INDEX(LDETS) INDEX(QPLAT QP_PREQ_LINE_ATTRS_TMP_N3) */ ASO_PRICE_ADJ_ATTRIBS_S.nextval,
10089: sysdate
10090: ,fnd_global.user_id
10091: ,sysdate
10092: ,fnd_global.user_id
10093: ,fnd_global.login_id
10094: ,ADJ.PRICE_ADJUSTMENT_ID
10095: ,QPLAT.CONTEXT
10096: ,QPLAT.ATTRIBUTE

Line 10093: ,fnd_global.login_id

10089: sysdate
10090: ,fnd_global.user_id
10091: ,sysdate
10092: ,fnd_global.user_id
10093: ,fnd_global.login_id
10094: ,ADJ.PRICE_ADJUSTMENT_ID
10095: ,QPLAT.CONTEXT
10096: ,QPLAT.ATTRIBUTE
10097: ,nvl(QPLAT.SETUP_VALUE_FROM,QPLAT.VALUE_FROM)

Line 10182: fnd_global.user_id,

10178: )(
10179: SELECT
10180: nvl(ldets_v.PRICE_ADJUSTMENT_ID,ASO_PRICE_ADJUSTMENTS_S.nextval),
10181: sysdate,
10182: fnd_global.user_id,
10183: sysdate,
10184: fnd_global.user_id,
10185: fnd_global.login_id,
10186: p_qte_header_rec.quote_header_id,

Line 10184: fnd_global.user_id,

10180: nvl(ldets_v.PRICE_ADJUSTMENT_ID,ASO_PRICE_ADJUSTMENTS_S.nextval),
10181: sysdate,
10182: fnd_global.user_id,
10183: sysdate,
10184: fnd_global.user_id,
10185: fnd_global.login_id,
10186: p_qte_header_rec.quote_header_id,
10187: decode(ldets_v.modifier_level_code,'ORDER',NULL,lines.line_id),
10188: ldets_v.list_header_id,

Line 10185: fnd_global.login_id,

10181: sysdate,
10182: fnd_global.user_id,
10183: sysdate,
10184: fnd_global.user_id,
10185: fnd_global.login_id,
10186: p_qte_header_rec.quote_header_id,
10187: decode(ldets_v.modifier_level_code,'ORDER',NULL,lines.line_id),
10188: ldets_v.list_header_id,
10189: ldets_v.list_line_id,

Line 10256: ,fnd_global.user_id

10252: comparison_operator,
10253: flex_title)
10254: (SELECT /*+ ORDERED USE_NL(LINES LDETS QPLAT ADJ) INDEX(LINES) INDEX(LDETS) INDEX(QPLAT QP_PREQ_LINE_ATTRS_TMP_N3) */ ASO_PRICE_ADJ_ATTRIBS_S.nextval,
10255: sysdate
10256: ,fnd_global.user_id
10257: ,sysdate
10258: ,fnd_global.user_id
10259: ,fnd_global.login_id
10260: ,ADJ.PRICE_ADJUSTMENT_ID

Line 10258: ,fnd_global.user_id

10254: (SELECT /*+ ORDERED USE_NL(LINES LDETS QPLAT ADJ) INDEX(LINES) INDEX(LDETS) INDEX(QPLAT QP_PREQ_LINE_ATTRS_TMP_N3) */ ASO_PRICE_ADJ_ATTRIBS_S.nextval,
10255: sysdate
10256: ,fnd_global.user_id
10257: ,sysdate
10258: ,fnd_global.user_id
10259: ,fnd_global.login_id
10260: ,ADJ.PRICE_ADJUSTMENT_ID
10261: ,QPLAT.CONTEXT
10262: ,QPLAT.ATTRIBUTE

Line 10259: ,fnd_global.login_id

10255: sysdate
10256: ,fnd_global.user_id
10257: ,sysdate
10258: ,fnd_global.user_id
10259: ,fnd_global.login_id
10260: ,ADJ.PRICE_ADJUSTMENT_ID
10261: ,QPLAT.CONTEXT
10262: ,QPLAT.ATTRIBUTE
10263: ,nvl(QPLAT.SETUP_VALUE_FROM,QPLAT.VALUE_FROM)

Line 10348: ,fnd_global.user_id

10344: )(
10345: SELECT
10346: nvl(ldets_v.PRICE_ADJUSTMENT_ID,ASO_PRICE_ADJUSTMENTS_S.nextval),
10347: sysdate
10348: ,fnd_global.user_id
10349: ,sysdate
10350: ,fnd_global.user_id
10351: ,fnd_global.login_id
10352: ,p_qte_header_rec.quote_header_id,

Line 10350: ,fnd_global.user_id

10346: nvl(ldets_v.PRICE_ADJUSTMENT_ID,ASO_PRICE_ADJUSTMENTS_S.nextval),
10347: sysdate
10348: ,fnd_global.user_id
10349: ,sysdate
10350: ,fnd_global.user_id
10351: ,fnd_global.login_id
10352: ,p_qte_header_rec.quote_header_id,
10353: decode(ldets_v.modifier_level_code,'ORDER',NULL,lines.line_id),
10354: ldets_v.list_header_id,

Line 10351: ,fnd_global.login_id

10347: sysdate
10348: ,fnd_global.user_id
10349: ,sysdate
10350: ,fnd_global.user_id
10351: ,fnd_global.login_id
10352: ,p_qte_header_rec.quote_header_id,
10353: decode(ldets_v.modifier_level_code,'ORDER',NULL,lines.line_id),
10354: ldets_v.list_header_id,
10355: ldets_v.list_line_id,

Line 10517: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

10513: WHERE QUOTE_HEADER_ID = p_qte_header_rec.quote_header_id;
10514:
10515: l_api_name CONSTANT VARCHAR2(30) := 'Process_Charges';
10516: l_api_version_number CONSTANT NUMBER := 1.0;
10517: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
10518: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
10519: l_last_update_date Date := SYSDATE;
10520: l_line_shipping_charge NUMBER := 0;
10521: l_hdr_shipping_charge NUMBER := 0;

Line 10518: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

10514:
10515: l_api_name CONSTANT VARCHAR2(30) := 'Process_Charges';
10516: l_api_version_number CONSTANT NUMBER := 1.0;
10517: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
10518: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
10519: l_last_update_date Date := SYSDATE;
10520: l_line_shipping_charge NUMBER := 0;
10521: l_hdr_shipping_charge NUMBER := 0;
10522: l_total_list_price NUMBER;