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 ASO_PRICE_ADJUSTMENTS

Line 6588: UPDATE ASO_PRICE_ADJUSTMENTS apa

6584: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
6585: aso_debug_pub.add('ASO_PRICING_CORE_PVT: Inside of the Query_Price_Adj_All',1,'Y');
6586: END IF;
6587:
6588: UPDATE ASO_PRICE_ADJUSTMENTS apa
6589: SET OPERAND_PER_PQTY = (SELECT decode(arithmetic_operator,'%',operand,
6590: 'LUMPSUM',operand,
6591: 'AMT',(operand*l.quantity)/l.PRICING_QUANTITY,
6592: 'NEWPRICE',(operand*l.quantity)/l.PRICING_QUANTITY)

Line 6605: UPDATE ASO_PRICE_ADJUSTMENTS

6601: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Operand per pqty updated rows - Line level: '||sql%ROWCOUNT,1,'Y');
6602: END IF;
6603:
6604: --Only support % at the header level
6605: UPDATE ASO_PRICE_ADJUSTMENTS
6606: SET OPERAND_PER_PQTY = operand
6607: WHERE quote_header_id = p_quote_header_id
6608: AND quote_line_id is null
6609: AND (applied_flag = 'Y' OR updated_flag = 'Y');

Line 6729: FROM ASO_PRICE_ADJUSTMENTS adj

6725: G_LDET_UPDATED_FLAG_TBL,
6726: G_LDET_CALC_CODE_TBL,
6727: G_LDET_CHG_REASON_CODE_TBL,
6728: G_LDET_CHG_REASON_TEXT_TBL
6729: FROM ASO_PRICE_ADJUSTMENTS adj
6730: WHERE adj.QUOTE_HEADER_ID = p_quote_header_id
6731: AND (NVL(adj.updated_flag,'N') = 'Y' OR nvl(adj.automatic_flag,'N') = 'Y');
6732:
6733: x_adj_id_tbl := l_adj_id_tbl;

Line 6752: UPDATE ASO_PRICE_ADJUSTMENTS

6748: aso_debug_pub.add('ASO_PRICING_CORE_PVT: Start of Query_Price_Adj_Header',1,'Y');
6749: END IF;
6750:
6751: --Only support % at the header level
6752: UPDATE ASO_PRICE_ADJUSTMENTS
6753: SET OPERAND_PER_PQTY = operand
6754: WHERE quote_header_id = p_quote_header_id
6755: AND quote_line_id is null
6756: AND (applied_flag = 'Y' OR updated_flag = 'Y');

Line 6874: FROM ASO_PRICE_ADJUSTMENTS adj

6870: G_LDET_UPDATED_FLAG_TBL,
6871: G_LDET_CALC_CODE_TBL,
6872: G_LDET_CHG_REASON_CODE_TBL,
6873: G_LDET_CHG_REASON_TEXT_TBL
6874: FROM ASO_PRICE_ADJUSTMENTS adj
6875: WHERE adj.QUOTE_HEADER_ID = p_quote_header_id
6876: AND adj.QUOTE_LINE_ID IS NULL
6877: AND NVL(ASO_PRICING_INT.G_HEADER_REC.RECALCULATE_FLAG,'N') = 'N'
6878: AND NVL(updated_flag,'N') = 'Y';

Line 6898: UPDATE ASO_PRICE_ADJUSTMENTS apa

6894: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
6895: aso_debug_pub.add('ASO_PRICING_CORE_PVT: Start of the Query_Price_Adj_line',1,'Y');
6896: END IF;
6897:
6898: UPDATE ASO_PRICE_ADJUSTMENTS apa
6899: SET OPERAND_PER_PQTY = (SELECT decode(arithmetic_operator,'%',operand,
6900: 'LUMPSUM',operand,
6901: 'AMT',(operand*l.quantity)/l.PRICING_QUANTITY,
6902: 'NEWPRICE',(operand*l.quantity)/l.PRICING_QUANTITY)

Line 7037: FROM ASO_PRICE_ADJUSTMENTS adj,

7033: G_LDET_UPDATED_FLAG_TBL,
7034: G_LDET_CALC_CODE_TBL,
7035: G_LDET_CHG_REASON_CODE_TBL,
7036: G_LDET_CHG_REASON_TEXT_TBL
7037: FROM ASO_PRICE_ADJUSTMENTS adj,
7038: TABLE (CAST(P_Qte_Line_id_tbl AS JTF_NUMBER_TABLE)) Lines
7039: WHERE adj.QUOTE_HEADER_ID = p_quote_header_id
7040: AND adj.QUOTE_LINE_ID = Lines.column_value
7041: AND adj.QUOTE_LINE_ID IS NOT NULL

Line 7047: FROM ASO_PRICE_ADJUSTMENTS adj2,

7043:
7044: --We won't need this since in the second implicit call the only Adj record for free line
7045: --is the PRG related DIS record.
7046: /*AND EXISTS ( SELECT null
7047: FROM ASO_PRICE_ADJUSTMENTS adj2,
7048: ASO_PRICE_ADJ_RELATIONSHIPS rlt
7049: WHERE rlt.rltd_price_adj_id = adj.price_adjustment_id
7050: AND adj2.modifier_line_type_code = 'PRG'
7051: AND adj2.quote_header_id = adj.quote_header_id

Line 7076: UPDATE ASO_PRICE_ADJUSTMENTS apa

7072: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
7073: aso_debug_pub.add('ASO_PRICING_CORE_PVT: Start of the Query_Price_Adjustments',1,'Y');
7074: END IF;
7075:
7076: UPDATE ASO_PRICE_ADJUSTMENTS apa
7077: SET OPERAND_PER_PQTY = (SELECT decode(arithmetic_operator,'%',operand,
7078: 'LUMPSUM',operand,
7079: 'AMT',(operand*l.quantity)/l.PRICING_QUANTITY,
7080: 'NEWPRICE',(operand*l.quantity)/l.PRICING_QUANTITY)

Line 7093: UPDATE ASO_PRICE_ADJUSTMENTS

7089: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Operand per pqty updated rows - Line level: '||sql%ROWCOUNT,1,'Y');
7090: END IF;
7091:
7092: --Only support % at the header level
7093: UPDATE ASO_PRICE_ADJUSTMENTS
7094: SET OPERAND_PER_PQTY = operand
7095: WHERE quote_header_id = p_quote_header_id
7096: AND quote_line_id is null
7097: AND (applied_flag = 'Y' OR updated_flag = 'Y');

Line 7223: FROM ASO_PRICE_ADJUSTMENTS adj

7219: G_LDET_UPDATED_FLAG_TBL,
7220: G_LDET_CALC_CODE_TBL,
7221: G_LDET_CHG_REASON_CODE_TBL,
7222: G_LDET_CHG_REASON_TEXT_TBL
7223: FROM ASO_PRICE_ADJUSTMENTS adj
7224: WHERE adj.QUOTE_HEADER_ID = p_quote_header_id
7225: AND NVL(adj.updated_flag,'N') = 'Y'
7226: AND adj.QUOTE_LINE_ID IS NULL
7227: AND NVL(ASO_PRICING_INT.G_HEADER_REC.RECALCULATE_FLAG,'N') = 'N'

Line 7286: FROM ASO_PRICE_ADJUSTMENTS adj,

7282: UPDATED_FLAG,
7283: MODIFIER_MECHANISM_TYPE_CODE,
7284: CHANGE_REASON_CODE,
7285: CHANGE_REASON_TEXT
7286: FROM ASO_PRICE_ADJUSTMENTS adj,
7287: TABLE (CAST(P_Qte_Line_id_tbl AS JTF_NUMBER_TABLE)) Lines
7288: WHERE adj.QUOTE_HEADER_ID = p_quote_header_id
7289: AND adj.QUOTE_LINE_ID = Lines.column_value
7290: AND adj.QUOTE_LINE_ID IS NOT NULL

Line 7298: ( adj.modifier_line_type_code = 'DIS' and exists ( select null from aso_price_adjustments adj2,

7294: AND nvl(lines2.RECALCULATE_FLAG,'N') = 'N' )
7295: AND NVL(ASO_PRICING_INT.G_HEADER_REC.RECALCULATE_FLAG,'N') = 'N')
7296: OR ( adj.modifier_line_type_code = 'PRG'
7297: OR
7298: ( adj.modifier_line_type_code = 'DIS' and exists ( select null from aso_price_adjustments adj2,
7299: aso_price_adj_relationships rlt
7300: where rlt.rltd_price_adj_id = adj.price_adjustment_id
7301: and adj2.modifier_line_type_code = 'PRG'
7302: and adj2.quote_header_id = adj.quote_header_id

Line 7339: ASO_PRICE_ADJUSTMENTS dbadj,

7335: G_RLTD_RELATED_LINE_IND_TBL,
7336: G_RLTD_LST_LN_ID_DEF_TBL,
7337: G_RLTD_RLTD_LST_LN_ID_DEF_TBL
7338: FROM ASO_PRICE_ADJ_RELATIONSHIPS adj_rel,
7339: ASO_PRICE_ADJUSTMENTS dbadj,
7340: ASO_PRICE_ADJUSTMENTS dbadjrel,
7341: TABLE (CAST(p_qte_adj_id_tbl AS JTF_NUMBER_TABLE)) adj
7342: WHERE dbadj.quote_header_id = ASO_PRICING_INT.G_HEADER_REC.quote_header_id
7343: AND dbadjrel.quote_header_id = ASO_PRICING_INT.G_HEADER_REC.quote_header_id

Line 7340: ASO_PRICE_ADJUSTMENTS dbadjrel,

7336: G_RLTD_LST_LN_ID_DEF_TBL,
7337: G_RLTD_RLTD_LST_LN_ID_DEF_TBL
7338: FROM ASO_PRICE_ADJ_RELATIONSHIPS adj_rel,
7339: ASO_PRICE_ADJUSTMENTS dbadj,
7340: ASO_PRICE_ADJUSTMENTS dbadjrel,
7341: TABLE (CAST(p_qte_adj_id_tbl AS JTF_NUMBER_TABLE)) adj
7342: WHERE dbadj.quote_header_id = ASO_PRICING_INT.G_HEADER_REC.quote_header_id
7343: AND dbadjrel.quote_header_id = ASO_PRICING_INT.G_HEADER_REC.quote_header_id
7344: AND adj_rel.price_adjustment_id = adj.column_value

Line 7415: ASO_PRICE_ADJUSTMENTS dbadj,

7411: G_RLTD_RELATED_LINE_IND_TBL,
7412: G_RLTD_LST_LN_ID_DEF_TBL,
7413: G_RLTD_RLTD_LST_LN_ID_DEF_TBL
7414: FROM ASO_PRICE_ADJ_RELATIONSHIPS adj_rel,
7415: ASO_PRICE_ADJUSTMENTS dbadj,
7416: ASO_PRICE_ADJUSTMENTS dbadjrel,
7417: TABLE (CAST(p_qte_adj_id_tbl AS JTF_NUMBER_TABLE)) adj
7418: WHERE dbadj.quote_header_id = ASO_PRICING_INT.G_HEADER_REC.quote_header_id
7419: AND dbadjrel.quote_header_id = ASO_PRICING_INT.G_HEADER_REC.quote_header_id

Line 7416: ASO_PRICE_ADJUSTMENTS dbadjrel,

7412: G_RLTD_LST_LN_ID_DEF_TBL,
7413: G_RLTD_RLTD_LST_LN_ID_DEF_TBL
7414: FROM ASO_PRICE_ADJ_RELATIONSHIPS adj_rel,
7415: ASO_PRICE_ADJUSTMENTS dbadj,
7416: ASO_PRICE_ADJUSTMENTS dbadjrel,
7417: TABLE (CAST(p_qte_adj_id_tbl AS JTF_NUMBER_TABLE)) adj
7418: WHERE dbadj.quote_header_id = ASO_PRICING_INT.G_HEADER_REC.quote_header_id
7419: AND dbadjrel.quote_header_id = ASO_PRICING_INT.G_HEADER_REC.quote_header_id
7420: AND adj_rel.price_adjustment_id = adj.column_value

Line 8960: FROM aso_price_adjustments

8956:
8957:
8958: CURSOR C_get_adj_id_HdrH(l_quote_header_id NUMBER,l_price_attribute1 VARCHAR2) IS
8959: SELECT price_adjustment_id
8960: FROM aso_price_adjustments
8961: WHERE quote_header_id = l_quote_header_id
8962: AND quote_line_id is null
8963: AND modifier_header_id = to_number(l_price_attribute1);
8964:

Line 8967: FROM aso_price_adjustments

8963: AND modifier_header_id = to_number(l_price_attribute1);
8964:
8965: CURSOR C_get_adj_id_HdrL(l_quote_header_id NUMBER,l_price_attribute2 VARCHAR2) IS
8966: SELECT price_adjustment_id
8967: FROM aso_price_adjustments
8968: WHERE Quote_header_id = l_quote_header_id
8969: AND quote_line_id is null
8970: AND modifier_line_id = to_number(l_price_attribute2);
8971:

Line 8974: FROM aso_price_adjustments

8970: AND modifier_line_id = to_number(l_price_attribute2);
8971:
8972: CURSOR C_get_adj_id_LnH(l_quote_header_id NUMBER,l_quote_line_id NUMBER,l_price_attribute1 VARCHAR2) IS
8973: SELECT price_adjustment_id
8974: FROM aso_price_adjustments
8975: WHERE Quote_header_id = l_quote_header_id
8976: AND Quote_line_id = l_quote_line_id
8977: AND modifier_header_id = to_number(l_price_attribute1);
8978:

Line 8981: FROM aso_price_adjustments

8977: AND modifier_header_id = to_number(l_price_attribute1);
8978:
8979: CURSOR C_get_adj_id_LnL(l_quote_header_id NUMBER,l_quote_line_id NUMBER,l_price_attribute2 VARCHAR2)IS
8980: SELECT price_adjustment_id
8981: FROM aso_price_adjustments
8982: WHERE Quote_header_id = l_quote_header_id
8983: AND Quote_line_id = l_quote_line_id
8984: AND modifier_line_id = to_number(l_price_attribute2);
8985:

Line 9092: ASO_PRICE_ADJUSTMENTS_PKG.Delete_Row(p_PRICE_ADJ_ID => l_price_adjustment_id);

9088: p_price_attr_tbl(i).pricing_attribute1);
9089: FETCH C_get_adj_id_HdrH INTO l_price_adjustment_id;
9090:
9091: While C_get_adj_id_HdrH%found LOOP
9092: ASO_PRICE_ADJUSTMENTS_PKG.Delete_Row(p_PRICE_ADJ_ID => l_price_adjustment_id);
9093: FETCH C_get_adj_id_HdrH INTO l_price_adjustment_id;
9094: End Loop;
9095: CLOSE C_get_adj_id_HdrH;
9096:

Line 9114: ASO_PRICE_ADJUSTMENTS_PKG.Delete_Row(p_PRICE_ADJ_ID => l_price_adjustment_id);

9110: aso_debug_pub.add('ASO_PRICING_CORE_PVT:No record in C_get_adj_id_HdrL:i - '||i,1,'Y');
9111: END IF;
9112: /*Do not error OUT do nothing*/
9113: ELSE
9114: ASO_PRICE_ADJUSTMENTS_PKG.Delete_Row(p_PRICE_ADJ_ID => l_price_adjustment_id);
9115: END IF;
9116: CLOSE C_get_adj_id_HdrL;
9117: End If;-- IF (p_price_attr_tbl(i).pricing_attribute2 is null
9118:

Line 9140: ASO_PRICE_ADJUSTMENTS_PKG.Delete_Row(p_PRICE_ADJ_ID => l_price_adjustment_id);

9136: );
9137: FETCH C_get_adj_id_LnH INTO l_price_adjustment_id;
9138:
9139: While C_get_adj_id_LnH%found LOOP
9140: ASO_PRICE_ADJUSTMENTS_PKG.Delete_Row(p_PRICE_ADJ_ID => l_price_adjustment_id);
9141: FETCH C_get_adj_id_LnH INTO l_price_adjustment_id;
9142: End Loop;
9143:
9144: CLOSE C_get_adj_id_LnH;

Line 9165: ASO_PRICE_ADJUSTMENTS_PKG.Delete_Row(p_PRICE_ADJ_ID => l_price_adjustment_id);

9161: aso_debug_pub.add('ASO_PRICING_CORE_PVT:No record in C_get_adj_id_LnL:i'||i,1,'Y');
9162: END IF;
9163: /*Do not error OUT - do nothing*/
9164: ELSE
9165: ASO_PRICE_ADJUSTMENTS_PKG.Delete_Row(p_PRICE_ADJ_ID => l_price_adjustment_id);
9166: END IF;
9167: CLOSE C_get_adj_id_LnL;
9168:
9169: End If;

Line 9543: INSERT INTO ASO_PRICE_ADJUSTMENTS

9539: END IF;
9540:
9541: If p_insert_type = 'HDR' then
9542:
9543: INSERT INTO ASO_PRICE_ADJUSTMENTS
9544: (price_adjustment_id,
9545: creation_date,
9546: created_by,
9547: last_update_date,

Line 9590: nvl(ldets_v.PRICE_ADJUSTMENT_ID,ASO_PRICE_ADJUSTMENTS_S.nextval),

9586: operand_per_pqty,
9587: adjusted_amount_per_pqty
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

Line 9709: ASO_PRICE_ADJUSTMENTS ADJ,

9705: FROM
9706: QP_PREQ_RLTD_LINES_TMP RLTD,
9707: QP_PREQ_LINES_TMP LINE,
9708: QP_PREQ_LINES_TMP RLTD_LINE,
9709: ASO_PRICE_ADJUSTMENTS ADJ,
9710: ASO_PRICE_ADJUSTMENTS RADJ
9711: WHERE RLTD.PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_NEW
9712: AND RLTD_LINE.line_index = RLTD.related_line_index
9713: AND RLTD.Relationship_Type_Code in

Line 9710: ASO_PRICE_ADJUSTMENTS RADJ

9706: QP_PREQ_RLTD_LINES_TMP RLTD,
9707: QP_PREQ_LINES_TMP LINE,
9708: QP_PREQ_LINES_TMP RLTD_LINE,
9709: ASO_PRICE_ADJUSTMENTS ADJ,
9710: ASO_PRICE_ADJUSTMENTS RADJ
9711: WHERE RLTD.PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_NEW
9712: AND RLTD_LINE.line_index = RLTD.related_line_index
9713: AND RLTD.Relationship_Type_Code in
9714: (QP_PREQ_GRP.G_PBH_LINE ,QP_PREQ_GRP.G_GENERATED_LINE )

Line 9769: ASO_PRICE_ADJUSTMENTS ADJ,

9765: ,decode(QPLAT.ATTRIBUTE_TYPE,
9766: 'QUALIFIER','QP_ATTR_DEFNS_QUALIFIER',
9767: 'QP_ATTR_DEFNS_PRICING')
9768: FROM
9769: ASO_PRICE_ADJUSTMENTS ADJ,
9770: QP_PREQ_LINES_TMP LINES ,
9771: QP_PREQ_LDETS_TMP LDETS,
9772: QP_PREQ_LINE_ATTRS_TMP QPLAT
9773: WHERE ADJ.QUOTE_HEADER_ID = p_qte_header_rec.quote_header_id

Line 9820: ASO_PRICE_ADJUSTMENTS ADJ,

9816: ,decode(QPLAT.ATTRIBUTE_TYPE,
9817: 'QUALIFIER','QP_ATTR_DEFNS_QUALIFIER',
9818: 'QP_ATTR_DEFNS_PRICING')
9819: FROM
9820: ASO_PRICE_ADJUSTMENTS ADJ,
9821: QP_PREQ_LINES_TMP LINES ,
9822: QP_PREQ_LDETS_TMP LDETS,
9823: QP_PREQ_LINE_ATTRS_TMP QPLAT
9824: WHERE ADJ.QUOTE_HEADER_ID = p_qte_header_rec.quote_header_id

Line 9861: INSERT INTO ASO_PRICE_ADJUSTMENTS

9857: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
9858: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Only insert line level adjustments and relationships and attribs',1,'Y');
9859: END IF;
9860:
9861: INSERT INTO ASO_PRICE_ADJUSTMENTS
9862: (price_adjustment_id,
9863: creation_date,
9864: created_by,
9865: last_update_date,

Line 9908: nvl(ldets_v.PRICE_ADJUSTMENT_ID,ASO_PRICE_ADJUSTMENTS_S.nextval),

9904: operand_per_pqty,
9905: adjusted_amount_per_pqty
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

Line 10029: ASO_PRICE_ADJUSTMENTS ADJ,

10025: FROM
10026: QP_PREQ_RLTD_LINES_TMP RLTD,
10027: QP_PREQ_LINES_TMP LINE,
10028: QP_PREQ_LINES_TMP RLTD_LINE,
10029: ASO_PRICE_ADJUSTMENTS ADJ,
10030: ASO_PRICE_ADJUSTMENTS RADJ
10031: WHERE RLTD.PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_NEW
10032: AND RLTD_LINE.line_index = RLTD.related_line_index
10033: AND RLTD.Relationship_Type_Code in

Line 10030: ASO_PRICE_ADJUSTMENTS RADJ

10026: QP_PREQ_RLTD_LINES_TMP RLTD,
10027: QP_PREQ_LINES_TMP LINE,
10028: QP_PREQ_LINES_TMP RLTD_LINE,
10029: ASO_PRICE_ADJUSTMENTS ADJ,
10030: ASO_PRICE_ADJUSTMENTS RADJ
10031: WHERE RLTD.PRICING_STATUS_CODE = QP_PREQ_PUB.G_STATUS_NEW
10032: AND RLTD_LINE.line_index = RLTD.related_line_index
10033: AND RLTD.Relationship_Type_Code in
10034: (QP_PREQ_GRP.G_PBH_LINE ,QP_PREQ_GRP.G_GENERATED_LINE )

Line 10087: ASO_PRICE_ADJUSTMENTS ADJ,

10083: ,decode(QPLAT.ATTRIBUTE_TYPE,
10084: 'QUALIFIER','QP_ATTR_DEFNS_QUALIFIER',
10085: 'QP_ATTR_DEFNS_PRICING')
10086: FROM
10087: ASO_PRICE_ADJUSTMENTS ADJ,
10088: QP_PREQ_LINES_TMP LINES ,
10089: QP_PREQ_LDETS_TMP LDETS,
10090: QP_PREQ_LINE_ATTRS_TMP QPLAT
10091: WHERE ADJ.QUOTE_HEADER_ID = p_qte_header_rec.quote_header_id

Line 10116: INSERT INTO ASO_PRICE_ADJUSTMENTS

10112: aso_debug_pub.add('ASO_PRICING_CORE_PVT:p_insert_type: '||p_insert_type,1,'Y');
10113: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Inserting only header level adjustments',1,'Y');
10114: END IF;
10115:
10116: INSERT INTO ASO_PRICE_ADJUSTMENTS
10117: (price_adjustment_id,
10118: creation_date,
10119: created_by,
10120: last_update_date,

Line 10163: nvl(ldets_v.PRICE_ADJUSTMENT_ID,ASO_PRICE_ADJUSTMENTS_S.nextval),

10159: operand_per_pqty,
10160: adjusted_amount_per_pqty
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,

Line 10253: ASO_PRICE_ADJUSTMENTS ADJ,

10249: ,decode(QPLAT.ATTRIBUTE_TYPE,
10250: 'QUALIFIER','QP_ATTR_DEFNS_QUALIFIER',
10251: 'QP_ATTR_DEFNS_PRICING')
10252: FROM
10253: ASO_PRICE_ADJUSTMENTS ADJ,
10254: QP_PREQ_LINES_TMP LINES ,
10255: QP_PREQ_LDETS_TMP LDETS,
10256: QP_PREQ_LINE_ATTRS_TMP QPLAT
10257: WHERE ADJ.QUOTE_HEADER_ID = p_qte_header_rec.quote_header_id

Line 10280: --Just Insert ASO_PRICE_ADJUSTMENTS only.

10276:
10277: End if;--If p_control_rec.price_mode = 'BATCH'
10278: Else
10279: --l_db_line_counter is zero.
10280: --Just Insert ASO_PRICE_ADJUSTMENTS only.
10281:
10282: INSERT INTO ASO_PRICE_ADJUSTMENTS
10283: (price_adjustment_id,
10284: creation_date,

Line 10282: INSERT INTO ASO_PRICE_ADJUSTMENTS

10278: Else
10279: --l_db_line_counter is zero.
10280: --Just Insert ASO_PRICE_ADJUSTMENTS only.
10281:
10282: INSERT INTO ASO_PRICE_ADJUSTMENTS
10283: (price_adjustment_id,
10284: creation_date,
10285: created_by,
10286: last_update_date,

Line 10329: nvl(ldets_v.PRICE_ADJUSTMENT_ID,ASO_PRICE_ADJUSTMENTS_S.nextval),

10325: operand_per_pqty,
10326: adjusted_amount_per_pqty
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

Line 10889: FROM ASO_PRICE_ADJUSTMENTS

10885: AND QPLAT.LINE_DETAIL_INDEX = l_line_detail_index;
10886:
10887: CURSOR C_Get_Parent_Adj_id(l_qte_line_id NUMBER, l_modifier_line_id NUMBER) IS
10888: SELECT PRICE_ADJUSTMENT_ID
10889: FROM ASO_PRICE_ADJUSTMENTS
10890: WHERE quote_line_id = l_qte_line_id
10891: AND modifier_line_id = l_modifier_line_id;
10892:
10893: BEGIN