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 1113: ( p_HEADER_rec IN OE_Order_PUB.HEADER_Rec_Type

1109:
1110: END G_MISS_OE_AK_HEADER_REC;
1111:
1112: PROCEDURE API_Rec_To_Rowtype_Rec
1113: ( p_HEADER_rec IN OE_Order_PUB.HEADER_Rec_Type
1114: , x_rowtype_rec IN OUT NOCOPY OE_AK_ORDER_HEADERS_V%ROWTYPE
1115: ) IS
1116: BEGIN
1117:

Line 1310: , x_api_rec IN OUT NOCOPY OE_Order_PUB.HEADER_Rec_Type

1306: END API_Rec_To_RowType_Rec;
1307:
1308: PROCEDURE Rowtype_Rec_To_API_Rec
1309: ( p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1310: , x_api_rec IN OUT NOCOPY OE_Order_PUB.HEADER_Rec_Type
1311: ) IS
1312: BEGIN
1313:
1314: x_api_rec.ACCOUNTING_RULE_ID := p_record.ACCOUNTING_RULE_ID;

Line 1699: , p_x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type

1695: END Clear_Dependent_Attr;
1696:
1697: PROCEDURE Clear_Dependent_Attr
1698: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
1699: , p_x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type
1700: , p_old_header_rec IN OE_Order_PUB.Header_Rec_Type :=
1701: OE_Order_PUB.G_MISS_HEADER_REC
1702: )
1703: IS

Line 1700: , p_old_header_rec IN OE_Order_PUB.Header_Rec_Type :=

1696:
1697: PROCEDURE Clear_Dependent_Attr
1698: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
1699: , p_x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type
1700: , p_old_header_rec IN OE_Order_PUB.Header_Rec_Type :=
1701: OE_Order_PUB.G_MISS_HEADER_REC
1702: )
1703: IS
1704: l_header_rec OE_AK_ORDER_HEADERS_V%ROWTYPE;

Line 1701: OE_Order_PUB.G_MISS_HEADER_REC

1697: PROCEDURE Clear_Dependent_Attr
1698: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
1699: , p_x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type
1700: , p_old_header_rec IN OE_Order_PUB.Header_Rec_Type :=
1701: OE_Order_PUB.G_MISS_HEADER_REC
1702: )
1703: IS
1704: l_header_rec OE_AK_ORDER_HEADERS_V%ROWTYPE;
1705: l_old_header_rec OE_AK_ORDER_HEADERS_V%ROWTYPE;

Line 1730: ( p_x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type

1726:
1727: -- Procedure Apply_Attribute_Changes
1728:
1729: PROCEDURE Apply_Attribute_Changes
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: -- Procedure Apply_Attribute_Changes
1728:
1729: PROCEDURE Apply_Attribute_Changes
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_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;

Line 1732: OE_Order_PUB.G_MISS_HEADER_REC

1728:
1729: PROCEDURE Apply_Attribute_Changes
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_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
1736:

Line 2414: ( p_x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type

2410:
2411: -- Procedure Complete_Record
2412:
2413: PROCEDURE Complete_Record
2414: ( p_x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type
2415: , p_old_header_rec IN OE_Order_PUB.Header_Rec_Type
2416: )
2417: IS
2418:

Line 2415: , p_old_header_rec IN OE_Order_PUB.Header_Rec_Type

2411: -- Procedure Complete_Record
2412:
2413: PROCEDURE Complete_Record
2414: ( p_x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type
2415: , p_old_header_rec IN OE_Order_PUB.Header_Rec_Type
2416: )
2417: IS
2418:
2419: BEGIN

Line 3141: ( p_x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type

3137:
3138: -- Procedure Convert_Miss_To_Null
3139:
3140: PROCEDURE Convert_Miss_To_Null
3141: ( p_x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type
3142: )
3143: IS
3144: --p_x_header_rec OE_Order_PUB.Header_Rec_Type := p_header_rec;
3145: BEGIN

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

3140: PROCEDURE Convert_Miss_To_Null
3141: ( p_x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type
3142: )
3143: IS
3144: --p_x_header_rec OE_Order_PUB.Header_Rec_Type := p_header_rec;
3145: BEGIN
3146:
3147: oe_debug_pub.add('Entering OE_HEADER_UTIL.CONVERT_MISS_TO_NULL', 1);
3148:

Line 3797: ( p_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type

3793:
3794: -- Procedure Update_Row
3795:
3796: PROCEDURE Update_Row
3797: ( p_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type
3798: )
3799: IS
3800: l_org_id NUMBER;
3801: l_lock_control NUMBER;

Line 4069: ( p_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type

4065:
4066: -- Procedure Insert_Row
4067:
4068: PROCEDURE Insert_Row
4069: ( p_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type
4070: )
4071: IS
4072: l_org_id NUMBER;
4073: l_upgraded_flag varchar2(1) ;

Line 4520: l_new_header_rec OE_Order_PUB.Header_Rec_Type;

4516: IS
4517: l_return_status VARCHAR2(30);
4518: l_org_id NUMBER;
4519: -- added for notification framework
4520: l_new_header_rec OE_Order_PUB.Header_Rec_Type;
4521: l_index NUMBER;
4522: l_price_request_code VARCHAR2(240); -- BUG 2670775
4523: l_transaction_phase_code VARCHAR2(30);
4524:

Line 4830: ) RETURN OE_Order_PUB.Header_Rec_Type

4826: -- as it has the nocopy option which would improve the performance
4827:
4828: FUNCTION Query_Row
4829: ( p_header_id IN NUMBER
4830: ) RETURN OE_Order_PUB.Header_Rec_Type
4831: IS
4832: l_header_rec OE_Order_PUB.Header_Rec_Type;
4833: BEGIN
4834:

Line 4832: l_header_rec OE_Order_PUB.Header_Rec_Type;

4828: FUNCTION Query_Row
4829: ( p_header_id IN NUMBER
4830: ) RETURN OE_Order_PUB.Header_Rec_Type
4831: IS
4832: l_header_rec OE_Order_PUB.Header_Rec_Type;
4833: BEGIN
4834:
4835: Query_Row
4836: ( p_header_id => p_header_id

Line 4848: x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type

4844: -- Function Query_Row
4845:
4846: PROCEDURE Query_Row
4847: ( p_header_id IN NUMBER,
4848: x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type
4849: )
4850: IS
4851: l_org_id NUMBER;
4852: l_x_header_rec_oper VARCHAR2(30);

Line 5318: , p_x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type

5314: --
5315:
5316: PROCEDURE Lock_Row
5317: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
5318: , p_x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type
5319: , p_header_id IN NUMBER
5320: := FND_API.G_MISS_NUM
5321: )
5322: IS

Line 5479: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type

5475:
5476: -- Function Get_Values
5477:
5478: FUNCTION Get_Values
5479: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type
5480: , p_old_header_rec IN OE_Order_PUB.Header_Rec_Type :=
5481: OE_Order_PUB.G_MISS_HEADER_REC
5482: ) RETURN OE_Order_PUB.Header_Val_Rec_Type
5483: IS

Line 5480: , p_old_header_rec IN OE_Order_PUB.Header_Rec_Type :=

5476: -- Function Get_Values
5477:
5478: FUNCTION Get_Values
5479: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type
5480: , p_old_header_rec IN OE_Order_PUB.Header_Rec_Type :=
5481: OE_Order_PUB.G_MISS_HEADER_REC
5482: ) RETURN OE_Order_PUB.Header_Val_Rec_Type
5483: IS
5484: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;

Line 5481: OE_Order_PUB.G_MISS_HEADER_REC

5477:
5478: FUNCTION Get_Values
5479: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type
5480: , p_old_header_rec IN OE_Order_PUB.Header_Rec_Type :=
5481: OE_Order_PUB.G_MISS_HEADER_REC
5482: ) RETURN OE_Order_PUB.Header_Val_Rec_Type
5483: IS
5484: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
5485: -- FP contracts word integration

Line 5482: ) RETURN OE_Order_PUB.Header_Val_Rec_Type

5478: FUNCTION Get_Values
5479: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type
5480: , p_old_header_rec IN OE_Order_PUB.Header_Rec_Type :=
5481: OE_Order_PUB.G_MISS_HEADER_REC
5482: ) RETURN OE_Order_PUB.Header_Val_Rec_Type
5483: IS
5484: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
5485: -- FP contracts word integration
5486: l_return_status VARCHAR2(30);

Line 5484: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;

5480: , p_old_header_rec IN OE_Order_PUB.Header_Rec_Type :=
5481: OE_Order_PUB.G_MISS_HEADER_REC
5482: ) RETURN OE_Order_PUB.Header_Val_Rec_Type
5483: IS
5484: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
5485: -- FP contracts word integration
5486: l_return_status VARCHAR2(30);
5487: l_msg_count NUMBER;
5488: l_msg_data VARCHAR2(2000);

Line 5493: l_header_val_rec := OE_Order_PUB.G_MISS_HEADER_VAL_REC;

5489: BEGIN
5490:
5491: oe_debug_pub.add('Entering OE_HEADER_UTIL.GET_VALUES', 1);
5492:
5493: l_header_val_rec := OE_Order_PUB.G_MISS_HEADER_VAL_REC;
5494:
5495: IF (p_header_rec.accounting_rule_id IS NULL OR
5496: p_header_rec.accounting_rule_id <> FND_API.G_MISS_NUM) AND
5497: NOT OE_GLOBALS.Equal(p_header_rec.accounting_rule_id,

Line 6020: ( p_x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type

6016:
6017: -- Function Get_Ids
6018:
6019: PROCEDURE Get_Ids
6020: ( p_x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type
6021: , p_header_val_rec IN OE_Order_PUB.Header_Val_Rec_Type
6022: )
6023: IS
6024: l_sold_to_org_id NUMBER;

Line 6021: , p_header_val_rec IN OE_Order_PUB.Header_Val_Rec_Type

6017: -- Function Get_Ids
6018:
6019: PROCEDURE Get_Ids
6020: ( p_x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type
6021: , p_header_val_rec IN OE_Order_PUB.Header_Val_Rec_Type
6022: )
6023: IS
6024: l_sold_to_org_id NUMBER;
6025: l_ship_to_org_id NUMBER;

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

7593:
7594: END Get_Order_Type;
7595:
7596: PROCEDURE Get_Order_Number
7597: ( p_x_header_rec IN OUT NOCOPY oe_order_pub.header_rec_type,
7598: p_old_header_rec IN oe_order_pub.header_rec_type )
7599: IS
7600: l_order_number VARCHAR2(30):= NULL;
7601: x_doc_sequence_value NUMBER;

Line 7598: p_old_header_rec IN oe_order_pub.header_rec_type )

7594: END Get_Order_Type;
7595:
7596: PROCEDURE Get_Order_Number
7597: ( p_x_header_rec IN OUT NOCOPY oe_order_pub.header_rec_type,
7598: p_old_header_rec IN oe_order_pub.header_rec_type )
7599: IS
7600: l_order_number VARCHAR2(30):= NULL;
7601: x_doc_sequence_value NUMBER;
7602: x_doc_category_code VARCHAR(30);

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

7940:
7941: END Get_Base_Order_Type;
7942:
7943: PROCEDURE Pre_Write_Process
7944: ( p_x_header_rec IN OUT NOCOPY oe_order_pub.header_rec_type,
7945: p_old_header_rec IN oe_order_pub.header_rec_type )
7946: IS
7947: -- included to fix bug 1589196 Begin
7948: CURSOR C_HSC_COUNT(t_header_id Number) IS

Line 7945: p_old_header_rec IN oe_order_pub.header_rec_type )

7941: END Get_Base_Order_Type;
7942:
7943: PROCEDURE Pre_Write_Process
7944: ( p_x_header_rec IN OUT NOCOPY oe_order_pub.header_rec_type,
7945: p_old_header_rec IN oe_order_pub.header_rec_type )
7946: IS
7947: -- included to fix bug 1589196 Begin
7948: CURSOR C_HSC_COUNT(t_header_id Number) IS
7949: SELECT count(sales_credit_id), max(sales_credit_id)

Line 7962: p_x_old_header_rec OE_ORDER_PUB.Header_Rec_Type:= p_old_header_rec ;

7958: l_return_status VARCHAR2(30);
7959: l_count NUMBER;
7960: /* Variables to call process order */
7961: l_control_rec OE_GLOBALS.Control_Rec_Type;
7962: p_x_old_header_rec OE_ORDER_PUB.Header_Rec_Type:= p_old_header_rec ;
7963: l_msg_count NUMBER;
7964: l_msg_data VARCHAR2(2000);
7965: l_new_order_type varchar2(80);
7966: l_order_type varchar2(80);

Line 7978: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;

7974: l_reason_comments VARCHAR2(2000);
7975: --bug 4190357
7976: v_count NUMBER;
7977: l_meaning VARCHAR2(80);
7978: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
7979: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
7980: i Number;
7981: j Number := 0;
7982: lx_line_rec OE_Order_PUB.Line_Rec_Type;

Line 7979: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

7975: --bug 4190357
7976: v_count NUMBER;
7977: l_meaning VARCHAR2(80);
7978: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
7979: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
7980: i Number;
7981: j Number := 0;
7982: lx_line_rec OE_Order_PUB.Line_Rec_Type;
7983: l_apply_automatic_atchmt VARCHAR2(1) :=

Line 7982: lx_line_rec OE_Order_PUB.Line_Rec_Type;

7978: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
7979: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
7980: i Number;
7981: j Number := 0;
7982: lx_line_rec OE_Order_PUB.Line_Rec_Type;
7983: l_apply_automatic_atchmt VARCHAR2(1) :=
7984: NVL(FND_PROFILE.VALUE('OE_APPLY_AUTOMATIC_ATCHMT'),'Y') ; --5893276
7985:
7986: cursor line_ids(p_header_id IN NUMBER) is

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

8696:
8697: End Pre_Write_Process;
8698:
8699: PROCEDURE Post_Write_Process
8700: ( p_x_header_rec IN OUT NOCOPY oe_order_pub.header_rec_type,
8701: p_old_header_rec IN oe_order_pub.header_rec_type )
8702: IS
8703: l_return_status VARCHAR2(30);
8704: l_msg_count NUMBER;

Line 8701: p_old_header_rec IN oe_order_pub.header_rec_type )

8697: End Pre_Write_Process;
8698:
8699: PROCEDURE Post_Write_Process
8700: ( p_x_header_rec IN OUT NOCOPY oe_order_pub.header_rec_type,
8701: p_old_header_rec IN oe_order_pub.header_rec_type )
8702: IS
8703: l_return_status VARCHAR2(30);
8704: l_msg_count NUMBER;
8705: l_msg_data VARCHAR2(2000);

Line 8708: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;

8704: l_msg_count NUMBER;
8705: l_msg_data VARCHAR2(2000);
8706:
8707: l_control_rec OE_GLOBALS.Control_Rec_Type;
8708: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
8709: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
8710: l_recursion_mode VARCHAR2(1);
8711: l_operation VARCHAR2(30);
8712: --R12 CC Encryption

Line 8709: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

8705: l_msg_data VARCHAR2(2000);
8706:
8707: l_control_rec OE_GLOBALS.Control_Rec_Type;
8708: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
8709: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
8710: l_recursion_mode VARCHAR2(1);
8711: l_operation VARCHAR2(30);
8712: --R12 CC Encryption
8713: l_x_Header_Payment_tbl OE_ORDER_PUB.Header_Payment_tbl_type;

Line 8713: l_x_Header_Payment_tbl OE_ORDER_PUB.Header_Payment_tbl_type;

8709: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
8710: l_recursion_mode VARCHAR2(1);
8711: l_operation VARCHAR2(30);
8712: --R12 CC Encryption
8713: l_x_Header_Payment_tbl OE_ORDER_PUB.Header_Payment_tbl_type;
8714: l_x_old_Header_Payment_tbl OE_ORDER_PUB.Header_Payment_tbl_type;
8715: l_payment_exists VARCHAR2(1) := 'N';
8716: l_payment_number NUMBER;
8717: l_old_payment_type_code VARCHAR2(30) := NULL;

Line 8714: l_x_old_Header_Payment_tbl OE_ORDER_PUB.Header_Payment_tbl_type;

8710: l_recursion_mode VARCHAR2(1);
8711: l_operation VARCHAR2(30);
8712: --R12 CC Encryption
8713: l_x_Header_Payment_tbl OE_ORDER_PUB.Header_Payment_tbl_type;
8714: l_x_old_Header_Payment_tbl OE_ORDER_PUB.Header_Payment_tbl_type;
8715: l_payment_exists VARCHAR2(1) := 'N';
8716: l_payment_number NUMBER;
8717: l_old_payment_type_code VARCHAR2(30) := NULL;
8718: --R12 CC Encryption

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

9155: l_control_rec.process := FALSE;
9156: l_control_rec.clear_api_cache := FALSE;
9157: l_control_rec.clear_api_requests := FALSE;
9158:
9159: l_x_Header_Payment_tbl(1):=OE_ORDER_PUB.G_MISS_HEADER_PAYMENT_REC;
9160: l_x_old_Header_Payment_Tbl(1):=OE_ORDER_PUB.G_MISS_HEADER_PAYMENT_REC;
9161:
9162: l_x_Header_Payment_tbl(1).header_id := p_x_header_rec.header_id;
9163: l_x_Header_Payment_tbl(1).payment_collection_event := 'INVOICE';

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

9156: l_control_rec.clear_api_cache := FALSE;
9157: l_control_rec.clear_api_requests := FALSE;
9158:
9159: l_x_Header_Payment_tbl(1):=OE_ORDER_PUB.G_MISS_HEADER_PAYMENT_REC;
9160: l_x_old_Header_Payment_Tbl(1):=OE_ORDER_PUB.G_MISS_HEADER_PAYMENT_REC;
9161:
9162: l_x_Header_Payment_tbl(1).header_id := p_x_header_rec.header_id;
9163: l_x_Header_Payment_tbl(1).payment_collection_event := 'INVOICE';
9164: l_x_Header_Payment_tbl(1).payment_level_code := 'ORDER';

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

9280: oe_debug_pub.add('Payment number value...'||l_payment_number);
9281: oe_debug_pub.add('Header id ----> '||p_x_header_rec.header_id);
9282: END IF;
9283:
9284: l_x_Header_Payment_tbl(2):=OE_ORDER_PUB.G_MISS_HEADER_PAYMENT_REC;
9285: l_x_old_Header_Payment_Tbl(2):=OE_ORDER_PUB.G_MISS_HEADER_PAYMENT_REC;
9286:
9287: l_x_Header_Payment_tbl(2).header_id := p_x_header_rec.header_id;
9288: l_x_Header_Payment_tbl(2).payment_collection_event := 'PREPAY';

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

9281: oe_debug_pub.add('Header id ----> '||p_x_header_rec.header_id);
9282: END IF;
9283:
9284: l_x_Header_Payment_tbl(2):=OE_ORDER_PUB.G_MISS_HEADER_PAYMENT_REC;
9285: l_x_old_Header_Payment_Tbl(2):=OE_ORDER_PUB.G_MISS_HEADER_PAYMENT_REC;
9286:
9287: l_x_Header_Payment_tbl(2).header_id := p_x_header_rec.header_id;
9288: l_x_Header_Payment_tbl(2).payment_collection_event := 'PREPAY';
9289: l_x_Header_Payment_tbl(2).payment_level_code := 'ORDER';

Line 9549: (p_header_rec IN OE_Order_PUB.Header_Rec_Type

9545: --Changed the Function name from Blanket_Req_For_Curr_Update
9546: --Added code to mask logging Validate shipment and Incrementing amounts for delete
9547:
9548: PROCEDURE Blkt_Req_For_Curr_Upd_And_Del
9549: (p_header_rec IN OE_Order_PUB.Header_Rec_Type
9550: ,p_old_header_rec IN OE_Order_PUB.Header_Rec_Type
9551: )
9552: IS
9553:

Line 9550: ,p_old_header_rec IN OE_Order_PUB.Header_Rec_Type

9546: --Added code to mask logging Validate shipment and Incrementing amounts for delete
9547:
9548: PROCEDURE Blkt_Req_For_Curr_Upd_And_Del
9549: (p_header_rec IN OE_Order_PUB.Header_Rec_Type
9550: ,p_old_header_rec IN OE_Order_PUB.Header_Rec_Type
9551: )
9552: IS
9553:
9554: CURSOR lines IS