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_MAP_QUOTE_ORDER_INT dependencies on OE_GLOBALS

Line 136: l_control_rec OE_GLOBALS.Control_Rec_Type;

132: -- declaration for line and header level record types
133:
134: l_api_version_number CONSTANT NUMBER := 1.0;
135: l_api_name CONSTANT VARCHAR2(30):= 'MAP_QUOTE_TO_Order';
136: l_control_rec OE_GLOBALS.Control_Rec_Type;
137: l_return_status VARCHAR2(1);
138: l_header_rec OE_Order_PUB.Header_Rec_Type;
139: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
140: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;

Line 897: l_header_rec.operation := OE_GLOBALS.G_OPR_CREATE;

893: END IF;
894:
895:
896: IF p_operation = 'CREATE' THEN
897: l_header_rec.operation := OE_GLOBALS.G_OPR_CREATE;
898: ELSIF p_operation = 'UPDATE' THEN
899: l_header_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
900: l_header_rec.header_id := p_qte_rec.order_id;
901: END IF;

Line 899: l_header_rec.operation := OE_GLOBALS.G_OPR_UPDATE;

895:
896: IF p_operation = 'CREATE' THEN
897: l_header_rec.operation := OE_GLOBALS.G_OPR_CREATE;
898: ELSIF p_operation = 'UPDATE' THEN
899: l_header_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
900: l_header_rec.header_id := p_qte_rec.order_id;
901: END IF;
902:
903: l_header_rec.order_number := p_qte_rec.order_number;

Line 1654: IF l_header_rec.operation <> OE_GLOBALS.G_OPR_CREATE THEN

1650: -- the operation code of the line is the same as shipment for create, delete
1651: -- however, for update it is obtained from line directly.
1652: -- for eg: if there is a payment line added then operation at shipment level
1653: -- will be null however it will be update for the line
1654: IF l_header_rec.operation <> OE_GLOBALS.G_OPR_CREATE THEN
1655: l_line_tbl(i).header_id := p_qte_rec.order_id;
1656: END IF;
1657:
1658: IF p_operation = 'CREATE' THEN

Line 1659: l_line_tbl(i).operation := OE_GLOBALS.G_OPR_CREATE;

1655: l_line_tbl(i).header_id := p_qte_rec.order_id;
1656: END IF;
1657:
1658: IF p_operation = 'CREATE' THEN
1659: l_line_tbl(i).operation := OE_GLOBALS.G_OPR_CREATE;
1660: ELSIF p_line_shipment_tbl(j).operation_code = 'CREATE' THEN
1661: l_line_tbl(i).operation := OE_GLOBALS.G_OPR_CREATE;
1662: ELSIF p_line_shipment_tbl(j).operation_code = 'DELETE' THEN
1663: l_line_tbl(i).operation := OE_GLOBALS.G_OPR_DELETE;

Line 1661: l_line_tbl(i).operation := OE_GLOBALS.G_OPR_CREATE;

1657:
1658: IF p_operation = 'CREATE' THEN
1659: l_line_tbl(i).operation := OE_GLOBALS.G_OPR_CREATE;
1660: ELSIF p_line_shipment_tbl(j).operation_code = 'CREATE' THEN
1661: l_line_tbl(i).operation := OE_GLOBALS.G_OPR_CREATE;
1662: ELSIF p_line_shipment_tbl(j).operation_code = 'DELETE' THEN
1663: l_line_tbl(i).operation := OE_GLOBALS.G_OPR_DELETE;
1664: l_line_tbl(i).line_id := p_line_shipment_tbl(j).order_line_id;
1665: ELSIF p_qte_line_tbl(k).operation_code = 'UPDATE' THEN

Line 1663: l_line_tbl(i).operation := OE_GLOBALS.G_OPR_DELETE;

1659: l_line_tbl(i).operation := OE_GLOBALS.G_OPR_CREATE;
1660: ELSIF p_line_shipment_tbl(j).operation_code = 'CREATE' THEN
1661: l_line_tbl(i).operation := OE_GLOBALS.G_OPR_CREATE;
1662: ELSIF p_line_shipment_tbl(j).operation_code = 'DELETE' THEN
1663: l_line_tbl(i).operation := OE_GLOBALS.G_OPR_DELETE;
1664: l_line_tbl(i).line_id := p_line_shipment_tbl(j).order_line_id;
1665: ELSIF p_qte_line_tbl(k).operation_code = 'UPDATE' THEN
1666: l_line_tbl(i).operation := OE_GLOBALS.G_OPR_UPDATE;
1667: l_line_tbl(i).line_id := p_line_shipment_tbl(j).order_line_id;

Line 1666: l_line_tbl(i).operation := OE_GLOBALS.G_OPR_UPDATE;

1662: ELSIF p_line_shipment_tbl(j).operation_code = 'DELETE' THEN
1663: l_line_tbl(i).operation := OE_GLOBALS.G_OPR_DELETE;
1664: l_line_tbl(i).line_id := p_line_shipment_tbl(j).order_line_id;
1665: ELSIF p_qte_line_tbl(k).operation_code = 'UPDATE' THEN
1666: l_line_tbl(i).operation := OE_GLOBALS.G_OPR_UPDATE;
1667: l_line_tbl(i).line_id := p_line_shipment_tbl(j).order_line_id;
1668: ELSIF p_qte_line_tbl(k).operation_code = 'CREATE' THEN
1669: l_line_tbl(i).operation := OE_GLOBALS.G_OPR_CREATE;
1670: END IF;

Line 1669: l_line_tbl(i).operation := OE_GLOBALS.G_OPR_CREATE;

1665: ELSIF p_qte_line_tbl(k).operation_code = 'UPDATE' THEN
1666: l_line_tbl(i).operation := OE_GLOBALS.G_OPR_UPDATE;
1667: l_line_tbl(i).line_id := p_line_shipment_tbl(j).order_line_id;
1668: ELSIF p_qte_line_tbl(k).operation_code = 'CREATE' THEN
1669: l_line_tbl(i).operation := OE_GLOBALS.G_OPR_CREATE;
1670: END IF;
1671:
1672: FOR l in 1..p_qte_line_dtl_tbl.count LOOP
1673:

Line 2207: l_Line_Adj_tbl(l_line_adj_tbl_count + 1).operation := OE_GLOBALS.g_opr_create;

2203: l_Line_Adj_tbl(l_line_adj_tbl_count + 1).adjusted_amount := p_line_tax_detail_tbl(l).tax_amount;
2204: l_Line_Adj_tbl(l_line_adj_tbl_count + 1).automatic_flag := 'N';
2205: l_Line_Adj_tbl(l_line_adj_tbl_count + 1).list_line_type_code := 'TAX';
2206: l_Line_Adj_tbl(l_line_adj_tbl_count + 1).arithmetic_operator := 'AMT';
2207: l_Line_Adj_tbl(l_line_adj_tbl_count + 1).operation := OE_GLOBALS.g_opr_create;
2208:
2209: if aso_debug_pub.g_debug_flag = 'Y' then
2210:
2211: aso_debug_pub.add('l_line_tbl('||i||').tax_exempt_flag: '||l_line_tbl(i).tax_exempt_flag,1,'N');

Line 3320: IF p_operation <> OE_GLOBALS.G_OPR_CREATE THEN

3316: := p_header_price_attributes_tbl(i).flex_title;
3317: -- bug# 2020930 end
3318:
3319: -- this is need if header is update but the operation here is create
3320: IF p_operation <> OE_GLOBALS.G_OPR_CREATE THEN
3321: l_header_price_att_tbl(p_att_count).header_id
3322: := p_qte_rec.quote_header_id;
3323: l_header_price_att_tbl(p_att_count).order_price_attrib_id
3324: := p_header_price_attributes_tbl(i).price_attribute_id;

Line 3325: ELSIF p_operation = OE_GLOBALS.G_OPR_CREATE THEN

3321: l_header_price_att_tbl(p_att_count).header_id
3322: := p_qte_rec.quote_header_id;
3323: l_header_price_att_tbl(p_att_count).order_price_attrib_id
3324: := p_header_price_attributes_tbl(i).price_attribute_id;
3325: ELSIF p_operation = OE_GLOBALS.G_OPR_CREATE THEN
3326: l_header_price_att_tbl(p_att_count).order_price_attrib_id
3327: := FND_API.G_MISS_NUM;
3328: END IF;
3329:

Line 3462: IF p_operation <> OE_GLOBALS.G_OPR_CREATE THEN

3458: := p_header_price_adj_tbl(i).INCLUDE_ON_RETURNS_FLAG;
3459: l_header_adj_tbl(adj_count).CREDIT_OR_CHARGE_FLAG
3460: := p_header_price_adj_tbl(i).CREDIT_OR_CHARGE_FLAG;
3461:
3462: IF p_operation <> OE_GLOBALS.G_OPR_CREATE THEN
3463: l_header_adj_tbl(adj_count).header_id
3464: := p_qte_rec.quote_header_id;
3465: l_header_adj_tbl(adj_count).price_adjustment_id
3466: := p_header_price_adj_tbl(i).price_adjustment_id;

Line 3467: ELSIF p_operation = OE_GLOBALS.G_OPR_CREATE THEN

3463: l_header_adj_tbl(adj_count).header_id
3464: := p_qte_rec.quote_header_id;
3465: l_header_adj_tbl(adj_count).price_adjustment_id
3466: := p_header_price_adj_tbl(i).price_adjustment_id;
3467: ELSIF p_operation = OE_GLOBALS.G_OPR_CREATE THEN
3468: l_header_adj_tbl(adj_count).price_adjustment_id := FND_API.G_MISS_NUM;
3469: END IF;
3470:
3471: l_header_adj_tbl(adj_count).operation := p_operation;

Line 3539: IF p_operation <> OE_GLOBALS.G_OPR_CREATE THEN

3535: l_header_adj_att_tbl(attr_count).comparison_operator
3536: := p_header_price_adj_attr_tbl(j).comparison_operator;
3537:
3538:
3539: IF p_operation <> OE_GLOBALS.G_OPR_CREATE THEN
3540: l_header_adj_att_tbl(attr_count).price_adjustment_id
3541: := p_header_price_adj_attr_tbl(j).price_adjustment_id;
3542: l_header_adj_att_tbl(attr_count).price_adj_attrib_id
3543: := p_header_price_adj_attr_tbl(j).price_adj_attrib_id;

Line 3544: ELSIF p_operation = OE_GLOBALS.G_OPR_CREATE THEN

3540: l_header_adj_att_tbl(attr_count).price_adjustment_id
3541: := p_header_price_adj_attr_tbl(j).price_adjustment_id;
3542: l_header_adj_att_tbl(attr_count).price_adj_attrib_id
3543: := p_header_price_adj_attr_tbl(j).price_adj_attrib_id;
3544: ELSIF p_operation = OE_GLOBALS.G_OPR_CREATE THEN
3545: l_header_adj_att_tbl(attr_count).price_adj_attrib_id
3546: := FND_API.G_MISS_NUM;
3547: END IF;
3548:

Line 3574: IF P_operation = OE_GLOBALS.G_OPR_CREATE THEN

3570:
3571: FOR j in 1..P_header_Price_Adj_rltship_Tbl.count LOOP
3572:
3573:
3574: IF P_operation = OE_GLOBALS.G_OPR_CREATE THEN
3575: l_Header_Adj_Assoc_tbl(i).price_adj_assoc_id := FND_API.G_MISS_NUM;
3576: l_Header_Adj_Assoc_tbl(i).Adj_index
3577: := P_Header_Price_Adj_rltship_Tbl(j).PRICE_ADJ_INDEX ;
3578: l_Header_Adj_Assoc_tbl(i).Rltd_Adj_Index

Line 3669: IF p_header_operation <> OE_GLOBALS.G_OPR_CREATE THEN

3665:
3666: l_Header_Scredit_tbl(sc_count).SALES_CREDIT_TYPE_ID
3667: := P_header_sales_credit_Tbl(j).SALES_CREDIT_TYPE_ID;
3668:
3669: IF p_header_operation <> OE_GLOBALS.G_OPR_CREATE THEN
3670: l_Header_Scredit_tbl(sc_count).header_id
3671: := P_qte_rec.quote_header_id;
3672: l_Header_Scredit_tbl(sc_count).sales_credit_id
3673: := P_header_sales_credit_Tbl(j).sales_credit_id;

Line 3674: ELSIF p_header_operation = OE_GLOBALS.G_OPR_CREATE THEN

3670: l_Header_Scredit_tbl(sc_count).header_id
3671: := P_qte_rec.quote_header_id;
3672: l_Header_Scredit_tbl(sc_count).sales_credit_id
3673: := P_header_sales_credit_Tbl(j).sales_credit_id;
3674: ELSIF p_header_operation = OE_GLOBALS.G_OPR_CREATE THEN
3675: l_Header_Scredit_tbl(sc_count).sales_credit_id := FND_API.G_MISS_NUM;
3676: END IF;
3677:
3678: l_Header_Scredit_tbl(sc_count).operation := p_header_operation;

Line 3947: IF p_operation = OE_GLOBALS.G_OPR_CREATE THEN

3943: l_line_price_att_tbl(p_att_count).attribute15
3944: := p_line_price_attributes_tbl(l).attribute15;
3945: -- bug# 2020930 end
3946:
3947: IF p_operation = OE_GLOBALS.G_OPR_CREATE THEN
3948: l_line_price_att_tbl(p_att_count).order_price_attrib_id
3949: := FND_API.G_MISS_NUM;
3950: ELSIF p_operation = OE_GLOBALS.G_OPR_UPDATE THEN
3951: l_line_price_att_tbl(p_att_count).header_id

Line 3950: ELSIF p_operation = OE_GLOBALS.G_OPR_UPDATE THEN

3946:
3947: IF p_operation = OE_GLOBALS.G_OPR_CREATE THEN
3948: l_line_price_att_tbl(p_att_count).order_price_attrib_id
3949: := FND_API.G_MISS_NUM;
3950: ELSIF p_operation = OE_GLOBALS.G_OPR_UPDATE THEN
3951: l_line_price_att_tbl(p_att_count).header_id
3952: := p_line_price_attributes_tbl(l).quote_header_id;
3953: l_line_price_att_tbl(p_att_count).line_id
3954: := p_line_price_attributes_tbl(l).quote_line_id;

Line 3957: ELSIF p_operation = OE_GLOBALS.G_OPR_DELETE THEN

3953: l_line_price_att_tbl(p_att_count).line_id
3954: := p_line_price_attributes_tbl(l).quote_line_id;
3955: l_line_price_att_tbl(p_att_count).order_price_attrib_id
3956: := p_line_price_attributes_tbl(l).price_attribute_id;
3957: ELSIF p_operation = OE_GLOBALS.G_OPR_DELETE THEN
3958: l_line_price_att_tbl(p_att_count).order_price_attrib_id
3959: := p_line_price_attributes_tbl(l).price_attribute_id;
3960: END IF;
3961:

Line 4022: IF p_operation <> OE_GLOBALS.G_OPR_CREATE AND p_operation <> FND_API.G_MISS_CHAR THEN

4018: l_line_adj_tbl(adj_count).attribute9 := p_line_price_adj_tbl(pad_count).attribute9;
4019: l_line_adj_tbl(adj_count).context := p_line_price_adj_tbl(pad_count).attribute_category;
4020: l_line_adj_tbl(adj_count).automatic_flag := p_line_price_adj_tbl(pad_count).automatic_flag;
4021:
4022: IF p_operation <> OE_GLOBALS.G_OPR_CREATE AND p_operation <> FND_API.G_MISS_CHAR THEN
4023:
4024: l_line_adj_tbl(adj_count).header_id := p_line_price_adj_tbl(pad_count).quote_header_id;
4025: l_line_adj_tbl(adj_count).line_id := p_line_price_adj_tbl(pad_count).quote_line_id;
4026:

Line 4027: ELSIF p_operation = OE_GLOBALS.G_OPR_CREATE THEN

4023:
4024: l_line_adj_tbl(adj_count).header_id := p_line_price_adj_tbl(pad_count).quote_header_id;
4025: l_line_adj_tbl(adj_count).line_id := p_line_price_adj_tbl(pad_count).quote_line_id;
4026:
4027: ELSIF p_operation = OE_GLOBALS.G_OPR_CREATE THEN
4028:
4029: l_line_adj_tbl(adj_count).price_adjustment_id := FND_API.G_MISS_NUM;
4030:
4031: END IF;

Line 4096: IF p_operation = OE_GLOBALS.G_OPR_CREATE THEN

4092: FOR l in 1..p_line_price_adj_attr_tbl.count LOOP
4093:
4094: IF p_line_price_adj_attr_tbl(l).price_adj_index = pad_count THEN
4095:
4096: IF p_operation = OE_GLOBALS.G_OPR_CREATE THEN
4097: l_line_adj_att_tbl(attr_count).price_adj_attrib_id := FND_API.G_MISS_NUM;
4098: ELSIF p_operation <> OE_GLOBALS.G_OPR_CREATE THEN
4099: l_line_adj_att_tbl(attr_count).price_adj_attrib_id := p_line_price_adj_attr_tbl(l).price_adj_attrib_id;
4100: l_line_adj_att_tbl(attr_count).price_adjustment_id := p_line_price_adj_attr_tbl(l).price_adjustment_id;

Line 4098: ELSIF p_operation <> OE_GLOBALS.G_OPR_CREATE THEN

4094: IF p_line_price_adj_attr_tbl(l).price_adj_index = pad_count THEN
4095:
4096: IF p_operation = OE_GLOBALS.G_OPR_CREATE THEN
4097: l_line_adj_att_tbl(attr_count).price_adj_attrib_id := FND_API.G_MISS_NUM;
4098: ELSIF p_operation <> OE_GLOBALS.G_OPR_CREATE THEN
4099: l_line_adj_att_tbl(attr_count).price_adj_attrib_id := p_line_price_adj_attr_tbl(l).price_adj_attrib_id;
4100: l_line_adj_att_tbl(attr_count).price_adjustment_id := p_line_price_adj_attr_tbl(l).price_adjustment_id;
4101: END IF;
4102:

Line 4180: IF l_Line_Adj_Assoc_tbl(adj_rlt_count).operation = OE_GLOBALS.G_OPR_CREATE THEN

4176: IF P_Line_Price_Adj_rltship_Tbl(l).qte_line_index = p_qte_line_index THEN
4177:
4178: l_Line_Adj_Assoc_tbl(adj_rlt_count).operation := p_operation;
4179:
4180: IF l_Line_Adj_Assoc_tbl(adj_rlt_count).operation = OE_GLOBALS.G_OPR_CREATE THEN
4181: l_Line_Adj_Assoc_tbl(adj_rlt_count).Adj_index
4182: := P_Line_Price_Adj_rltship_Tbl(l).price_adj_index;
4183: l_Line_Adj_Assoc_tbl(adj_rlt_count).Rltd_Adj_index
4184: := P_Line_Price_Adj_rltship_Tbl(l).rltd_price_adj_index;

Line 4188: ELSIF l_Line_Adj_Assoc_tbl(adj_rlt_count).operation = OE_GLOBALS.G_OPR_UPDATE THEN

4184: := P_Line_Price_Adj_rltship_Tbl(l).rltd_price_adj_index;
4185: l_Line_Adj_Assoc_tbl(adj_rlt_count).Line_Index := p_line_index;
4186: l_line_Adj_Assoc_tbl(adj_rlt_count).price_adj_assoc_id := FND_API.G_MISS_NUM;
4187:
4188: ELSIF l_Line_Adj_Assoc_tbl(adj_rlt_count).operation = OE_GLOBALS.G_OPR_UPDATE THEN
4189:
4190: l_Line_Adj_Assoc_tbl(adj_rlt_count).line_id
4191: := P_Line_Price_Adj_rltship_Tbl(l).QUOTE_LINE_ID;
4192: l_Line_Adj_Assoc_tbl(adj_rlt_count).price_adj_assoc_id

Line 4290: IF p_line_operation <> OE_GLOBALS.G_OPR_CREATE THEN

4286:
4287: l_Line_Scredit_tbl(sc_count).SALES_CREDIT_TYPE_ID
4288: := P_line_sales_credit_Tbl(l).SALES_CREDIT_TYPE_ID;
4289:
4290: IF p_line_operation <> OE_GLOBALS.G_OPR_CREATE THEN
4291: l_Line_Scredit_tbl(sc_count).sales_credit_id
4292: := P_line_sales_credit_Tbl(l).sales_credit_id;
4293: ELSIF p_line_operation = OE_GLOBALS.G_OPR_CREATE THEN
4294: l_Line_Scredit_tbl(sc_count).sales_credit_id := FND_API.G_MISS_NUM;

Line 4293: ELSIF p_line_operation = OE_GLOBALS.G_OPR_CREATE THEN

4289:
4290: IF p_line_operation <> OE_GLOBALS.G_OPR_CREATE THEN
4291: l_Line_Scredit_tbl(sc_count).sales_credit_id
4292: := P_line_sales_credit_Tbl(l).sales_credit_id;
4293: ELSIF p_line_operation = OE_GLOBALS.G_OPR_CREATE THEN
4294: l_Line_Scredit_tbl(sc_count).sales_credit_id := FND_API.G_MISS_NUM;
4295: END IF;
4296:
4297: l_Line_Scredit_tbl(sc_count).operation := p_line_operation;

Line 4491: IF p_operation <> OE_GLOBALS.G_OPR_CREATE THEN

4487: := P_lot_serial_tbl(l).status_flag;
4488: l_lot_serial_tbl(lot_srl_count).line_set_id
4489: := P_lot_serial_tbl(l).line_set_id ;
4490:
4491: IF p_operation <> OE_GLOBALS.G_OPR_CREATE THEN
4492: l_lot_serial_tbl(lot_srl_count).line_id
4493: := P_lot_serial_tbl(l).line_id;
4494: END IF;
4495: