DBA Data[Home] [Help]

APPS.OE_MASS_CHANGE_PVT dependencies on OE_GLOBALS

Line 5: g_sel_rec_tbl OE_GLOBALS.Selected_Record_Tbl;

1: PACKAGE BODY OE_MASS_CHANGE_PVT AS
2: /* $Header: OEXVMSCB.pls 120.18.12020000.2 2013/01/07 13:31:03 sujithku ship $ */
3:
4: -- 4020312
5: g_sel_rec_tbl OE_GLOBALS.Selected_Record_Tbl;
6:
7: --bug4529937 start
8: G_BLK_NAME VARCHAR2(30);
9: G_NUM_OF_LINES NUMBER;

Line 70: , p_sel_rec_tbl IN Oe_Globals.Selected_Record_Tbl

66:
67: Procedure Process_Order_Scalar
68:
69: ( p_num_of_records IN NUMBER
70: , p_sel_rec_tbl IN Oe_Globals.Selected_Record_Tbl
71: , p_multi_OU IN Boolean
72: --, p_record_ids IN VARCHAR2
73: , p_change_reason IN VARCHAR2
74: , p_change_comments IN VARCHAR2

Line 280: l_control_rec OE_GLOBALS.Control_Rec_Type;

276:
277: ) IS
278: l_header_rec OE_Order_PUB.Header_Rec_Type;
279: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
280: l_control_rec OE_GLOBALS.Control_Rec_Type;
281: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
282: l_mc_err_handling_flag NUMBER := p_mc_err_handling_flag ;
283: l_init_msg_list VARCHAR2(1) := 'F';
284: l_return_status VARCHAR2(30);

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

327: -- initial := nextpos + 1;
328: /* j := j + 1;
329: nextpos := INSTR(p_record_ids,',',1,j);
330: */
331: l_header_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
332: l_header_rec.header_id := l_header_id;
333: -- l_old_header_rec.header_id := l_header_id;
334:
335: SAVEPOINT Process_Order_Scalar;

Line 910: l_control_rec.process_entity:=OE_GLOBALS.G_ENTITY_ALL;

906:
907:
908: l_control_rec.controlled_operation:=TRUE;
909: l_control_rec.process:=FALSE;
910: l_control_rec.process_entity:=OE_GLOBALS.G_ENTITY_ALL;
911:
912: --added for bug 4882981
913: l_control_rec.check_security := TRUE;
914: l_control_rec.clear_dependents := TRUE;

Line 1022: l_control_rec.process_entity := OE_GLOBALS.G_ENTITY_ALL;

1018: /*
1019:
1020: l_control_rec.controlled_operation := TRUE;
1021: l_control_rec.process := TRUE;
1022: l_control_rec.process_entity := OE_GLOBALS.G_ENTITY_ALL;
1023:
1024: l_control_rec.check_security := FALSE;
1025: l_control_rec.clear_dependents := FALSE;
1026: l_control_rec.default_attributes := FALSE;

Line 1170: , p_sel_rec_tbl IN Oe_Globals.Selected_Record_Tbl --MOAC PI

1166: -- OE_ORDER_PVT.Lines so that lines belonging together like models and sets go
1167: -- for processing at one go.
1168: Procedure Process_Line_Scalar
1169: ( p_num_of_records IN NUMBER
1170: , p_sel_rec_tbl IN Oe_Globals.Selected_Record_Tbl --MOAC PI
1171: , p_multi_OU IN Boolean --MOAC PI
1172: , p_change_reason IN VARCHAR2
1173: , p_change_comments IN VARCHAR2
1174: , p_msg_count OUT NOCOPY NUMBER

Line 1527: l_control_rec OE_GLOBALS.Control_Rec_Type;

1523: initial Integer;
1524: j Integer;
1525: l_api_name CONSTANT VARCHAR2(30) := 'Process_Line_Scalar';
1526: l_arrival_set_id number;
1527: l_control_rec OE_GLOBALS.Control_Rec_Type;
1528: l_counter Integer := 0;
1529: l_current_org_id Number;
1530: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1531: l_error_count NUMBER := 0;

Line 1754: l_line_tbl(l_rec).operation := OE_GLOBALS.G_OPR_UPDATE;

1750: end loop; --End of bug# 13067303
1751: RAISE FND_API.G_EXC_ERROR;
1752: END IF;
1753:
1754: l_line_tbl(l_rec).operation := OE_GLOBALS.G_OPR_UPDATE;
1755:
1756: if p_ordered_quantity is NOT NULL then
1757: l_line_tbl(l_rec).ordered_quantity := p_ordered_quantity;
1758: end if;

Line 2908: l_control_rec.process_entity := OE_GLOBALS.G_ENTITY_ALL;

2904: END LOOP;
2905:
2906: l_control_rec.controlled_operation := TRUE;
2907: l_control_rec.process := FALSE;
2908: l_control_rec.process_entity := OE_GLOBALS.G_ENTITY_ALL;
2909: l_control_rec.Process_Partial := FALSE;
2910: l_control_rec.check_security := TRUE;
2911: l_control_rec.clear_dependents := TRUE;
2912: l_control_rec.default_attributes := TRUE;

Line 2951: l_control_rec.process_entity := OE_GLOBALS.G_ENTITY_ALL;

2947: END IF;
2948:
2949: l_control_rec.controlled_operation := TRUE;
2950: l_control_rec.process := TRUE;
2951: l_control_rec.process_entity := OE_GLOBALS.G_ENTITY_ALL;
2952:
2953: l_control_rec.check_security := FALSE;
2954: l_control_rec.clear_dependents := FALSE;
2955: l_control_rec.default_attributes := FALSE;

Line 3034: OE_Globals.G_PRICING_RECURSION := 'N';

3030:
3031: ROLLBACK TO SAVEPOINT Process_Line_Scalar;
3032:
3033: --Bug 7566697
3034: OE_Globals.G_PRICING_RECURSION := 'N';
3035: IF OE_MASS_CHANGE_PVT.G_PRICING_ERROR = 'Y'
3036: THEN
3037: oe_debug_pub.add('Pricing error has occured. Rolling back changes done to all lines');
3038: ROLLBACK TO SAVEPOINT Pricing_Header_Savepoint;

Line 3091: OE_Globals.G_PRICING_RECURSION := 'N';

3087:
3088: ROLLBACK TO SAVEPOINT Process_Line_Scalar;
3089:
3090: --Bug 7566697
3091: OE_Globals.G_PRICING_RECURSION := 'N';
3092: IF OE_MASS_CHANGE_PVT.G_PRICING_ERROR = 'Y'
3093: THEN
3094: oe_debug_pub.add('Pricing error has occured. Rolling back changes done to all lines');
3095: ROLLBACK TO SAVEPOINT Pricing_Header_Savepoint;

Line 3153: OE_Globals.G_PRICING_RECURSION := 'N';

3149:
3150: ROLLBACK TO SAVEPOINT Process_Line_Scalar;
3151:
3152: --Bug 7566697
3153: OE_Globals.G_PRICING_RECURSION := 'N';
3154: IF OE_MASS_CHANGE_PVT.G_PRICING_ERROR = 'Y'
3155: THEN
3156: oe_debug_pub.add('Pricing error has occured. Rolling back changes done to all lines');
3157: ROLLBACK TO SAVEPOINT Pricing_Header_Savepoint;

Line 3313: l_row OE_GLOBALS.Selected_Record_Type;

3309: -- 4020312
3310: -- Function to pipeline the table of selected lines for mass change.
3311: FUNCTION get_sel_rec_tbl RETURN Sel_Rec_Tbl
3312: PIPELINED IS
3313: l_row OE_GLOBALS.Selected_Record_Type;
3314: BEGIN
3315: FOR i IN g_sel_rec_tbl.first..g_sel_rec_tbl.last LOOP
3316: l_row.id1 := g_sel_rec_tbl(i).id1;
3317: l_row.id2 := g_sel_rec_tbl(i).id2;