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 561: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

557:
558: l_freight_rec ASO_QUOTE_PUB.shipment_rec_type;
559: lx_freight_shipment_id ASO_SHIPMENTS.shipment_id%TYPE;
560:
561: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
562: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
563:
564:
565: BEGIN

Line 562: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

558: l_freight_rec ASO_QUOTE_PUB.shipment_rec_type;
559: lx_freight_shipment_id ASO_SHIPMENTS.shipment_id%TYPE;
560:
561: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
562: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
563:
564:
565: BEGIN
566:

Line 1037: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

1033: l_payment_rec ASO_QUOTE_PUB.payment_rec_type;
1034: lx_payment_id ASO_PAYMENTS.payment_id%TYPE;
1035: l_payment_id NUMBER;
1036: l_req_payment_term_id NUMBER;
1037: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
1038: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
1039:
1040: CURSOR c_line_pyt_exists (p_quote_line_id NUMBER) IS
1041: SELECT payment_id

Line 1038: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

1034: lx_payment_id ASO_PAYMENTS.payment_id%TYPE;
1035: l_payment_id NUMBER;
1036: l_req_payment_term_id NUMBER;
1037: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
1038: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
1039:
1040: CURSOR c_line_pyt_exists (p_quote_line_id NUMBER) IS
1041: SELECT payment_id
1042: FROM ASO_PAYMENTS

Line 9259: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

9255: l_api_version_number CONSTANT NUMBER := 1.0;
9256: l_line_shipping_charge number := 0;
9257: l_hdr_shipping_charge number := 0;
9258: l_message_text VARCHAR2(2000);
9259: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
9260: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
9261: l_last_update_date Date := SYSDATE;
9262: l BINARY_INTEGER;
9263: l_total_list_price NUMBER;

Line 9260: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

9256: l_line_shipping_charge number := 0;
9257: l_hdr_shipping_charge number := 0;
9258: l_message_text VARCHAR2(2000);
9259: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
9260: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
9261: l_last_update_date Date := SYSDATE;
9262: l BINARY_INTEGER;
9263: l_total_list_price NUMBER;
9264: l_ln_total_discount NUMBER;

Line 9592: ,fnd_global.user_id

9588: )(
9589: SELECT
9590: nvl(ldets_v.PRICE_ADJUSTMENT_ID,ASO_PRICE_ADJUSTMENTS_S.nextval),
9591: sysdate
9592: ,fnd_global.user_id
9593: ,sysdate
9594: ,fnd_global.user_id
9595: ,fnd_global.login_id
9596: ,p_qte_header_rec.quote_header_id,

Line 9594: ,fnd_global.user_id

9590: nvl(ldets_v.PRICE_ADJUSTMENT_ID,ASO_PRICE_ADJUSTMENTS_S.nextval),
9591: sysdate
9592: ,fnd_global.user_id
9593: ,sysdate
9594: ,fnd_global.user_id
9595: ,fnd_global.login_id
9596: ,p_qte_header_rec.quote_header_id,
9597: decode(ldets_v.modifier_level_code,'ORDER',NULL,lines.line_id),
9598: ldets_v.list_header_id,

Line 9595: ,fnd_global.login_id

9591: sysdate
9592: ,fnd_global.user_id
9593: ,sysdate
9594: ,fnd_global.user_id
9595: ,fnd_global.login_id
9596: ,p_qte_header_rec.quote_header_id,
9597: decode(ldets_v.modifier_level_code,'ORDER',NULL,lines.line_id),
9598: ldets_v.list_header_id,
9599: ldets_v.list_line_id,

Line 9698: ,fnd_global.user_id

9694: rltd_price_adj_id
9695: )
9696: (SELECT ASO_PRICE_RELATIONSHIPS_S.nextval
9697: ,sysdate
9698: ,fnd_global.user_id
9699: ,sysdate
9700: ,fnd_global.user_id
9701: ,fnd_global.login_id
9702: ,adj.QUOTE_LINE_ID

Line 9700: ,fnd_global.user_id

9696: (SELECT ASO_PRICE_RELATIONSHIPS_S.nextval
9697: ,sysdate
9698: ,fnd_global.user_id
9699: ,sysdate
9700: ,fnd_global.user_id
9701: ,fnd_global.login_id
9702: ,adj.QUOTE_LINE_ID
9703: ,ADJ.PRICE_ADJUSTMENT_ID
9704: ,RADJ.PRICE_ADJUSTMENT_ID

Line 9701: ,fnd_global.login_id

9697: ,sysdate
9698: ,fnd_global.user_id
9699: ,sysdate
9700: ,fnd_global.user_id
9701: ,fnd_global.login_id
9702: ,adj.QUOTE_LINE_ID
9703: ,ADJ.PRICE_ADJUSTMENT_ID
9704: ,RADJ.PRICE_ADJUSTMENT_ID
9705: FROM

Line 9755: ,fnd_global.user_id

9751: flex_title)
9752: (SELECT /*+ ORDERED USE_NL(LINES LDETS QPLAT ADJ) INDEX(LINES) INDEX(LDETS) INDEX(QPLAT QP_PREQ_LINE_ATTRS_TMP_N3) */
9753: ASO_PRICE_ADJ_ATTRIBS_S.nextval,
9754: sysdate
9755: ,fnd_global.user_id
9756: ,sysdate
9757: ,fnd_global.user_id
9758: ,fnd_global.login_id
9759: ,ADJ.PRICE_ADJUSTMENT_ID

Line 9757: ,fnd_global.user_id

9753: ASO_PRICE_ADJ_ATTRIBS_S.nextval,
9754: sysdate
9755: ,fnd_global.user_id
9756: ,sysdate
9757: ,fnd_global.user_id
9758: ,fnd_global.login_id
9759: ,ADJ.PRICE_ADJUSTMENT_ID
9760: ,QPLAT.CONTEXT
9761: ,QPLAT.ATTRIBUTE

Line 9758: ,fnd_global.login_id

9754: sysdate
9755: ,fnd_global.user_id
9756: ,sysdate
9757: ,fnd_global.user_id
9758: ,fnd_global.login_id
9759: ,ADJ.PRICE_ADJUSTMENT_ID
9760: ,QPLAT.CONTEXT
9761: ,QPLAT.ATTRIBUTE
9762: ,nvl(QPLAT.SETUP_VALUE_FROM,QPLAT.VALUE_FROM)

Line 9806: ,fnd_global.user_id

9802: comparison_operator,
9803: flex_title)
9804: (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,
9805: sysdate
9806: ,fnd_global.user_id
9807: ,sysdate
9808: ,fnd_global.user_id
9809: ,fnd_global.login_id
9810: ,ADJ.PRICE_ADJUSTMENT_ID

Line 9808: ,fnd_global.user_id

9804: (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,
9805: sysdate
9806: ,fnd_global.user_id
9807: ,sysdate
9808: ,fnd_global.user_id
9809: ,fnd_global.login_id
9810: ,ADJ.PRICE_ADJUSTMENT_ID
9811: ,QPLAT.CONTEXT
9812: ,QPLAT.ATTRIBUTE

Line 9809: ,fnd_global.login_id

9805: sysdate
9806: ,fnd_global.user_id
9807: ,sysdate
9808: ,fnd_global.user_id
9809: ,fnd_global.login_id
9810: ,ADJ.PRICE_ADJUSTMENT_ID
9811: ,QPLAT.CONTEXT
9812: ,QPLAT.ATTRIBUTE
9813: ,nvl(QPLAT.SETUP_VALUE_FROM,QPLAT.VALUE_FROM)

Line 9910: ,fnd_global.user_id

9906: )(
9907: SELECT
9908: nvl(ldets_v.PRICE_ADJUSTMENT_ID,ASO_PRICE_ADJUSTMENTS_S.nextval),
9909: sysdate
9910: ,fnd_global.user_id
9911: ,sysdate
9912: ,fnd_global.user_id
9913: ,fnd_global.login_id
9914: ,p_qte_header_rec.quote_header_id,

Line 9912: ,fnd_global.user_id

9908: nvl(ldets_v.PRICE_ADJUSTMENT_ID,ASO_PRICE_ADJUSTMENTS_S.nextval),
9909: sysdate
9910: ,fnd_global.user_id
9911: ,sysdate
9912: ,fnd_global.user_id
9913: ,fnd_global.login_id
9914: ,p_qte_header_rec.quote_header_id,
9915: lines.line_id,
9916: ldets_v.list_header_id,

Line 9913: ,fnd_global.login_id

9909: sysdate
9910: ,fnd_global.user_id
9911: ,sysdate
9912: ,fnd_global.user_id
9913: ,fnd_global.login_id
9914: ,p_qte_header_rec.quote_header_id,
9915: lines.line_id,
9916: ldets_v.list_header_id,
9917: ldets_v.list_line_id,

Line 10018: ,fnd_global.user_id

10014: rltd_price_adj_id
10015: )
10016: (SELECT ASO_PRICE_RELATIONSHIPS_S.nextval
10017: ,sysdate
10018: ,fnd_global.user_id
10019: ,sysdate
10020: ,fnd_global.user_id
10021: ,fnd_global.login_id
10022: ,adj.QUOTE_LINE_ID

Line 10020: ,fnd_global.user_id

10016: (SELECT ASO_PRICE_RELATIONSHIPS_S.nextval
10017: ,sysdate
10018: ,fnd_global.user_id
10019: ,sysdate
10020: ,fnd_global.user_id
10021: ,fnd_global.login_id
10022: ,adj.QUOTE_LINE_ID
10023: ,ADJ.PRICE_ADJUSTMENT_ID
10024: ,RADJ.PRICE_ADJUSTMENT_ID

Line 10021: ,fnd_global.login_id

10017: ,sysdate
10018: ,fnd_global.user_id
10019: ,sysdate
10020: ,fnd_global.user_id
10021: ,fnd_global.login_id
10022: ,adj.QUOTE_LINE_ID
10023: ,ADJ.PRICE_ADJUSTMENT_ID
10024: ,RADJ.PRICE_ADJUSTMENT_ID
10025: FROM

Line 10073: ,fnd_global.user_id

10069: comparison_operator,
10070: flex_title)
10071: (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,
10072: sysdate
10073: ,fnd_global.user_id
10074: ,sysdate
10075: ,fnd_global.user_id
10076: ,fnd_global.login_id
10077: ,ADJ.PRICE_ADJUSTMENT_ID

Line 10075: ,fnd_global.user_id

10071: (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,
10072: sysdate
10073: ,fnd_global.user_id
10074: ,sysdate
10075: ,fnd_global.user_id
10076: ,fnd_global.login_id
10077: ,ADJ.PRICE_ADJUSTMENT_ID
10078: ,QPLAT.CONTEXT
10079: ,QPLAT.ATTRIBUTE

Line 10076: ,fnd_global.login_id

10072: sysdate
10073: ,fnd_global.user_id
10074: ,sysdate
10075: ,fnd_global.user_id
10076: ,fnd_global.login_id
10077: ,ADJ.PRICE_ADJUSTMENT_ID
10078: ,QPLAT.CONTEXT
10079: ,QPLAT.ATTRIBUTE
10080: ,nvl(QPLAT.SETUP_VALUE_FROM,QPLAT.VALUE_FROM)

Line 10165: fnd_global.user_id,

10161: )(
10162: SELECT
10163: nvl(ldets_v.PRICE_ADJUSTMENT_ID,ASO_PRICE_ADJUSTMENTS_S.nextval),
10164: sysdate,
10165: fnd_global.user_id,
10166: sysdate,
10167: fnd_global.user_id,
10168: fnd_global.login_id,
10169: p_qte_header_rec.quote_header_id,

Line 10167: fnd_global.user_id,

10163: nvl(ldets_v.PRICE_ADJUSTMENT_ID,ASO_PRICE_ADJUSTMENTS_S.nextval),
10164: sysdate,
10165: fnd_global.user_id,
10166: sysdate,
10167: fnd_global.user_id,
10168: fnd_global.login_id,
10169: p_qte_header_rec.quote_header_id,
10170: decode(ldets_v.modifier_level_code,'ORDER',NULL,lines.line_id),
10171: ldets_v.list_header_id,

Line 10168: fnd_global.login_id,

10164: sysdate,
10165: fnd_global.user_id,
10166: sysdate,
10167: fnd_global.user_id,
10168: fnd_global.login_id,
10169: p_qte_header_rec.quote_header_id,
10170: decode(ldets_v.modifier_level_code,'ORDER',NULL,lines.line_id),
10171: ldets_v.list_header_id,
10172: ldets_v.list_line_id,

Line 10239: ,fnd_global.user_id

10235: comparison_operator,
10236: flex_title)
10237: (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,
10238: sysdate
10239: ,fnd_global.user_id
10240: ,sysdate
10241: ,fnd_global.user_id
10242: ,fnd_global.login_id
10243: ,ADJ.PRICE_ADJUSTMENT_ID

Line 10241: ,fnd_global.user_id

10237: (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,
10238: sysdate
10239: ,fnd_global.user_id
10240: ,sysdate
10241: ,fnd_global.user_id
10242: ,fnd_global.login_id
10243: ,ADJ.PRICE_ADJUSTMENT_ID
10244: ,QPLAT.CONTEXT
10245: ,QPLAT.ATTRIBUTE

Line 10242: ,fnd_global.login_id

10238: sysdate
10239: ,fnd_global.user_id
10240: ,sysdate
10241: ,fnd_global.user_id
10242: ,fnd_global.login_id
10243: ,ADJ.PRICE_ADJUSTMENT_ID
10244: ,QPLAT.CONTEXT
10245: ,QPLAT.ATTRIBUTE
10246: ,nvl(QPLAT.SETUP_VALUE_FROM,QPLAT.VALUE_FROM)

Line 10331: ,fnd_global.user_id

10327: )(
10328: SELECT
10329: nvl(ldets_v.PRICE_ADJUSTMENT_ID,ASO_PRICE_ADJUSTMENTS_S.nextval),
10330: sysdate
10331: ,fnd_global.user_id
10332: ,sysdate
10333: ,fnd_global.user_id
10334: ,fnd_global.login_id
10335: ,p_qte_header_rec.quote_header_id,

Line 10333: ,fnd_global.user_id

10329: nvl(ldets_v.PRICE_ADJUSTMENT_ID,ASO_PRICE_ADJUSTMENTS_S.nextval),
10330: sysdate
10331: ,fnd_global.user_id
10332: ,sysdate
10333: ,fnd_global.user_id
10334: ,fnd_global.login_id
10335: ,p_qte_header_rec.quote_header_id,
10336: decode(ldets_v.modifier_level_code,'ORDER',NULL,lines.line_id),
10337: ldets_v.list_header_id,

Line 10334: ,fnd_global.login_id

10330: sysdate
10331: ,fnd_global.user_id
10332: ,sysdate
10333: ,fnd_global.user_id
10334: ,fnd_global.login_id
10335: ,p_qte_header_rec.quote_header_id,
10336: decode(ldets_v.modifier_level_code,'ORDER',NULL,lines.line_id),
10337: ldets_v.list_header_id,
10338: ldets_v.list_line_id,

Line 10500: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

10496: WHERE QUOTE_HEADER_ID = p_qte_header_rec.quote_header_id;
10497:
10498: l_api_name CONSTANT VARCHAR2(30) := 'Process_Charges';
10499: l_api_version_number CONSTANT NUMBER := 1.0;
10500: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
10501: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
10502: l_last_update_date Date := SYSDATE;
10503: l_line_shipping_charge NUMBER := 0;
10504: l_hdr_shipping_charge NUMBER := 0;

Line 10501: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

10497:
10498: l_api_name CONSTANT VARCHAR2(30) := 'Process_Charges';
10499: l_api_version_number CONSTANT NUMBER := 1.0;
10500: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
10501: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
10502: l_last_update_date Date := SYSDATE;
10503: l_line_shipping_charge NUMBER := 0;
10504: l_hdr_shipping_charge NUMBER := 0;
10505: l_total_list_price NUMBER;