DBA Data[Home] [Help]

APPS.OE_BULK_PROCESS_HEADER dependencies on OE_BULK_ORDER_PVT

Line 70: OE_Bulk_Order_Pvt.G_SOB_ID,

66: ELSE -- Get sequence type from AOL
67:
68: x_result := fnd_seqnum.get_seq_info( 660,
69: x_doc_category_code,
70: OE_Bulk_Order_Pvt.G_SOB_ID,
71: null,
72: sysdate,
73: x_doc_sequence_id,
74: x_doc_sequence_type,

Line 121: OE_Bulk_Order_Pvt.G_SOB_ID,

117: END IF;
118:
119: X_result := fnd_seqnum.get_seq_val(660,
120: x_doc_category_code,
121: OE_Bulk_Order_Pvt.G_SOB_ID,
122: null,
123: sysdate,
124: x_doc_sequence_value,
125: x_doc_sequence_id,

Line 614: ( p_header_rec IN OE_Bulk_Order_Pvt.HEADER_REC_TYPE

610:
611: --bug 5054618}
612:
613: PROCEDURE Check_Book_Reqd_Attributes
614: ( p_header_rec IN OE_Bulk_Order_Pvt.HEADER_REC_TYPE
615: , p_index IN NUMBER
616: , x_return_status IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2
617: )
618: IS

Line 828: (p_header_rec IN OUT NOCOPY OE_Bulk_Order_Pvt.HEADER_REC_TYPE

824: END Check_Book_Reqd_Attributes;
825:
826:
827: PROCEDURE Default_Record
828: (p_header_rec IN OUT NOCOPY OE_Bulk_Order_Pvt.HEADER_REC_TYPE
829: ,p_index IN NUMBER
830: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
831: )
832: IS

Line 1068: (p_header_rec IN OUT NOCOPY OE_Bulk_Order_Pvt.HEADER_REC_TYPE

1064: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1065: END Default_Record;
1066:
1067: PROCEDURE Populate_Internal_Fields
1068: (p_header_rec IN OUT NOCOPY OE_Bulk_Order_Pvt.HEADER_REC_TYPE
1069: ,p_index IN NUMBER
1070: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1071: )
1072: IS

Line 1277: IF OE_Bulk_Order_Pvt.G_CUST_RELATIONS = 'N'

1273: (OE_Bulk_Cache.G_AGREEMENT_TBL(l_c_index).sold_to_org_id
1274: ,p_sold_to_org_id)
1275: THEN
1276:
1277: IF OE_Bulk_Order_Pvt.G_CUST_RELATIONS = 'N'
1278: OR (OE_Bulk_Order_Pvt.G_CUST_RELATIONS = 'Y'
1279: AND NOT Is_Related_Customer(p_sold_to_org_id
1280: ,OE_Bulk_Cache.G_AGREEMENT_TBL(l_c_index).sold_to_org_id))
1281: THEN

Line 1278: OR (OE_Bulk_Order_Pvt.G_CUST_RELATIONS = 'Y'

1274: ,p_sold_to_org_id)
1275: THEN
1276:
1277: IF OE_Bulk_Order_Pvt.G_CUST_RELATIONS = 'N'
1278: OR (OE_Bulk_Order_Pvt.G_CUST_RELATIONS = 'Y'
1279: AND NOT Is_Related_Customer(p_sold_to_org_id
1280: ,OE_Bulk_Cache.G_AGREEMENT_TBL(l_c_index).sold_to_org_id))
1281: THEN
1282:

Line 1415: IF OE_Bulk_Order_Pvt.G_CUST_RELATIONS = 'N' THEN

1411: THEN
1412: RETURN TRUE;
1413: END IF;
1414:
1415: IF OE_Bulk_Order_Pvt.G_CUST_RELATIONS = 'N' THEN
1416:
1417: RETURN FALSE;
1418:
1419: ELSIF OE_Bulk_Order_Pvt.G_CUST_RELATIONS = 'Y' THEN

Line 1419: ELSIF OE_Bulk_Order_Pvt.G_CUST_RELATIONS = 'Y' THEN

1415: IF OE_Bulk_Order_Pvt.G_CUST_RELATIONS = 'N' THEN
1416:
1417: RETURN FALSE;
1418:
1419: ELSIF OE_Bulk_Order_Pvt.G_CUST_RELATIONS = 'Y' THEN
1420:
1421: SELECT 'VALID'
1422: INTO l_dummy
1423: FROM HZ_CUST_ACCT_RELATE

Line 1506: IF OE_Bulk_Order_Pvt.G_CUST_RELATIONS = 'N' THEN

1502: THEN
1503: RETURN TRUE;
1504: END IF;
1505:
1506: IF OE_Bulk_Order_Pvt.G_CUST_RELATIONS = 'N' THEN
1507:
1508: RETURN FALSE;
1509:
1510: ELSIF OE_Bulk_Order_Pvt.G_CUST_RELATIONS = 'Y' THEN

Line 1510: ELSIF OE_Bulk_Order_Pvt.G_CUST_RELATIONS = 'Y' THEN

1506: IF OE_Bulk_Order_Pvt.G_CUST_RELATIONS = 'N' THEN
1507:
1508: RETURN FALSE;
1509:
1510: ELSIF OE_Bulk_Order_Pvt.G_CUST_RELATIONS = 'Y' THEN
1511:
1512: SELECT 'VALID'
1513: INTO l_dummy
1514: FROM HZ_CUST_ACCT_RELATE

Line 1562: IF (OE_Bulk_Order_Pvt.G_CUST_RELATIONS = 'N') THEN

1558: AND ROWNUM=1;
1559:
1560: BEGIN
1561:
1562: IF (OE_Bulk_Order_Pvt.G_CUST_RELATIONS = 'N') THEN
1563:
1564: SELECT 'VALID'
1565: INTO l_dummy
1566: FROM oe_deliver_to_orgs_v

Line 1657: ( p_header_rec IN OUT NOCOPY OE_Bulk_Order_Pvt.HEADER_REC_TYPE

1653: -- 4. Other misc processing like holds evaluation, sales credits.
1654: ---------------------------------------------------------------------
1655:
1656: PROCEDURE Entity
1657: ( p_header_rec IN OUT NOCOPY OE_Bulk_Order_Pvt.HEADER_REC_TYPE
1658: , x_header_scredit_rec IN OUT NOCOPY OE_Bulk_Order_Pvt.SCREDIT_REC_TYPE
1659: , p_defaulting_mode IN VARCHAR2
1660: , p_process_configurations IN VARCHAR2 DEFAULT 'N'
1661: , p_validate_configurations IN VARCHAR2 DEFAULT 'Y'

Line 1658: , x_header_scredit_rec IN OUT NOCOPY OE_Bulk_Order_Pvt.SCREDIT_REC_TYPE

1654: ---------------------------------------------------------------------
1655:
1656: PROCEDURE Entity
1657: ( p_header_rec IN OUT NOCOPY OE_Bulk_Order_Pvt.HEADER_REC_TYPE
1658: , x_header_scredit_rec IN OUT NOCOPY OE_Bulk_Order_Pvt.SCREDIT_REC_TYPE
1659: , p_defaulting_mode IN VARCHAR2
1660: , p_process_configurations IN VARCHAR2 DEFAULT 'N'
1661: , p_validate_configurations IN VARCHAR2 DEFAULT 'Y'
1662: , p_schedule_configurations IN VARCHAR2 DEFAULT 'N'

Line 2220: IF OE_Bulk_Order_Pvt.G_OE_HEADER_ATTRIBUTES = 'Y' THEN

2216: -- BEGIN: Desc Flex Validation
2217:
2218: IF p_validate_desc_flex = 'Y' THEN
2219:
2220: IF OE_Bulk_Order_Pvt.G_OE_HEADER_ATTRIBUTES = 'Y' THEN
2221:
2222: IF NOT OE_VALIDATE.Header_Desc_Flex
2223: (p_context => p_header_rec.context(i)
2224: ,p_attribute1 => p_header_rec.attribute1(i)

Line 2363: IF OE_Bulk_Order_Pvt.G_OE_HEADER_GLOBAL_ATTRIBUTE = 'Y' THEN

2359:
2360: END IF;
2361: END IF;
2362:
2363: IF OE_Bulk_Order_Pvt.G_OE_HEADER_GLOBAL_ATTRIBUTE = 'Y' THEN
2364:
2365: IF NOT OE_VALIDATE.G_Header_Desc_Flex
2366: (p_context => p_header_rec.global_attribute_category(i)
2367: ,p_attribute1 => p_header_rec.global_attribute1(i)

Line 2505: IF OE_Bulk_Order_Pvt.G_OE_HEADER_TP_ATTRIBUTES = 'Y' THEN

2501:
2502: END IF;
2503: END IF;
2504:
2505: IF OE_Bulk_Order_Pvt.G_OE_HEADER_TP_ATTRIBUTES = 'Y' THEN
2506:
2507: IF NOT OE_VALIDATE.TP_Header_Desc_Flex
2508: (p_context => p_header_rec.tp_context(i)
2509: ,p_attribute1 => p_header_rec.tp_attribute1(i)

Line 2661: OE_Bulk_Order_Pvt.G_ACK_NEEDED := 'Y';

2657: );
2658:
2659: IF OE_Bulk_Cache.G_SOLD_TO_TBL(l_c_index).tp_setup THEN
2660:
2661: OE_Bulk_Order_Pvt.G_ACK_NEEDED := 'Y';
2662: p_header_rec.first_ack_code(i) := 'X';
2663:
2664: -- Cache EDI attributes as these will be used in creating
2665: -- the acknowledgment records later.

Line 2801: OE_Bulk_Order_Pvt.G_ERROR_REC.order_source_id.EXTEND(1);

2797: IF (p_header_rec.lock_control(i) IN (-99, -98, -97) ) THEN
2798:
2799: error_count := error_count + 1;
2800:
2801: OE_Bulk_Order_Pvt.G_ERROR_REC.order_source_id.EXTEND(1);
2802: OE_Bulk_Order_Pvt.G_ERROR_REC.order_source_id(error_count)
2803: := p_header_rec.order_source_id(i);
2804:
2805: OE_Bulk_Order_Pvt.G_ERROR_REC.orig_sys_document_ref.EXTEND(1);

Line 2802: OE_Bulk_Order_Pvt.G_ERROR_REC.order_source_id(error_count)

2798:
2799: error_count := error_count + 1;
2800:
2801: OE_Bulk_Order_Pvt.G_ERROR_REC.order_source_id.EXTEND(1);
2802: OE_Bulk_Order_Pvt.G_ERROR_REC.order_source_id(error_count)
2803: := p_header_rec.order_source_id(i);
2804:
2805: OE_Bulk_Order_Pvt.G_ERROR_REC.orig_sys_document_ref.EXTEND(1);
2806: OE_Bulk_Order_Pvt.G_ERROR_REC.orig_sys_document_ref(error_count)

Line 2805: OE_Bulk_Order_Pvt.G_ERROR_REC.orig_sys_document_ref.EXTEND(1);

2801: OE_Bulk_Order_Pvt.G_ERROR_REC.order_source_id.EXTEND(1);
2802: OE_Bulk_Order_Pvt.G_ERROR_REC.order_source_id(error_count)
2803: := p_header_rec.order_source_id(i);
2804:
2805: OE_Bulk_Order_Pvt.G_ERROR_REC.orig_sys_document_ref.EXTEND(1);
2806: OE_Bulk_Order_Pvt.G_ERROR_REC.orig_sys_document_ref(error_count)
2807: := p_header_rec.orig_sys_document_ref(i);
2808:
2809: OE_Bulk_Order_Pvt.G_ERROR_REC.header_id.EXTEND(1);

Line 2806: OE_Bulk_Order_Pvt.G_ERROR_REC.orig_sys_document_ref(error_count)

2802: OE_Bulk_Order_Pvt.G_ERROR_REC.order_source_id(error_count)
2803: := p_header_rec.order_source_id(i);
2804:
2805: OE_Bulk_Order_Pvt.G_ERROR_REC.orig_sys_document_ref.EXTEND(1);
2806: OE_Bulk_Order_Pvt.G_ERROR_REC.orig_sys_document_ref(error_count)
2807: := p_header_rec.orig_sys_document_ref(i);
2808:
2809: OE_Bulk_Order_Pvt.G_ERROR_REC.header_id.EXTEND(1);
2810: OE_Bulk_Order_Pvt.G_ERROR_REC.header_id(error_count)

Line 2809: OE_Bulk_Order_Pvt.G_ERROR_REC.header_id.EXTEND(1);

2805: OE_Bulk_Order_Pvt.G_ERROR_REC.orig_sys_document_ref.EXTEND(1);
2806: OE_Bulk_Order_Pvt.G_ERROR_REC.orig_sys_document_ref(error_count)
2807: := p_header_rec.orig_sys_document_ref(i);
2808:
2809: OE_Bulk_Order_Pvt.G_ERROR_REC.header_id.EXTEND(1);
2810: OE_Bulk_Order_Pvt.G_ERROR_REC.header_id(error_count)
2811: := p_header_rec.header_id(i);
2812: OE_Bulk_Order_PVT.G_ERROR_REC.ineligible_for_hvop.EXTEND(1);
2813: OE_Bulk_Order_PVT.G_ERROR_REC.skip_batch.EXTEND(1);

Line 2810: OE_Bulk_Order_Pvt.G_ERROR_REC.header_id(error_count)

2806: OE_Bulk_Order_Pvt.G_ERROR_REC.orig_sys_document_ref(error_count)
2807: := p_header_rec.orig_sys_document_ref(i);
2808:
2809: OE_Bulk_Order_Pvt.G_ERROR_REC.header_id.EXTEND(1);
2810: OE_Bulk_Order_Pvt.G_ERROR_REC.header_id(error_count)
2811: := p_header_rec.header_id(i);
2812: OE_Bulk_Order_PVT.G_ERROR_REC.ineligible_for_hvop.EXTEND(1);
2813: OE_Bulk_Order_PVT.G_ERROR_REC.skip_batch.EXTEND(1);
2814:

Line 2812: OE_Bulk_Order_PVT.G_ERROR_REC.ineligible_for_hvop.EXTEND(1);

2808:
2809: OE_Bulk_Order_Pvt.G_ERROR_REC.header_id.EXTEND(1);
2810: OE_Bulk_Order_Pvt.G_ERROR_REC.header_id(error_count)
2811: := p_header_rec.header_id(i);
2812: OE_Bulk_Order_PVT.G_ERROR_REC.ineligible_for_hvop.EXTEND(1);
2813: OE_Bulk_Order_PVT.G_ERROR_REC.skip_batch.EXTEND(1);
2814:
2815: IF p_header_rec.lock_control(i) = -98 THEN
2816: OE_Bulk_Order_PVT.G_ERROR_REC.ineligible_for_hvop(error_count):=

Line 2813: OE_Bulk_Order_PVT.G_ERROR_REC.skip_batch.EXTEND(1);

2809: OE_Bulk_Order_Pvt.G_ERROR_REC.header_id.EXTEND(1);
2810: OE_Bulk_Order_Pvt.G_ERROR_REC.header_id(error_count)
2811: := p_header_rec.header_id(i);
2812: OE_Bulk_Order_PVT.G_ERROR_REC.ineligible_for_hvop.EXTEND(1);
2813: OE_Bulk_Order_PVT.G_ERROR_REC.skip_batch.EXTEND(1);
2814:
2815: IF p_header_rec.lock_control(i) = -98 THEN
2816: OE_Bulk_Order_PVT.G_ERROR_REC.ineligible_for_hvop(error_count):=
2817: 'Y';

Line 2816: OE_Bulk_Order_PVT.G_ERROR_REC.ineligible_for_hvop(error_count):=

2812: OE_Bulk_Order_PVT.G_ERROR_REC.ineligible_for_hvop.EXTEND(1);
2813: OE_Bulk_Order_PVT.G_ERROR_REC.skip_batch.EXTEND(1);
2814:
2815: IF p_header_rec.lock_control(i) = -98 THEN
2816: OE_Bulk_Order_PVT.G_ERROR_REC.ineligible_for_hvop(error_count):=
2817: 'Y';
2818: ELSIF p_header_rec.lock_control(i) = -97 THEN
2819: OE_Bulk_Order_PVT.G_ERROR_REC.skip_batch(error_count):= 'Y';
2820: END IF;

Line 2819: OE_Bulk_Order_PVT.G_ERROR_REC.skip_batch(error_count):= 'Y';

2815: IF p_header_rec.lock_control(i) = -98 THEN
2816: OE_Bulk_Order_PVT.G_ERROR_REC.ineligible_for_hvop(error_count):=
2817: 'Y';
2818: ELSIF p_header_rec.lock_control(i) = -97 THEN
2819: OE_Bulk_Order_PVT.G_ERROR_REC.skip_batch(error_count):= 'Y';
2820: END IF;
2821: END IF;
2822:
2823: END LOOP;