DBA Data[Home] [Help]

APPS.OE_CNCL_ORDER_IMPORT_PVT dependencies on OE_GLOBALS

Line 47: l_control_rec OE_Globals.Control_Rec_Type;

43:
44:
45: ) IS
46:
47: l_control_rec OE_Globals.Control_Rec_Type;
48:
49: l_header_adj_rec OE_Order_Pub.Header_Adj_Rec_Type;
50: l_header_scredit_rec OE_Order_Pub.Header_Scredit_Rec_Type;
51: l_line_rec OE_Order_Pub.Line_Rec_Type;

Line 161: l_api_service_level VARCHAR2(30) := OE_GLOBALS.G_ALL_SERVICE;

157: l_init_msg_list VARCHAR2(1) := p_init_msg_list;
158: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
159: l_return_values VARCHAR2(1) := FND_API.G_FALSE;
160: l_commit VARCHAR2(1) := FND_API.G_FALSE;
161: l_api_service_level VARCHAR2(30) := OE_GLOBALS.G_ALL_SERVICE;
162:
163: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
164: l_return_status_oi_pre VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
165: l_return_status_oi_pst VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 404: , nvl(operation_code, OE_GLOBALS.G_OPR_CREATE)

400: , nvl(global_attribute19, FND_API.G_MISS_CHAR)
401: , nvl(global_attribute20, FND_API.G_MISS_CHAR)
402: , request_id
403: , NVL(request_date, FND_API.G_MISS_DATE)
404: , nvl(operation_code, OE_GLOBALS.G_OPR_CREATE)
405: , nvl(ready_flag, 'Y')
406: , nvl(status_flag, '0')
407: , nvl(force_apply_flag, 'N')
408: , nvl(change_reason, FND_API.G_MISS_CHAR)

Line 511: , nvl(operation_code, OE_GLOBALS.G_OPR_CREATE)

507: , nvl(attribute13, FND_API.G_MISS_CHAR)
508: , nvl(attribute14, FND_API.G_MISS_CHAR)
509: , nvl(attribute15, FND_API.G_MISS_CHAR)
510: , request_id
511: , nvl(operation_code, OE_GLOBALS.G_OPR_CREATE)
512: , nvl(status_flag, FND_API.G_MISS_CHAR)
513: -- Price Adjustment related changes bug# 1220921 (Start)
514: , nvl( AC_CONTEXT, FND_API.G_MISS_CHAR)
515: , nvl( AC_ATTRIBUTE1, FND_API.G_MISS_CHAR)

Line 604: , nvl(operation_code, OE_GLOBALS.G_OPR_CREATE)

600: , nvl(attribute12, FND_API.G_MISS_CHAR)
601: , nvl(attribute13, FND_API.G_MISS_CHAR)
602: , nvl(attribute14, FND_API.G_MISS_CHAR)
603: , nvl(attribute15, FND_API.G_MISS_CHAR)
604: , nvl(operation_code, OE_GLOBALS.G_OPR_CREATE)
605: , nvl(status_flag, FND_API.G_MISS_CHAR)
606: FROM oe_credits_iface_all
607: WHERE order_source_id = l_order_source_id
608: AND orig_sys_document_ref = l_orig_sys_document_ref

Line 913: , nvl(operation_code, OE_GLOBALS.G_OPR_CREATE)

909: , nvl(return_attribute13, FND_API.G_MISS_CHAR)
910: , nvl(return_attribute14, FND_API.G_MISS_CHAR)
911: , nvl(return_attribute15, FND_API.G_MISS_CHAR)
912: , request_id
913: , nvl(operation_code, OE_GLOBALS.G_OPR_CREATE)
914: , nvl(status_flag, FND_API.G_MISS_CHAR)
915: , nvl(change_reason, FND_API.G_MISS_CHAR)
916: , nvl(change_comments, FND_API.G_MISS_CHAR)
917: , nvl(service_txn_reason_code, FND_API.G_MISS_CHAR)

Line 1037: , nvl(operation_code, OE_GLOBALS.G_OPR_CREATE)

1033: , nvl(attribute13, FND_API.G_MISS_CHAR)
1034: , nvl(attribute14, FND_API.G_MISS_CHAR)
1035: , nvl(attribute15, FND_API.G_MISS_CHAR)
1036: , request_id
1037: , nvl(operation_code, OE_GLOBALS.G_OPR_CREATE)
1038: , nvl(status_flag, FND_API.G_MISS_CHAR)
1039: -- Price Adjustment related changes bug# 1220921 (Start)
1040: , nvl( AC_CONTEXT, FND_API.G_MISS_CHAR)
1041: , nvl( AC_ATTRIBUTE1, FND_API.G_MISS_CHAR)

Line 1130: , nvl(operation_code, OE_GLOBALS.G_OPR_CREATE)

1126: , nvl(attribute12, FND_API.G_MISS_CHAR)
1127: , nvl(attribute13, FND_API.G_MISS_CHAR)
1128: , nvl(attribute14, FND_API.G_MISS_CHAR)
1129: , nvl(attribute15, FND_API.G_MISS_CHAR)
1130: , nvl(operation_code, OE_GLOBALS.G_OPR_CREATE)
1131: , nvl(status_flag, FND_API.G_MISS_CHAR)
1132: , nvl(ORIG_SYS_LINE_REF, FND_API.G_MISS_CHAR)
1133: FROM oe_credits_iface_all
1134: WHERE order_source_id = l_order_source_id

Line 1185: , nvl(operation_code, OE_GLOBALS.G_OPR_CREATE)

1181: , attribute12
1182: , attribute13
1183: , attribute14
1184: , attribute15
1185: , nvl(operation_code, OE_GLOBALS.G_OPR_CREATE)
1186: FROM oe_reservtns_iface_all
1187: WHERE order_source_id = l_order_source_id
1188: AND orig_sys_document_ref = l_orig_sys_document_ref
1189: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)