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.OE_HEADER_UTIL dependencies on OE_ORDER_PUB

Line 13: (p_header_rec IN OE_Order_PUB.Header_Rec_Type

9:
10: -- Added 09-DEC-2002
11: -- Forward declaration of LOCAL PROCEDURE Blkt_Req_For_Curr_Upd_And_Del
12: PROCEDURE Blkt_Req_For_Curr_Upd_And_Del
13: (p_header_rec IN OE_Order_PUB.Header_Rec_Type
14: ,p_old_header_rec IN OE_Order_PUB.Header_Rec_Type
15: );
16:
17: --bug 5083663

Line 14: ,p_old_header_rec IN OE_Order_PUB.Header_Rec_Type

10: -- Added 09-DEC-2002
11: -- Forward declaration of LOCAL PROCEDURE Blkt_Req_For_Curr_Upd_And_Del
12: PROCEDURE Blkt_Req_For_Curr_Upd_And_Del
13: (p_header_rec IN OE_Order_PUB.Header_Rec_Type
14: ,p_old_header_rec IN OE_Order_PUB.Header_Rec_Type
15: );
16:
17: --bug 5083663
18: PROCEDURE Set_CC_Selected_From_Lov (p_CC_selected_from_LOV IN VARCHAR2)

Line 1144: ( p_HEADER_rec IN OE_Order_PUB.HEADER_Rec_Type

1140:
1141: END G_MISS_OE_AK_HEADER_REC;
1142:
1143: PROCEDURE API_Rec_To_Rowtype_Rec
1144: ( p_HEADER_rec IN OE_Order_PUB.HEADER_Rec_Type
1145: , x_rowtype_rec IN OUT NOCOPY OE_AK_ORDER_HEADERS_V%ROWTYPE
1146: ) IS
1147: BEGIN
1148:

Line 1341: , x_api_rec IN OUT NOCOPY OE_Order_PUB.HEADER_Rec_Type

1337: END API_Rec_To_RowType_Rec;
1338:
1339: PROCEDURE Rowtype_Rec_To_API_Rec
1340: ( p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1341: , x_api_rec IN OUT NOCOPY OE_Order_PUB.HEADER_Rec_Type
1342: ) IS
1343: BEGIN
1344:
1345: x_api_rec.ACCOUNTING_RULE_ID := p_record.ACCOUNTING_RULE_ID;

Line 1730: , p_x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type

1726: END Clear_Dependent_Attr;
1727:
1728: PROCEDURE Clear_Dependent_Attr
1729: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
1730: , p_x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type
1731: , p_old_header_rec IN OE_Order_PUB.Header_Rec_Type :=
1732: OE_Order_PUB.G_MISS_HEADER_REC
1733: )
1734: IS

Line 1731: , p_old_header_rec IN OE_Order_PUB.Header_Rec_Type :=

1727:
1728: PROCEDURE Clear_Dependent_Attr
1729: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
1730: , p_x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type
1731: , p_old_header_rec IN OE_Order_PUB.Header_Rec_Type :=
1732: OE_Order_PUB.G_MISS_HEADER_REC
1733: )
1734: IS
1735: l_header_rec OE_AK_ORDER_HEADERS_V%ROWTYPE;

Line 1732: OE_Order_PUB.G_MISS_HEADER_REC

1728: PROCEDURE Clear_Dependent_Attr
1729: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
1730: , p_x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type
1731: , p_old_header_rec IN OE_Order_PUB.Header_Rec_Type :=
1732: OE_Order_PUB.G_MISS_HEADER_REC
1733: )
1734: IS
1735: l_header_rec OE_AK_ORDER_HEADERS_V%ROWTYPE;
1736: l_old_header_rec OE_AK_ORDER_HEADERS_V%ROWTYPE;

Line 1761: ( p_x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type

1757:
1758: -- Procedure Apply_Attribute_Changes
1759:
1760: PROCEDURE Apply_Attribute_Changes
1761: ( p_x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type
1762: , p_old_header_rec IN OE_Order_PUB.Header_Rec_Type :=
1763: OE_Order_PUB.G_MISS_HEADER_REC
1764: )
1765: IS

Line 1762: , p_old_header_rec IN OE_Order_PUB.Header_Rec_Type :=

1758: -- Procedure Apply_Attribute_Changes
1759:
1760: PROCEDURE Apply_Attribute_Changes
1761: ( p_x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type
1762: , p_old_header_rec IN OE_Order_PUB.Header_Rec_Type :=
1763: OE_Order_PUB.G_MISS_HEADER_REC
1764: )
1765: IS
1766: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;

Line 1763: OE_Order_PUB.G_MISS_HEADER_REC

1759:
1760: PROCEDURE Apply_Attribute_Changes
1761: ( p_x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type
1762: , p_old_header_rec IN OE_Order_PUB.Header_Rec_Type :=
1763: OE_Order_PUB.G_MISS_HEADER_REC
1764: )
1765: IS
1766: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
1767:

Line 2533: ( p_x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type

2529:
2530: -- Procedure Complete_Record
2531:
2532: PROCEDURE Complete_Record
2533: ( p_x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type
2534: , p_old_header_rec IN OE_Order_PUB.Header_Rec_Type
2535: )
2536: IS
2537:

Line 2534: , p_old_header_rec IN OE_Order_PUB.Header_Rec_Type

2530: -- Procedure Complete_Record
2531:
2532: PROCEDURE Complete_Record
2533: ( p_x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type
2534: , p_old_header_rec IN OE_Order_PUB.Header_Rec_Type
2535: )
2536: IS
2537:
2538: BEGIN

Line 3276: ( p_x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type

3272:
3273: -- Procedure Convert_Miss_To_Null
3274:
3275: PROCEDURE Convert_Miss_To_Null
3276: ( p_x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type
3277: )
3278: IS
3279: --p_x_header_rec OE_Order_PUB.Header_Rec_Type := p_header_rec;
3280: BEGIN

Line 3279: --p_x_header_rec OE_Order_PUB.Header_Rec_Type := p_header_rec;

3275: PROCEDURE Convert_Miss_To_Null
3276: ( p_x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type
3277: )
3278: IS
3279: --p_x_header_rec OE_Order_PUB.Header_Rec_Type := p_header_rec;
3280: BEGIN
3281:
3282: oe_debug_pub.add('Entering OE_HEADER_UTIL.CONVERT_MISS_TO_NULL', 1);
3283:

Line 3946: ( p_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type

3942:
3943: -- Procedure Update_Row
3944:
3945: PROCEDURE Update_Row
3946: ( p_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type
3947: )
3948: IS
3949: l_org_id NUMBER;
3950: l_lock_control NUMBER;

Line 4218: ( p_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type

4214:
4215: -- Procedure Insert_Row
4216:
4217: PROCEDURE Insert_Row
4218: ( p_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type
4219: )
4220: IS
4221: l_org_id NUMBER;
4222: l_upgraded_flag varchar2(1) ;

Line 4669: l_new_header_rec OE_Order_PUB.Header_Rec_Type;

4665: IS
4666: l_return_status VARCHAR2(30);
4667: l_org_id NUMBER;
4668: -- added for notification framework
4669: l_new_header_rec OE_Order_PUB.Header_Rec_Type;
4670: l_index NUMBER;
4671: l_price_request_code VARCHAR2(240); -- BUG 2670775
4672: l_transaction_phase_code VARCHAR2(30);
4673:

Line 4980: ) RETURN OE_Order_PUB.Header_Rec_Type

4976: -- as it has the nocopy option which would improve the performance
4977:
4978: FUNCTION Query_Row
4979: ( p_header_id IN NUMBER
4980: ) RETURN OE_Order_PUB.Header_Rec_Type
4981: IS
4982: l_header_rec OE_Order_PUB.Header_Rec_Type;
4983: BEGIN
4984:

Line 4982: l_header_rec OE_Order_PUB.Header_Rec_Type;

4978: FUNCTION Query_Row
4979: ( p_header_id IN NUMBER
4980: ) RETURN OE_Order_PUB.Header_Rec_Type
4981: IS
4982: l_header_rec OE_Order_PUB.Header_Rec_Type;
4983: BEGIN
4984:
4985: Query_Row
4986: ( p_header_id => p_header_id

Line 4998: x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type

4994: -- Function Query_Row
4995:
4996: PROCEDURE Query_Row
4997: ( p_header_id IN NUMBER,
4998: x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type
4999: )
5000: IS
5001: l_org_id NUMBER;
5002: l_x_header_rec_oper VARCHAR2(30);

Line 5468: , p_x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type

5464: --
5465:
5466: PROCEDURE Lock_Row
5467: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
5468: , p_x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type
5469: , p_header_id IN NUMBER
5470: := FND_API.G_MISS_NUM
5471: )
5472: IS

Line 5629: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type

5625:
5626: -- Function Get_Values
5627:
5628: FUNCTION Get_Values
5629: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type
5630: , p_old_header_rec IN OE_Order_PUB.Header_Rec_Type :=
5631: OE_Order_PUB.G_MISS_HEADER_REC
5632: ) RETURN OE_Order_PUB.Header_Val_Rec_Type
5633: IS

Line 5630: , p_old_header_rec IN OE_Order_PUB.Header_Rec_Type :=

5626: -- Function Get_Values
5627:
5628: FUNCTION Get_Values
5629: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type
5630: , p_old_header_rec IN OE_Order_PUB.Header_Rec_Type :=
5631: OE_Order_PUB.G_MISS_HEADER_REC
5632: ) RETURN OE_Order_PUB.Header_Val_Rec_Type
5633: IS
5634: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;

Line 5631: OE_Order_PUB.G_MISS_HEADER_REC

5627:
5628: FUNCTION Get_Values
5629: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type
5630: , p_old_header_rec IN OE_Order_PUB.Header_Rec_Type :=
5631: OE_Order_PUB.G_MISS_HEADER_REC
5632: ) RETURN OE_Order_PUB.Header_Val_Rec_Type
5633: IS
5634: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
5635: -- FP contracts word integration

Line 5632: ) RETURN OE_Order_PUB.Header_Val_Rec_Type

5628: FUNCTION Get_Values
5629: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type
5630: , p_old_header_rec IN OE_Order_PUB.Header_Rec_Type :=
5631: OE_Order_PUB.G_MISS_HEADER_REC
5632: ) RETURN OE_Order_PUB.Header_Val_Rec_Type
5633: IS
5634: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
5635: -- FP contracts word integration
5636: l_return_status VARCHAR2(30);

Line 5634: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;

5630: , p_old_header_rec IN OE_Order_PUB.Header_Rec_Type :=
5631: OE_Order_PUB.G_MISS_HEADER_REC
5632: ) RETURN OE_Order_PUB.Header_Val_Rec_Type
5633: IS
5634: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
5635: -- FP contracts word integration
5636: l_return_status VARCHAR2(30);
5637: l_msg_count NUMBER;
5638: l_msg_data VARCHAR2(2000);

Line 5643: l_header_val_rec := OE_Order_PUB.G_MISS_HEADER_VAL_REC;

5639: BEGIN
5640:
5641: oe_debug_pub.add('Entering OE_HEADER_UTIL.GET_VALUES', 1);
5642:
5643: l_header_val_rec := OE_Order_PUB.G_MISS_HEADER_VAL_REC;
5644:
5645: IF (p_header_rec.accounting_rule_id IS NULL OR
5646: p_header_rec.accounting_rule_id <> FND_API.G_MISS_NUM) AND
5647: NOT OE_GLOBALS.Equal(p_header_rec.accounting_rule_id,

Line 6170: ( p_x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type

6166:
6167: -- Function Get_Ids
6168:
6169: PROCEDURE Get_Ids
6170: ( p_x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type
6171: , p_header_val_rec IN OE_Order_PUB.Header_Val_Rec_Type
6172: )
6173: IS
6174: l_sold_to_org_id NUMBER;

Line 6171: , p_header_val_rec IN OE_Order_PUB.Header_Val_Rec_Type

6167: -- Function Get_Ids
6168:
6169: PROCEDURE Get_Ids
6170: ( p_x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type
6171: , p_header_val_rec IN OE_Order_PUB.Header_Val_Rec_Type
6172: )
6173: IS
6174: l_sold_to_org_id NUMBER;
6175: l_ship_to_org_id NUMBER;

Line 7749: ( p_x_header_rec IN OUT NOCOPY oe_order_pub.header_rec_type,

7745:
7746: END Get_Order_Type;
7747:
7748: PROCEDURE Get_Order_Number
7749: ( p_x_header_rec IN OUT NOCOPY oe_order_pub.header_rec_type,
7750: p_old_header_rec IN oe_order_pub.header_rec_type )
7751: IS
7752: l_order_number VARCHAR2(30):= NULL;
7753: x_doc_sequence_value NUMBER;

Line 7750: p_old_header_rec IN oe_order_pub.header_rec_type )

7746: END Get_Order_Type;
7747:
7748: PROCEDURE Get_Order_Number
7749: ( p_x_header_rec IN OUT NOCOPY oe_order_pub.header_rec_type,
7750: p_old_header_rec IN oe_order_pub.header_rec_type )
7751: IS
7752: l_order_number VARCHAR2(30):= NULL;
7753: x_doc_sequence_value NUMBER;
7754: x_doc_category_code VARCHAR(30);

Line 8127: ( p_x_header_rec IN OUT NOCOPY oe_order_pub.header_rec_type,

8123: --7688372 end
8124:
8125:
8126: PROCEDURE Pre_Write_Process
8127: ( p_x_header_rec IN OUT NOCOPY oe_order_pub.header_rec_type,
8128: p_old_header_rec IN oe_order_pub.header_rec_type )
8129: IS
8130: -- included to fix bug 1589196 Begin
8131: CURSOR C_HSC_COUNT(t_header_id Number) IS

Line 8128: p_old_header_rec IN oe_order_pub.header_rec_type )

8124:
8125:
8126: PROCEDURE Pre_Write_Process
8127: ( p_x_header_rec IN OUT NOCOPY oe_order_pub.header_rec_type,
8128: p_old_header_rec IN oe_order_pub.header_rec_type )
8129: IS
8130: -- included to fix bug 1589196 Begin
8131: CURSOR C_HSC_COUNT(t_header_id Number) IS
8132: SELECT count(sales_credit_id), max(sales_credit_id)

Line 8145: p_x_old_header_rec OE_ORDER_PUB.Header_Rec_Type:= p_old_header_rec ;

8141: l_return_status VARCHAR2(30);
8142: l_count NUMBER;
8143: /* Variables to call process order */
8144: l_control_rec OE_GLOBALS.Control_Rec_Type;
8145: p_x_old_header_rec OE_ORDER_PUB.Header_Rec_Type:= p_old_header_rec ;
8146: l_msg_count NUMBER;
8147: l_msg_data VARCHAR2(2000);
8148: l_new_order_type varchar2(80);
8149: l_order_type varchar2(80);

Line 8161: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;

8157: l_reason_comments VARCHAR2(2000);
8158: --bug 4190357
8159: v_count NUMBER;
8160: l_meaning VARCHAR2(80);
8161: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
8162: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
8163: i Number;
8164: j Number := 0;
8165: lx_line_rec OE_Order_PUB.Line_Rec_Type;

Line 8162: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

8158: --bug 4190357
8159: v_count NUMBER;
8160: l_meaning VARCHAR2(80);
8161: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
8162: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
8163: i Number;
8164: j Number := 0;
8165: lx_line_rec OE_Order_PUB.Line_Rec_Type;
8166: l_apply_automatic_atchmt VARCHAR2(1) :=

Line 8165: lx_line_rec OE_Order_PUB.Line_Rec_Type;

8161: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
8162: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
8163: i Number;
8164: j Number := 0;
8165: lx_line_rec OE_Order_PUB.Line_Rec_Type;
8166: l_apply_automatic_atchmt VARCHAR2(1) :=
8167: NVL(FND_PROFILE.VALUE('OE_APPLY_AUTOMATIC_ATCHMT'),'Y') ; --5893276
8168:
8169: cursor line_ids(p_header_id IN NUMBER) is

Line 8893: ( p_x_header_rec IN OUT NOCOPY oe_order_pub.header_rec_type,

8889:
8890: End Pre_Write_Process;
8891:
8892: PROCEDURE Post_Write_Process
8893: ( p_x_header_rec IN OUT NOCOPY oe_order_pub.header_rec_type,
8894: p_old_header_rec IN oe_order_pub.header_rec_type )
8895: IS
8896: l_return_status VARCHAR2(30);
8897: l_msg_count NUMBER;

Line 8894: p_old_header_rec IN oe_order_pub.header_rec_type )

8890: End Pre_Write_Process;
8891:
8892: PROCEDURE Post_Write_Process
8893: ( p_x_header_rec IN OUT NOCOPY oe_order_pub.header_rec_type,
8894: p_old_header_rec IN oe_order_pub.header_rec_type )
8895: IS
8896: l_return_status VARCHAR2(30);
8897: l_msg_count NUMBER;
8898: l_msg_data VARCHAR2(2000);

Line 8901: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;

8897: l_msg_count NUMBER;
8898: l_msg_data VARCHAR2(2000);
8899:
8900: l_control_rec OE_GLOBALS.Control_Rec_Type;
8901: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
8902: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
8903: l_recursion_mode VARCHAR2(1);
8904: l_operation VARCHAR2(30);
8905: --R12 CC Encryption

Line 8902: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

8898: l_msg_data VARCHAR2(2000);
8899:
8900: l_control_rec OE_GLOBALS.Control_Rec_Type;
8901: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
8902: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
8903: l_recursion_mode VARCHAR2(1);
8904: l_operation VARCHAR2(30);
8905: --R12 CC Encryption
8906: l_x_Header_Payment_tbl OE_ORDER_PUB.Header_Payment_tbl_type;

Line 8906: l_x_Header_Payment_tbl OE_ORDER_PUB.Header_Payment_tbl_type;

8902: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
8903: l_recursion_mode VARCHAR2(1);
8904: l_operation VARCHAR2(30);
8905: --R12 CC Encryption
8906: l_x_Header_Payment_tbl OE_ORDER_PUB.Header_Payment_tbl_type;
8907: l_x_old_Header_Payment_tbl OE_ORDER_PUB.Header_Payment_tbl_type;
8908: l_payment_exists VARCHAR2(1) := 'N';
8909: l_payment_number NUMBER;
8910: l_old_payment_type_code VARCHAR2(30) := NULL;

Line 8907: l_x_old_Header_Payment_tbl OE_ORDER_PUB.Header_Payment_tbl_type;

8903: l_recursion_mode VARCHAR2(1);
8904: l_operation VARCHAR2(30);
8905: --R12 CC Encryption
8906: l_x_Header_Payment_tbl OE_ORDER_PUB.Header_Payment_tbl_type;
8907: l_x_old_Header_Payment_tbl OE_ORDER_PUB.Header_Payment_tbl_type;
8908: l_payment_exists VARCHAR2(1) := 'N';
8909: l_payment_number NUMBER;
8910: l_old_payment_type_code VARCHAR2(30) := NULL;
8911: --R12 CC Encryption

Line 9377: l_x_Header_Payment_tbl(1):=OE_ORDER_PUB.G_MISS_HEADER_PAYMENT_REC;

9373: l_control_rec.process := FALSE;
9374: l_control_rec.clear_api_cache := FALSE;
9375: l_control_rec.clear_api_requests := FALSE;
9376:
9377: l_x_Header_Payment_tbl(1):=OE_ORDER_PUB.G_MISS_HEADER_PAYMENT_REC;
9378: l_x_old_Header_Payment_Tbl(1):=OE_ORDER_PUB.G_MISS_HEADER_PAYMENT_REC;
9379:
9380: l_x_Header_Payment_tbl(1).header_id := p_x_header_rec.header_id;
9381: l_x_Header_Payment_tbl(1).payment_collection_event := 'INVOICE';

Line 9378: l_x_old_Header_Payment_Tbl(1):=OE_ORDER_PUB.G_MISS_HEADER_PAYMENT_REC;

9374: l_control_rec.clear_api_cache := FALSE;
9375: l_control_rec.clear_api_requests := FALSE;
9376:
9377: l_x_Header_Payment_tbl(1):=OE_ORDER_PUB.G_MISS_HEADER_PAYMENT_REC;
9378: l_x_old_Header_Payment_Tbl(1):=OE_ORDER_PUB.G_MISS_HEADER_PAYMENT_REC;
9379:
9380: l_x_Header_Payment_tbl(1).header_id := p_x_header_rec.header_id;
9381: l_x_Header_Payment_tbl(1).payment_collection_event := 'INVOICE';
9382: l_x_Header_Payment_tbl(1).payment_level_code := 'ORDER';

Line 9502: l_x_Header_Payment_tbl(2):=OE_ORDER_PUB.G_MISS_HEADER_PAYMENT_REC;

9498: oe_debug_pub.add('Payment number value...'||l_payment_number);
9499: oe_debug_pub.add('Header id ----> '||p_x_header_rec.header_id);
9500: END IF;
9501:
9502: l_x_Header_Payment_tbl(2):=OE_ORDER_PUB.G_MISS_HEADER_PAYMENT_REC;
9503: l_x_old_Header_Payment_Tbl(2):=OE_ORDER_PUB.G_MISS_HEADER_PAYMENT_REC;
9504:
9505: l_x_Header_Payment_tbl(2).header_id := p_x_header_rec.header_id;
9506: l_x_Header_Payment_tbl(2).payment_collection_event := 'PREPAY';

Line 9503: l_x_old_Header_Payment_Tbl(2):=OE_ORDER_PUB.G_MISS_HEADER_PAYMENT_REC;

9499: oe_debug_pub.add('Header id ----> '||p_x_header_rec.header_id);
9500: END IF;
9501:
9502: l_x_Header_Payment_tbl(2):=OE_ORDER_PUB.G_MISS_HEADER_PAYMENT_REC;
9503: l_x_old_Header_Payment_Tbl(2):=OE_ORDER_PUB.G_MISS_HEADER_PAYMENT_REC;
9504:
9505: l_x_Header_Payment_tbl(2).header_id := p_x_header_rec.header_id;
9506: l_x_Header_Payment_tbl(2).payment_collection_event := 'PREPAY';
9507: l_x_Header_Payment_tbl(2).payment_level_code := 'ORDER';

Line 9768: (p_header_rec IN OE_Order_PUB.Header_Rec_Type

9764: --Changed the Function name from Blanket_Req_For_Curr_Update
9765: --Added code to mask logging Validate shipment and Incrementing amounts for delete
9766:
9767: PROCEDURE Blkt_Req_For_Curr_Upd_And_Del
9768: (p_header_rec IN OE_Order_PUB.Header_Rec_Type
9769: ,p_old_header_rec IN OE_Order_PUB.Header_Rec_Type
9770: )
9771: IS
9772:

Line 9769: ,p_old_header_rec IN OE_Order_PUB.Header_Rec_Type

9765: --Added code to mask logging Validate shipment and Incrementing amounts for delete
9766:
9767: PROCEDURE Blkt_Req_For_Curr_Upd_And_Del
9768: (p_header_rec IN OE_Order_PUB.Header_Rec_Type
9769: ,p_old_header_rec IN OE_Order_PUB.Header_Rec_Type
9770: )
9771: IS
9772:
9773: CURSOR lines IS

Line 9912: ( p_header_customer_info_tbl IN OUT NOCOPY OE_Order_Pub.CUSTOMER_INFO_TABLE_TYPE,

9908:
9909:
9910: --ER7675548
9911: Procedure Get_customer_info_ids
9912: ( p_header_customer_info_tbl IN OUT NOCOPY OE_Order_Pub.CUSTOMER_INFO_TABLE_TYPE,
9913: p_x_header_rec IN OUT NOCOPY OE_Order_Pub.Header_Rec_Type,
9914: x_return_status OUT NOCOPY VARCHAR2,
9915: x_msg_count OUT NOCOPY NUMBER,
9916: x_msg_data OUT NOCOPY VARCHAR2

Line 9913: p_x_header_rec IN OUT NOCOPY OE_Order_Pub.Header_Rec_Type,

9909:
9910: --ER7675548
9911: Procedure Get_customer_info_ids
9912: ( p_header_customer_info_tbl IN OUT NOCOPY OE_Order_Pub.CUSTOMER_INFO_TABLE_TYPE,
9913: p_x_header_rec IN OUT NOCOPY OE_Order_Pub.Header_Rec_Type,
9914: x_return_status OUT NOCOPY VARCHAR2,
9915: x_msg_count OUT NOCOPY NUMBER,
9916: x_msg_data OUT NOCOPY VARCHAR2
9917: )IS