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 138: l_control_rec OE_GLOBALS.Control_Rec_Type;

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

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

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

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

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

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

1694: -- the operation code of the line is the same as shipment for create, delete
1695: -- however, for update it is obtained from line directly.
1696: -- for eg: if there is a payment line added then operation at shipment level
1697: -- will be null however it will be update for the line
1698: IF l_header_rec.operation <> OE_GLOBALS.G_OPR_CREATE THEN
1699: l_line_tbl(i).header_id := p_qte_rec.order_id;
1700: END IF;
1701:
1702: IF p_operation = 'CREATE' THEN

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

1699: l_line_tbl(i).header_id := p_qte_rec.order_id;
1700: END IF;
1701:
1702: IF p_operation = 'CREATE' THEN
1703: l_line_tbl(i).operation := OE_GLOBALS.G_OPR_CREATE;
1704: ELSIF p_line_shipment_tbl(j).operation_code = 'CREATE' THEN
1705: l_line_tbl(i).operation := OE_GLOBALS.G_OPR_CREATE;
1706: ELSIF p_line_shipment_tbl(j).operation_code = 'DELETE' THEN
1707: l_line_tbl(i).operation := OE_GLOBALS.G_OPR_DELETE;

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

1701:
1702: IF p_operation = 'CREATE' THEN
1703: l_line_tbl(i).operation := OE_GLOBALS.G_OPR_CREATE;
1704: ELSIF p_line_shipment_tbl(j).operation_code = 'CREATE' THEN
1705: l_line_tbl(i).operation := OE_GLOBALS.G_OPR_CREATE;
1706: ELSIF p_line_shipment_tbl(j).operation_code = 'DELETE' THEN
1707: l_line_tbl(i).operation := OE_GLOBALS.G_OPR_DELETE;
1708: l_line_tbl(i).line_id := p_line_shipment_tbl(j).order_line_id;
1709: ELSIF p_qte_line_tbl(k).operation_code = 'UPDATE' THEN

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

1703: l_line_tbl(i).operation := OE_GLOBALS.G_OPR_CREATE;
1704: ELSIF p_line_shipment_tbl(j).operation_code = 'CREATE' THEN
1705: l_line_tbl(i).operation := OE_GLOBALS.G_OPR_CREATE;
1706: ELSIF p_line_shipment_tbl(j).operation_code = 'DELETE' THEN
1707: l_line_tbl(i).operation := OE_GLOBALS.G_OPR_DELETE;
1708: l_line_tbl(i).line_id := p_line_shipment_tbl(j).order_line_id;
1709: ELSIF p_qte_line_tbl(k).operation_code = 'UPDATE' THEN
1710: l_line_tbl(i).operation := OE_GLOBALS.G_OPR_UPDATE;
1711: l_line_tbl(i).line_id := p_line_shipment_tbl(j).order_line_id;

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

1706: ELSIF p_line_shipment_tbl(j).operation_code = 'DELETE' THEN
1707: l_line_tbl(i).operation := OE_GLOBALS.G_OPR_DELETE;
1708: l_line_tbl(i).line_id := p_line_shipment_tbl(j).order_line_id;
1709: ELSIF p_qte_line_tbl(k).operation_code = 'UPDATE' THEN
1710: l_line_tbl(i).operation := OE_GLOBALS.G_OPR_UPDATE;
1711: l_line_tbl(i).line_id := p_line_shipment_tbl(j).order_line_id;
1712: ELSIF p_qte_line_tbl(k).operation_code = 'CREATE' THEN
1713: l_line_tbl(i).operation := OE_GLOBALS.G_OPR_CREATE;
1714: END IF;

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

1709: ELSIF p_qte_line_tbl(k).operation_code = 'UPDATE' THEN
1710: l_line_tbl(i).operation := OE_GLOBALS.G_OPR_UPDATE;
1711: l_line_tbl(i).line_id := p_line_shipment_tbl(j).order_line_id;
1712: ELSIF p_qte_line_tbl(k).operation_code = 'CREATE' THEN
1713: l_line_tbl(i).operation := OE_GLOBALS.G_OPR_CREATE;
1714: END IF;
1715:
1716: FOR l in 1..p_qte_line_dtl_tbl.count LOOP
1717:

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

2255: l_Line_Adj_tbl(l_line_adj_tbl_count + 1).adjusted_amount := p_line_tax_detail_tbl(l).tax_amount;
2256: l_Line_Adj_tbl(l_line_adj_tbl_count + 1).automatic_flag := 'N';
2257: l_Line_Adj_tbl(l_line_adj_tbl_count + 1).list_line_type_code := 'TAX';
2258: l_Line_Adj_tbl(l_line_adj_tbl_count + 1).arithmetic_operator := 'AMT';
2259: l_Line_Adj_tbl(l_line_adj_tbl_count + 1).operation := OE_GLOBALS.g_opr_create;
2260:
2261: if aso_debug_pub.g_debug_flag = 'Y' then
2262:
2263: aso_debug_pub.add('l_line_tbl('||i||').tax_exempt_flag: '||l_line_tbl(i).tax_exempt_flag,1,'N');

Line 3376: IF p_operation <> OE_GLOBALS.G_OPR_CREATE THEN

3372: := p_header_price_attributes_tbl(i).flex_title;
3373: -- bug# 2020930 end
3374:
3375: -- this is need if header is update but the operation here is create
3376: IF p_operation <> OE_GLOBALS.G_OPR_CREATE THEN
3377: l_header_price_att_tbl(p_att_count).header_id
3378: := p_qte_rec.quote_header_id;
3379: l_header_price_att_tbl(p_att_count).order_price_attrib_id
3380: := p_header_price_attributes_tbl(i).price_attribute_id;

Line 3381: ELSIF p_operation = OE_GLOBALS.G_OPR_CREATE THEN

3377: l_header_price_att_tbl(p_att_count).header_id
3378: := p_qte_rec.quote_header_id;
3379: l_header_price_att_tbl(p_att_count).order_price_attrib_id
3380: := p_header_price_attributes_tbl(i).price_attribute_id;
3381: ELSIF p_operation = OE_GLOBALS.G_OPR_CREATE THEN
3382: l_header_price_att_tbl(p_att_count).order_price_attrib_id
3383: := FND_API.G_MISS_NUM;
3384: END IF;
3385:

Line 3518: IF p_operation <> OE_GLOBALS.G_OPR_CREATE THEN

3514: := p_header_price_adj_tbl(i).INCLUDE_ON_RETURNS_FLAG;
3515: l_header_adj_tbl(adj_count).CREDIT_OR_CHARGE_FLAG
3516: := p_header_price_adj_tbl(i).CREDIT_OR_CHARGE_FLAG;
3517:
3518: IF p_operation <> OE_GLOBALS.G_OPR_CREATE THEN
3519: l_header_adj_tbl(adj_count).header_id
3520: := p_qte_rec.quote_header_id;
3521: l_header_adj_tbl(adj_count).price_adjustment_id
3522: := p_header_price_adj_tbl(i).price_adjustment_id;

Line 3523: ELSIF p_operation = OE_GLOBALS.G_OPR_CREATE THEN

3519: l_header_adj_tbl(adj_count).header_id
3520: := p_qte_rec.quote_header_id;
3521: l_header_adj_tbl(adj_count).price_adjustment_id
3522: := p_header_price_adj_tbl(i).price_adjustment_id;
3523: ELSIF p_operation = OE_GLOBALS.G_OPR_CREATE THEN
3524: l_header_adj_tbl(adj_count).price_adjustment_id := FND_API.G_MISS_NUM;
3525: END IF;
3526:
3527: l_header_adj_tbl(adj_count).operation := p_operation;

Line 3595: IF p_operation <> OE_GLOBALS.G_OPR_CREATE THEN

3591: l_header_adj_att_tbl(attr_count).comparison_operator
3592: := p_header_price_adj_attr_tbl(j).comparison_operator;
3593:
3594:
3595: IF p_operation <> OE_GLOBALS.G_OPR_CREATE THEN
3596: l_header_adj_att_tbl(attr_count).price_adjustment_id
3597: := p_header_price_adj_attr_tbl(j).price_adjustment_id;
3598: l_header_adj_att_tbl(attr_count).price_adj_attrib_id
3599: := p_header_price_adj_attr_tbl(j).price_adj_attrib_id;

Line 3600: ELSIF p_operation = OE_GLOBALS.G_OPR_CREATE THEN

3596: l_header_adj_att_tbl(attr_count).price_adjustment_id
3597: := p_header_price_adj_attr_tbl(j).price_adjustment_id;
3598: l_header_adj_att_tbl(attr_count).price_adj_attrib_id
3599: := p_header_price_adj_attr_tbl(j).price_adj_attrib_id;
3600: ELSIF p_operation = OE_GLOBALS.G_OPR_CREATE THEN
3601: l_header_adj_att_tbl(attr_count).price_adj_attrib_id
3602: := FND_API.G_MISS_NUM;
3603: END IF;
3604:

Line 3630: IF P_operation = OE_GLOBALS.G_OPR_CREATE THEN

3626:
3627: FOR j in 1..P_header_Price_Adj_rltship_Tbl.count LOOP
3628:
3629:
3630: IF P_operation = OE_GLOBALS.G_OPR_CREATE THEN
3631: l_Header_Adj_Assoc_tbl(i).price_adj_assoc_id := FND_API.G_MISS_NUM;
3632: l_Header_Adj_Assoc_tbl(i).Adj_index
3633: := P_Header_Price_Adj_rltship_Tbl(j).PRICE_ADJ_INDEX ;
3634: l_Header_Adj_Assoc_tbl(i).Rltd_Adj_Index

Line 3736: IF p_header_operation <> OE_GLOBALS.G_OPR_CREATE THEN

3732:
3733: l_Header_Scredit_tbl(sc_count).SALES_CREDIT_TYPE_ID
3734: := P_header_sales_credit_Tbl(j).SALES_CREDIT_TYPE_ID;
3735:
3736: IF p_header_operation <> OE_GLOBALS.G_OPR_CREATE THEN
3737: l_Header_Scredit_tbl(sc_count).header_id
3738: := P_qte_rec.quote_header_id;
3739: l_Header_Scredit_tbl(sc_count).sales_credit_id
3740: := P_header_sales_credit_Tbl(j).sales_credit_id;

Line 3741: ELSIF p_header_operation = OE_GLOBALS.G_OPR_CREATE THEN

3737: l_Header_Scredit_tbl(sc_count).header_id
3738: := P_qte_rec.quote_header_id;
3739: l_Header_Scredit_tbl(sc_count).sales_credit_id
3740: := P_header_sales_credit_Tbl(j).sales_credit_id;
3741: ELSIF p_header_operation = OE_GLOBALS.G_OPR_CREATE THEN
3742: l_Header_Scredit_tbl(sc_count).sales_credit_id := FND_API.G_MISS_NUM;
3743: END IF;
3744:
3745: l_Header_Scredit_tbl(sc_count).operation := p_header_operation;

Line 4014: IF p_operation = OE_GLOBALS.G_OPR_CREATE THEN

4010: l_line_price_att_tbl(p_att_count).attribute15
4011: := p_line_price_attributes_tbl(l).attribute15;
4012: -- bug# 2020930 end
4013:
4014: IF p_operation = OE_GLOBALS.G_OPR_CREATE THEN
4015: l_line_price_att_tbl(p_att_count).order_price_attrib_id
4016: := FND_API.G_MISS_NUM;
4017: ELSIF p_operation = OE_GLOBALS.G_OPR_UPDATE THEN
4018: l_line_price_att_tbl(p_att_count).header_id

Line 4017: ELSIF p_operation = OE_GLOBALS.G_OPR_UPDATE THEN

4013:
4014: IF p_operation = OE_GLOBALS.G_OPR_CREATE THEN
4015: l_line_price_att_tbl(p_att_count).order_price_attrib_id
4016: := FND_API.G_MISS_NUM;
4017: ELSIF p_operation = OE_GLOBALS.G_OPR_UPDATE THEN
4018: l_line_price_att_tbl(p_att_count).header_id
4019: := p_line_price_attributes_tbl(l).quote_header_id;
4020: l_line_price_att_tbl(p_att_count).line_id
4021: := p_line_price_attributes_tbl(l).quote_line_id;

Line 4024: ELSIF p_operation = OE_GLOBALS.G_OPR_DELETE THEN

4020: l_line_price_att_tbl(p_att_count).line_id
4021: := p_line_price_attributes_tbl(l).quote_line_id;
4022: l_line_price_att_tbl(p_att_count).order_price_attrib_id
4023: := p_line_price_attributes_tbl(l).price_attribute_id;
4024: ELSIF p_operation = OE_GLOBALS.G_OPR_DELETE THEN
4025: l_line_price_att_tbl(p_att_count).order_price_attrib_id
4026: := p_line_price_attributes_tbl(l).price_attribute_id;
4027: END IF;
4028:

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

4085: l_line_adj_tbl(adj_count).attribute9 := p_line_price_adj_tbl(pad_count).attribute9;
4086: l_line_adj_tbl(adj_count).context := p_line_price_adj_tbl(pad_count).attribute_category;
4087: l_line_adj_tbl(adj_count).automatic_flag := p_line_price_adj_tbl(pad_count).automatic_flag;
4088:
4089: IF p_operation <> OE_GLOBALS.G_OPR_CREATE AND p_operation <> FND_API.G_MISS_CHAR THEN
4090:
4091: l_line_adj_tbl(adj_count).header_id := p_line_price_adj_tbl(pad_count).quote_header_id;
4092: l_line_adj_tbl(adj_count).line_id := p_line_price_adj_tbl(pad_count).quote_line_id;
4093:

Line 4094: ELSIF p_operation = OE_GLOBALS.G_OPR_CREATE THEN

4090:
4091: l_line_adj_tbl(adj_count).header_id := p_line_price_adj_tbl(pad_count).quote_header_id;
4092: l_line_adj_tbl(adj_count).line_id := p_line_price_adj_tbl(pad_count).quote_line_id;
4093:
4094: ELSIF p_operation = OE_GLOBALS.G_OPR_CREATE THEN
4095:
4096: l_line_adj_tbl(adj_count).price_adjustment_id := FND_API.G_MISS_NUM;
4097:
4098: END IF;

Line 4163: IF p_operation = OE_GLOBALS.G_OPR_CREATE THEN

4159: FOR l in 1..p_line_price_adj_attr_tbl.count LOOP
4160:
4161: IF p_line_price_adj_attr_tbl(l).price_adj_index = pad_count THEN
4162:
4163: IF p_operation = OE_GLOBALS.G_OPR_CREATE THEN
4164: l_line_adj_att_tbl(attr_count).price_adj_attrib_id := FND_API.G_MISS_NUM;
4165: ELSIF p_operation <> OE_GLOBALS.G_OPR_CREATE THEN
4166: l_line_adj_att_tbl(attr_count).price_adj_attrib_id := p_line_price_adj_attr_tbl(l).price_adj_attrib_id;
4167: l_line_adj_att_tbl(attr_count).price_adjustment_id := p_line_price_adj_attr_tbl(l).price_adjustment_id;

Line 4165: ELSIF p_operation <> OE_GLOBALS.G_OPR_CREATE THEN

4161: IF p_line_price_adj_attr_tbl(l).price_adj_index = pad_count THEN
4162:
4163: IF p_operation = OE_GLOBALS.G_OPR_CREATE THEN
4164: l_line_adj_att_tbl(attr_count).price_adj_attrib_id := FND_API.G_MISS_NUM;
4165: ELSIF p_operation <> OE_GLOBALS.G_OPR_CREATE THEN
4166: l_line_adj_att_tbl(attr_count).price_adj_attrib_id := p_line_price_adj_attr_tbl(l).price_adj_attrib_id;
4167: l_line_adj_att_tbl(attr_count).price_adjustment_id := p_line_price_adj_attr_tbl(l).price_adjustment_id;
4168: END IF;
4169:

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

4243: IF P_Line_Price_Adj_rltship_Tbl(l).qte_line_index = p_qte_line_index THEN
4244:
4245: l_Line_Adj_Assoc_tbl(adj_rlt_count).operation := p_operation;
4246:
4247: IF l_Line_Adj_Assoc_tbl(adj_rlt_count).operation = OE_GLOBALS.G_OPR_CREATE THEN
4248: l_Line_Adj_Assoc_tbl(adj_rlt_count).Adj_index
4249: := P_Line_Price_Adj_rltship_Tbl(l).price_adj_index;
4250: l_Line_Adj_Assoc_tbl(adj_rlt_count).Rltd_Adj_index
4251: := P_Line_Price_Adj_rltship_Tbl(l).rltd_price_adj_index;

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

4251: := P_Line_Price_Adj_rltship_Tbl(l).rltd_price_adj_index;
4252: l_Line_Adj_Assoc_tbl(adj_rlt_count).Line_Index := p_line_index;
4253: l_line_Adj_Assoc_tbl(adj_rlt_count).price_adj_assoc_id := FND_API.G_MISS_NUM;
4254:
4255: ELSIF l_Line_Adj_Assoc_tbl(adj_rlt_count).operation = OE_GLOBALS.G_OPR_UPDATE THEN
4256:
4257: l_Line_Adj_Assoc_tbl(adj_rlt_count).line_id
4258: := P_Line_Price_Adj_rltship_Tbl(l).QUOTE_LINE_ID;
4259: l_Line_Adj_Assoc_tbl(adj_rlt_count).price_adj_assoc_id

Line 4368: IF p_line_operation <> OE_GLOBALS.G_OPR_CREATE THEN

4364:
4365: l_Line_Scredit_tbl(sc_count).SALES_CREDIT_TYPE_ID
4366: := P_line_sales_credit_Tbl(l).SALES_CREDIT_TYPE_ID;
4367:
4368: IF p_line_operation <> OE_GLOBALS.G_OPR_CREATE THEN
4369: l_Line_Scredit_tbl(sc_count).sales_credit_id
4370: := P_line_sales_credit_Tbl(l).sales_credit_id;
4371: ELSIF p_line_operation = OE_GLOBALS.G_OPR_CREATE THEN
4372: l_Line_Scredit_tbl(sc_count).sales_credit_id := FND_API.G_MISS_NUM;

Line 4371: ELSIF p_line_operation = OE_GLOBALS.G_OPR_CREATE THEN

4367:
4368: IF p_line_operation <> OE_GLOBALS.G_OPR_CREATE THEN
4369: l_Line_Scredit_tbl(sc_count).sales_credit_id
4370: := P_line_sales_credit_Tbl(l).sales_credit_id;
4371: ELSIF p_line_operation = OE_GLOBALS.G_OPR_CREATE THEN
4372: l_Line_Scredit_tbl(sc_count).sales_credit_id := FND_API.G_MISS_NUM;
4373: END IF;
4374:
4375: l_Line_Scredit_tbl(sc_count).operation := p_line_operation;

Line 4590: IF p_operation <> OE_GLOBALS.G_OPR_CREATE THEN

4586: := P_lot_serial_tbl(l).status_flag;
4587: l_lot_serial_tbl(lot_srl_count).line_set_id
4588: := P_lot_serial_tbl(l).line_set_id ;
4589:
4590: IF p_operation <> OE_GLOBALS.G_OPR_CREATE THEN
4591: l_lot_serial_tbl(lot_srl_count).line_id
4592: := P_lot_serial_tbl(l).line_id;
4593: END IF;
4594: