APPS.MRP_FLOW_SCHEDULE_PVT dependencies on FND_API

Line 14: IF ( p_flow_schedule_Val_rec.Completion_locator = FND_API.G_MISS_CHAR ) THEN

10: x_Flow_Schedule_Val_Pvt_Rec OUT NOCOPY Flow_Schedule_Val_Pvt_Rec_Type)
11: IS
12: BEGIN
13:
14: IF ( p_flow_schedule_Val_rec.Completion_locator = FND_API.G_MISS_CHAR ) THEN
15: x_Flow_Schedule_Val_Pvt_Rec.completion_locator := NULL;
16: ELSE
17: x_Flow_Schedule_Val_Pvt_Rec.completion_locator := nvl(p_flow_schedule_Val_rec.Completion_locator,FND_API.G_MISS_CHAR ) ;
18: END IF;

Line 17: x_Flow_Schedule_Val_Pvt_Rec.completion_locator := nvl(p_flow_schedule_Val_rec.Completion_locator,FND_API.G_MISS_CHAR ) ;

13:
14: IF ( p_flow_schedule_Val_rec.Completion_locator = FND_API.G_MISS_CHAR ) THEN
15: x_Flow_Schedule_Val_Pvt_Rec.completion_locator := NULL;
16: ELSE
17: x_Flow_Schedule_Val_Pvt_Rec.completion_locator := nvl(p_flow_schedule_Val_rec.Completion_locator,FND_API.G_MISS_CHAR ) ;
18: END IF;
19:
20: IF ( p_flow_schedule_Val_rec.line = FND_API.G_MISS_CHAR ) THEN
21: x_Flow_Schedule_Val_Pvt_Rec.line := NULL;

Line 20: IF ( p_flow_schedule_Val_rec.line = FND_API.G_MISS_CHAR ) THEN

16: ELSE
17: x_Flow_Schedule_Val_Pvt_Rec.completion_locator := nvl(p_flow_schedule_Val_rec.Completion_locator,FND_API.G_MISS_CHAR ) ;
18: END IF;
19:
20: IF ( p_flow_schedule_Val_rec.line = FND_API.G_MISS_CHAR ) THEN
21: x_Flow_Schedule_Val_Pvt_Rec.line := NULL;
22: ELSE
23: x_Flow_Schedule_Val_Pvt_Rec.line := nvl(p_flow_schedule_Val_rec.line,FND_API.G_MISS_CHAR ) ;
24: END IF;

Line 23: x_Flow_Schedule_Val_Pvt_Rec.line := nvl(p_flow_schedule_Val_rec.line,FND_API.G_MISS_CHAR ) ;

19:
20: IF ( p_flow_schedule_Val_rec.line = FND_API.G_MISS_CHAR ) THEN
21: x_Flow_Schedule_Val_Pvt_Rec.line := NULL;
22: ELSE
23: x_Flow_Schedule_Val_Pvt_Rec.line := nvl(p_flow_schedule_Val_rec.line,FND_API.G_MISS_CHAR ) ;
24: END IF;
25:
26: IF ( p_flow_schedule_Val_rec.organization = FND_API.G_MISS_CHAR ) THEN
27: x_Flow_Schedule_Val_Pvt_Rec.organization := NULL;

Line 26: IF ( p_flow_schedule_Val_rec.organization = FND_API.G_MISS_CHAR ) THEN

22: ELSE
23: x_Flow_Schedule_Val_Pvt_Rec.line := nvl(p_flow_schedule_Val_rec.line,FND_API.G_MISS_CHAR ) ;
24: END IF;
25:
26: IF ( p_flow_schedule_Val_rec.organization = FND_API.G_MISS_CHAR ) THEN
27: x_Flow_Schedule_Val_Pvt_Rec.organization := NULL;
28: ELSE
29: x_Flow_Schedule_Val_Pvt_Rec.organization:= nvl(p_flow_schedule_Val_rec.organization,FND_API.G_MISS_CHAR ) ;
30: END IF;

Line 29: x_Flow_Schedule_Val_Pvt_Rec.organization:= nvl(p_flow_schedule_Val_rec.organization,FND_API.G_MISS_CHAR ) ;

25:
26: IF ( p_flow_schedule_Val_rec.organization = FND_API.G_MISS_CHAR ) THEN
27: x_Flow_Schedule_Val_Pvt_Rec.organization := NULL;
28: ELSE
29: x_Flow_Schedule_Val_Pvt_Rec.organization:= nvl(p_flow_schedule_Val_rec.organization,FND_API.G_MISS_CHAR ) ;
30: END IF;
31:
32: IF ( p_flow_schedule_Val_rec.primary_item = FND_API.G_MISS_CHAR ) THEN
33: x_Flow_Schedule_Val_Pvt_Rec.primary_item := NULL;

Line 32: IF ( p_flow_schedule_Val_rec.primary_item = FND_API.G_MISS_CHAR ) THEN

28: ELSE
29: x_Flow_Schedule_Val_Pvt_Rec.organization:= nvl(p_flow_schedule_Val_rec.organization,FND_API.G_MISS_CHAR ) ;
30: END IF;
31:
32: IF ( p_flow_schedule_Val_rec.primary_item = FND_API.G_MISS_CHAR ) THEN
33: x_Flow_Schedule_Val_Pvt_Rec.primary_item := NULL;
34: ELSE
35: x_Flow_Schedule_Val_Pvt_Rec.primary_item := nvl(p_flow_schedule_Val_rec.primary_item,FND_API.G_MISS_CHAR ) ;
36: END IF;

Line 35: x_Flow_Schedule_Val_Pvt_Rec.primary_item := nvl(p_flow_schedule_Val_rec.primary_item,FND_API.G_MISS_CHAR ) ;

31:
32: IF ( p_flow_schedule_Val_rec.primary_item = FND_API.G_MISS_CHAR ) THEN
33: x_Flow_Schedule_Val_Pvt_Rec.primary_item := NULL;
34: ELSE
35: x_Flow_Schedule_Val_Pvt_Rec.primary_item := nvl(p_flow_schedule_Val_rec.primary_item,FND_API.G_MISS_CHAR ) ;
36: END IF;
37:
38: IF ( p_flow_schedule_Val_rec.project = FND_API.G_MISS_CHAR ) THEN
39: x_Flow_Schedule_Val_Pvt_Rec.project := NULL;

Line 38: IF ( p_flow_schedule_Val_rec.project = FND_API.G_MISS_CHAR ) THEN

34: ELSE
35: x_Flow_Schedule_Val_Pvt_Rec.primary_item := nvl(p_flow_schedule_Val_rec.primary_item,FND_API.G_MISS_CHAR ) ;
36: END IF;
37:
38: IF ( p_flow_schedule_Val_rec.project = FND_API.G_MISS_CHAR ) THEN
39: x_Flow_Schedule_Val_Pvt_Rec.project := NULL;
40: ELSE
41: x_Flow_Schedule_Val_Pvt_Rec.project := nvl(p_flow_schedule_Val_rec.project,FND_API.G_MISS_CHAR ) ;
42: END IF;

Line 41: x_Flow_Schedule_Val_Pvt_Rec.project := nvl(p_flow_schedule_Val_rec.project,FND_API.G_MISS_CHAR ) ;

37:
38: IF ( p_flow_schedule_Val_rec.project = FND_API.G_MISS_CHAR ) THEN
39: x_Flow_Schedule_Val_Pvt_Rec.project := NULL;
40: ELSE
41: x_Flow_Schedule_Val_Pvt_Rec.project := nvl(p_flow_schedule_Val_rec.project,FND_API.G_MISS_CHAR ) ;
42: END IF;
43:
44: IF ( p_flow_schedule_Val_rec.schedule_group = FND_API.G_MISS_CHAR ) THEN
45: x_Flow_Schedule_Val_Pvt_Rec.schedule_group := NULL;

Line 44: IF ( p_flow_schedule_Val_rec.schedule_group = FND_API.G_MISS_CHAR ) THEN

40: ELSE
41: x_Flow_Schedule_Val_Pvt_Rec.project := nvl(p_flow_schedule_Val_rec.project,FND_API.G_MISS_CHAR ) ;
42: END IF;
43:
44: IF ( p_flow_schedule_Val_rec.schedule_group = FND_API.G_MISS_CHAR ) THEN
45: x_Flow_Schedule_Val_Pvt_Rec.schedule_group := NULL;
46: ELSE
47: x_Flow_Schedule_Val_Pvt_Rec.schedule_group := nvl(p_flow_schedule_Val_rec.schedule_group,FND_API.G_MISS_CHAR ) ;
48: END IF;

Line 47: x_Flow_Schedule_Val_Pvt_Rec.schedule_group := nvl(p_flow_schedule_Val_rec.schedule_group,FND_API.G_MISS_CHAR ) ;

43:
44: IF ( p_flow_schedule_Val_rec.schedule_group = FND_API.G_MISS_CHAR ) THEN
45: x_Flow_Schedule_Val_Pvt_Rec.schedule_group := NULL;
46: ELSE
47: x_Flow_Schedule_Val_Pvt_Rec.schedule_group := nvl(p_flow_schedule_Val_rec.schedule_group,FND_API.G_MISS_CHAR ) ;
48: END IF;
49:
50: END;
51:

Line 58: IF ( p_flow_schedule_rec.alternate_bom_designator = FND_API.G_MISS_CHAR ) THEN

54: x_Flow_Schedule_Pvt_Rec OUT NOCOPY Flow_Schedule_Pvt_Rec_Type)
55: IS
56: BEGIN
57:
58: IF ( p_flow_schedule_rec.alternate_bom_designator = FND_API.G_MISS_CHAR ) THEN
59: x_Flow_Schedule_Pvt_Rec.alternate_bom_designator := NULL;
60: ELSE
61: x_Flow_Schedule_Pvt_Rec.alternate_bom_designator := nvl(p_flow_schedule_rec.alternate_bom_designator,FND_API.G_MISS_CHAR ) ;
62: END IF;

Line 61: x_Flow_Schedule_Pvt_Rec.alternate_bom_designator := nvl(p_flow_schedule_rec.alternate_bom_designator,FND_API.G_MISS_CHAR ) ;

57:
58: IF ( p_flow_schedule_rec.alternate_bom_designator = FND_API.G_MISS_CHAR ) THEN
59: x_Flow_Schedule_Pvt_Rec.alternate_bom_designator := NULL;
60: ELSE
61: x_Flow_Schedule_Pvt_Rec.alternate_bom_designator := nvl(p_flow_schedule_rec.alternate_bom_designator,FND_API.G_MISS_CHAR ) ;
62: END IF;
63:
64: IF ( p_flow_schedule_rec.alternate_routing_desig = FND_API.G_MISS_CHAR ) THEN
65: x_Flow_Schedule_Pvt_Rec.alternate_routing_desig := NULL;

Line 64: IF ( p_flow_schedule_rec.alternate_routing_desig = FND_API.G_MISS_CHAR ) THEN

60: ELSE
61: x_Flow_Schedule_Pvt_Rec.alternate_bom_designator := nvl(p_flow_schedule_rec.alternate_bom_designator,FND_API.G_MISS_CHAR ) ;
62: END IF;
63:
64: IF ( p_flow_schedule_rec.alternate_routing_desig = FND_API.G_MISS_CHAR ) THEN
65: x_Flow_Schedule_Pvt_Rec.alternate_routing_desig := NULL;
66: ELSE
67: x_Flow_Schedule_Pvt_Rec.alternate_routing_desig := nvl(p_flow_schedule_rec.alternate_routing_desig,FND_API.G_MISS_CHAR ) ;
68: END IF;

Line 67: x_Flow_Schedule_Pvt_Rec.alternate_routing_desig := nvl(p_flow_schedule_rec.alternate_routing_desig,FND_API.G_MISS_CHAR ) ;

63:
64: IF ( p_flow_schedule_rec.alternate_routing_desig = FND_API.G_MISS_CHAR ) THEN
65: x_Flow_Schedule_Pvt_Rec.alternate_routing_desig := NULL;
66: ELSE
67: x_Flow_Schedule_Pvt_Rec.alternate_routing_desig := nvl(p_flow_schedule_rec.alternate_routing_desig,FND_API.G_MISS_CHAR ) ;
68: END IF;
69:
70: IF ( p_flow_schedule_rec.attribute1 = FND_API.G_MISS_CHAR ) THEN
71: x_Flow_Schedule_Pvt_Rec.attribute1 := NULL;

Line 70: IF ( p_flow_schedule_rec.attribute1 = FND_API.G_MISS_CHAR ) THEN

66: ELSE
67: x_Flow_Schedule_Pvt_Rec.alternate_routing_desig := nvl(p_flow_schedule_rec.alternate_routing_desig,FND_API.G_MISS_CHAR ) ;
68: END IF;
69:
70: IF ( p_flow_schedule_rec.attribute1 = FND_API.G_MISS_CHAR ) THEN
71: x_Flow_Schedule_Pvt_Rec.attribute1 := NULL;
72: ELSE
73: x_Flow_Schedule_Pvt_Rec.attribute1 := nvl(p_flow_schedule_rec.attribute1,FND_API.G_MISS_CHAR ) ;
74: END IF;

Line 73: x_Flow_Schedule_Pvt_Rec.attribute1 := nvl(p_flow_schedule_rec.attribute1,FND_API.G_MISS_CHAR ) ;

69:
70: IF ( p_flow_schedule_rec.attribute1 = FND_API.G_MISS_CHAR ) THEN
71: x_Flow_Schedule_Pvt_Rec.attribute1 := NULL;
72: ELSE
73: x_Flow_Schedule_Pvt_Rec.attribute1 := nvl(p_flow_schedule_rec.attribute1,FND_API.G_MISS_CHAR ) ;
74: END IF;
75:
76: IF ( p_flow_schedule_rec.attribute10 = FND_API.G_MISS_CHAR ) THEN
77: x_Flow_Schedule_Pvt_Rec.attribute10 := NULL;

Line 76: IF ( p_flow_schedule_rec.attribute10 = FND_API.G_MISS_CHAR ) THEN

72: ELSE
73: x_Flow_Schedule_Pvt_Rec.attribute1 := nvl(p_flow_schedule_rec.attribute1,FND_API.G_MISS_CHAR ) ;
74: END IF;
75:
76: IF ( p_flow_schedule_rec.attribute10 = FND_API.G_MISS_CHAR ) THEN
77: x_Flow_Schedule_Pvt_Rec.attribute10 := NULL;
78: ELSE
79: x_Flow_Schedule_Pvt_Rec.attribute10 := nvl(p_flow_schedule_rec.attribute10,FND_API.G_MISS_CHAR ) ;
80: END IF;

Line 79: x_Flow_Schedule_Pvt_Rec.attribute10 := nvl(p_flow_schedule_rec.attribute10,FND_API.G_MISS_CHAR ) ;

75:
76: IF ( p_flow_schedule_rec.attribute10 = FND_API.G_MISS_CHAR ) THEN
77: x_Flow_Schedule_Pvt_Rec.attribute10 := NULL;
78: ELSE
79: x_Flow_Schedule_Pvt_Rec.attribute10 := nvl(p_flow_schedule_rec.attribute10,FND_API.G_MISS_CHAR ) ;
80: END IF;
81:
82: IF ( p_flow_schedule_rec.attribute11 = FND_API.G_MISS_CHAR ) THEN
83: x_Flow_Schedule_Pvt_Rec.attribute11 := NULL;

Line 82: IF ( p_flow_schedule_rec.attribute11 = FND_API.G_MISS_CHAR ) THEN

78: ELSE
79: x_Flow_Schedule_Pvt_Rec.attribute10 := nvl(p_flow_schedule_rec.attribute10,FND_API.G_MISS_CHAR ) ;
80: END IF;
81:
82: IF ( p_flow_schedule_rec.attribute11 = FND_API.G_MISS_CHAR ) THEN
83: x_Flow_Schedule_Pvt_Rec.attribute11 := NULL;
84: ELSE
85: x_Flow_Schedule_Pvt_Rec.attribute11 := nvl(p_flow_schedule_rec.attribute11,FND_API.G_MISS_CHAR ) ;
86: END IF;

Line 85: x_Flow_Schedule_Pvt_Rec.attribute11 := nvl(p_flow_schedule_rec.attribute11,FND_API.G_MISS_CHAR ) ;

81:
82: IF ( p_flow_schedule_rec.attribute11 = FND_API.G_MISS_CHAR ) THEN
83: x_Flow_Schedule_Pvt_Rec.attribute11 := NULL;
84: ELSE
85: x_Flow_Schedule_Pvt_Rec.attribute11 := nvl(p_flow_schedule_rec.attribute11,FND_API.G_MISS_CHAR ) ;
86: END IF;
87:
88: IF ( p_flow_schedule_rec.attribute12 = FND_API.G_MISS_CHAR ) THEN
89: x_Flow_Schedule_Pvt_Rec.attribute12 := NULL;

Line 88: IF ( p_flow_schedule_rec.attribute12 = FND_API.G_MISS_CHAR ) THEN

84: ELSE
85: x_Flow_Schedule_Pvt_Rec.attribute11 := nvl(p_flow_schedule_rec.attribute11,FND_API.G_MISS_CHAR ) ;
86: END IF;
87:
88: IF ( p_flow_schedule_rec.attribute12 = FND_API.G_MISS_CHAR ) THEN
89: x_Flow_Schedule_Pvt_Rec.attribute12 := NULL;
90: ELSE
91: x_Flow_Schedule_Pvt_Rec.attribute12 := nvl(p_flow_schedule_rec.attribute12,FND_API.G_MISS_CHAR ) ;
92: END IF;

Line 91: x_Flow_Schedule_Pvt_Rec.attribute12 := nvl(p_flow_schedule_rec.attribute12,FND_API.G_MISS_CHAR ) ;

87:
88: IF ( p_flow_schedule_rec.attribute12 = FND_API.G_MISS_CHAR ) THEN
89: x_Flow_Schedule_Pvt_Rec.attribute12 := NULL;
90: ELSE
91: x_Flow_Schedule_Pvt_Rec.attribute12 := nvl(p_flow_schedule_rec.attribute12,FND_API.G_MISS_CHAR ) ;
92: END IF;
93:
94: IF ( p_flow_schedule_rec.attribute13 = FND_API.G_MISS_CHAR ) THEN
95: x_Flow_Schedule_Pvt_Rec.attribute13 := NULL;

Line 94: IF ( p_flow_schedule_rec.attribute13 = FND_API.G_MISS_CHAR ) THEN

90: ELSE
91: x_Flow_Schedule_Pvt_Rec.attribute12 := nvl(p_flow_schedule_rec.attribute12,FND_API.G_MISS_CHAR ) ;
92: END IF;
93:
94: IF ( p_flow_schedule_rec.attribute13 = FND_API.G_MISS_CHAR ) THEN
95: x_Flow_Schedule_Pvt_Rec.attribute13 := NULL;
96: ELSE
97: x_Flow_Schedule_Pvt_Rec.attribute13 := nvl(p_flow_schedule_rec.attribute13,FND_API.G_MISS_CHAR ) ;
98: END IF;

Line 97: x_Flow_Schedule_Pvt_Rec.attribute13 := nvl(p_flow_schedule_rec.attribute13,FND_API.G_MISS_CHAR ) ;

93:
94: IF ( p_flow_schedule_rec.attribute13 = FND_API.G_MISS_CHAR ) THEN
95: x_Flow_Schedule_Pvt_Rec.attribute13 := NULL;
96: ELSE
97: x_Flow_Schedule_Pvt_Rec.attribute13 := nvl(p_flow_schedule_rec.attribute13,FND_API.G_MISS_CHAR ) ;
98: END IF;
99:
100: IF ( p_flow_schedule_rec.attribute14 = FND_API.G_MISS_CHAR ) THEN
101: x_Flow_Schedule_Pvt_Rec.attribute14 := NULL;

Line 100: IF ( p_flow_schedule_rec.attribute14 = FND_API.G_MISS_CHAR ) THEN

96: ELSE
97: x_Flow_Schedule_Pvt_Rec.attribute13 := nvl(p_flow_schedule_rec.attribute13,FND_API.G_MISS_CHAR ) ;
98: END IF;
99:
100: IF ( p_flow_schedule_rec.attribute14 = FND_API.G_MISS_CHAR ) THEN
101: x_Flow_Schedule_Pvt_Rec.attribute14 := NULL;
102: ELSE
103: x_Flow_Schedule_Pvt_Rec.attribute14 := nvl(p_flow_schedule_rec.attribute14,FND_API.G_MISS_CHAR ) ;
104: END IF;

Line 103: x_Flow_Schedule_Pvt_Rec.attribute14 := nvl(p_flow_schedule_rec.attribute14,FND_API.G_MISS_CHAR ) ;

99:
100: IF ( p_flow_schedule_rec.attribute14 = FND_API.G_MISS_CHAR ) THEN
101: x_Flow_Schedule_Pvt_Rec.attribute14 := NULL;
102: ELSE
103: x_Flow_Schedule_Pvt_Rec.attribute14 := nvl(p_flow_schedule_rec.attribute14,FND_API.G_MISS_CHAR ) ;
104: END IF;
105:
106: IF ( p_flow_schedule_rec.attribute15 = FND_API.G_MISS_CHAR ) THEN
107: x_Flow_Schedule_Pvt_Rec.attribute15 := NULL;

Line 106: IF ( p_flow_schedule_rec.attribute15 = FND_API.G_MISS_CHAR ) THEN

102: ELSE
103: x_Flow_Schedule_Pvt_Rec.attribute14 := nvl(p_flow_schedule_rec.attribute14,FND_API.G_MISS_CHAR ) ;
104: END IF;
105:
106: IF ( p_flow_schedule_rec.attribute15 = FND_API.G_MISS_CHAR ) THEN
107: x_Flow_Schedule_Pvt_Rec.attribute15 := NULL;
108: ELSE
109: x_Flow_Schedule_Pvt_Rec.attribute15 := nvl(p_flow_schedule_rec.attribute15,FND_API.G_MISS_CHAR ) ;
110: END IF;

Line 109: x_Flow_Schedule_Pvt_Rec.attribute15 := nvl(p_flow_schedule_rec.attribute15,FND_API.G_MISS_CHAR ) ;

105:
106: IF ( p_flow_schedule_rec.attribute15 = FND_API.G_MISS_CHAR ) THEN
107: x_Flow_Schedule_Pvt_Rec.attribute15 := NULL;
108: ELSE
109: x_Flow_Schedule_Pvt_Rec.attribute15 := nvl(p_flow_schedule_rec.attribute15,FND_API.G_MISS_CHAR ) ;
110: END IF;
111:
112: IF ( p_flow_schedule_rec.attribute2 = FND_API.G_MISS_CHAR ) THEN
113: x_Flow_Schedule_Pvt_Rec.attribute2 := NULL;

Line 112: IF ( p_flow_schedule_rec.attribute2 = FND_API.G_MISS_CHAR ) THEN

108: ELSE
109: x_Flow_Schedule_Pvt_Rec.attribute15 := nvl(p_flow_schedule_rec.attribute15,FND_API.G_MISS_CHAR ) ;
110: END IF;
111:
112: IF ( p_flow_schedule_rec.attribute2 = FND_API.G_MISS_CHAR ) THEN
113: x_Flow_Schedule_Pvt_Rec.attribute2 := NULL;
114: ELSE
115: x_Flow_Schedule_Pvt_Rec.attribute2 := nvl(p_flow_schedule_rec.attribute2,FND_API.G_MISS_CHAR ) ;
116: END IF;

Line 115: x_Flow_Schedule_Pvt_Rec.attribute2 := nvl(p_flow_schedule_rec.attribute2,FND_API.G_MISS_CHAR ) ;

111:
112: IF ( p_flow_schedule_rec.attribute2 = FND_API.G_MISS_CHAR ) THEN
113: x_Flow_Schedule_Pvt_Rec.attribute2 := NULL;
114: ELSE
115: x_Flow_Schedule_Pvt_Rec.attribute2 := nvl(p_flow_schedule_rec.attribute2,FND_API.G_MISS_CHAR ) ;
116: END IF;
117:
118: IF ( p_flow_schedule_rec.attribute3 = FND_API.G_MISS_CHAR ) THEN
119: x_Flow_Schedule_Pvt_Rec.attribute3 := NULL;

Line 118: IF ( p_flow_schedule_rec.attribute3 = FND_API.G_MISS_CHAR ) THEN

114: ELSE
115: x_Flow_Schedule_Pvt_Rec.attribute2 := nvl(p_flow_schedule_rec.attribute2,FND_API.G_MISS_CHAR ) ;
116: END IF;
117:
118: IF ( p_flow_schedule_rec.attribute3 = FND_API.G_MISS_CHAR ) THEN
119: x_Flow_Schedule_Pvt_Rec.attribute3 := NULL;
120: ELSE
121: x_Flow_Schedule_Pvt_Rec.attribute3 := nvl(p_flow_schedule_rec.attribute3,FND_API.G_MISS_CHAR ) ;
122: END IF;

Line 121: x_Flow_Schedule_Pvt_Rec.attribute3 := nvl(p_flow_schedule_rec.attribute3,FND_API.G_MISS_CHAR ) ;

117:
118: IF ( p_flow_schedule_rec.attribute3 = FND_API.G_MISS_CHAR ) THEN
119: x_Flow_Schedule_Pvt_Rec.attribute3 := NULL;
120: ELSE
121: x_Flow_Schedule_Pvt_Rec.attribute3 := nvl(p_flow_schedule_rec.attribute3,FND_API.G_MISS_CHAR ) ;
122: END IF;
123:
124: IF ( p_flow_schedule_rec.attribute4 = FND_API.G_MISS_CHAR ) THEN
125: x_Flow_Schedule_Pvt_Rec.attribute4 := NULL;

Line 124: IF ( p_flow_schedule_rec.attribute4 = FND_API.G_MISS_CHAR ) THEN

120: ELSE
121: x_Flow_Schedule_Pvt_Rec.attribute3 := nvl(p_flow_schedule_rec.attribute3,FND_API.G_MISS_CHAR ) ;
122: END IF;
123:
124: IF ( p_flow_schedule_rec.attribute4 = FND_API.G_MISS_CHAR ) THEN
125: x_Flow_Schedule_Pvt_Rec.attribute4 := NULL;
126: ELSE
127: x_Flow_Schedule_Pvt_Rec.attribute4 := nvl(p_flow_schedule_rec.attribute4 ,FND_API.G_MISS_CHAR ) ;
128: END IF;

Line 127: x_Flow_Schedule_Pvt_Rec.attribute4 := nvl(p_flow_schedule_rec.attribute4 ,FND_API.G_MISS_CHAR ) ;

123:
124: IF ( p_flow_schedule_rec.attribute4 = FND_API.G_MISS_CHAR ) THEN
125: x_Flow_Schedule_Pvt_Rec.attribute4 := NULL;
126: ELSE
127: x_Flow_Schedule_Pvt_Rec.attribute4 := nvl(p_flow_schedule_rec.attribute4 ,FND_API.G_MISS_CHAR ) ;
128: END IF;
129:
130: IF ( p_flow_schedule_rec.attribute5 = FND_API.G_MISS_CHAR ) THEN
131: x_Flow_Schedule_Pvt_Rec.attribute5 := NULL;

Line 130: IF ( p_flow_schedule_rec.attribute5 = FND_API.G_MISS_CHAR ) THEN

126: ELSE
127: x_Flow_Schedule_Pvt_Rec.attribute4 := nvl(p_flow_schedule_rec.attribute4 ,FND_API.G_MISS_CHAR ) ;
128: END IF;
129:
130: IF ( p_flow_schedule_rec.attribute5 = FND_API.G_MISS_CHAR ) THEN
131: x_Flow_Schedule_Pvt_Rec.attribute5 := NULL;
132: ELSE
133: x_Flow_Schedule_Pvt_Rec.attribute5 := nvl(p_flow_schedule_rec.attribute5 ,FND_API.G_MISS_CHAR ) ;
134: END IF;

Line 133: x_Flow_Schedule_Pvt_Rec.attribute5 := nvl(p_flow_schedule_rec.attribute5 ,FND_API.G_MISS_CHAR ) ;

129:
130: IF ( p_flow_schedule_rec.attribute5 = FND_API.G_MISS_CHAR ) THEN
131: x_Flow_Schedule_Pvt_Rec.attribute5 := NULL;
132: ELSE
133: x_Flow_Schedule_Pvt_Rec.attribute5 := nvl(p_flow_schedule_rec.attribute5 ,FND_API.G_MISS_CHAR ) ;
134: END IF;
135:
136: IF ( p_flow_schedule_rec.attribute6 = FND_API.G_MISS_CHAR ) THEN
137: x_Flow_Schedule_Pvt_Rec.attribute6 := NULL;

Line 136: IF ( p_flow_schedule_rec.attribute6 = FND_API.G_MISS_CHAR ) THEN

132: ELSE
133: x_Flow_Schedule_Pvt_Rec.attribute5 := nvl(p_flow_schedule_rec.attribute5 ,FND_API.G_MISS_CHAR ) ;
134: END IF;
135:
136: IF ( p_flow_schedule_rec.attribute6 = FND_API.G_MISS_CHAR ) THEN
137: x_Flow_Schedule_Pvt_Rec.attribute6 := NULL;
138: ELSE
139: x_Flow_Schedule_Pvt_Rec.attribute6 := nvl(p_flow_schedule_rec.attribute6 ,FND_API.G_MISS_CHAR ) ;
140: END IF;

Line 139: x_Flow_Schedule_Pvt_Rec.attribute6 := nvl(p_flow_schedule_rec.attribute6 ,FND_API.G_MISS_CHAR ) ;

135:
136: IF ( p_flow_schedule_rec.attribute6 = FND_API.G_MISS_CHAR ) THEN
137: x_Flow_Schedule_Pvt_Rec.attribute6 := NULL;
138: ELSE
139: x_Flow_Schedule_Pvt_Rec.attribute6 := nvl(p_flow_schedule_rec.attribute6 ,FND_API.G_MISS_CHAR ) ;
140: END IF;
141:
142: IF ( p_flow_schedule_rec.attribute7 = FND_API.G_MISS_CHAR ) THEN
143: x_Flow_Schedule_Pvt_Rec.attribute7 := NULL;

Line 142: IF ( p_flow_schedule_rec.attribute7 = FND_API.G_MISS_CHAR ) THEN

138: ELSE
139: x_Flow_Schedule_Pvt_Rec.attribute6 := nvl(p_flow_schedule_rec.attribute6 ,FND_API.G_MISS_CHAR ) ;
140: END IF;
141:
142: IF ( p_flow_schedule_rec.attribute7 = FND_API.G_MISS_CHAR ) THEN
143: x_Flow_Schedule_Pvt_Rec.attribute7 := NULL;
144: ELSE
145: x_Flow_Schedule_Pvt_Rec.attribute7 := nvl(p_flow_schedule_rec.attribute7 ,FND_API.G_MISS_CHAR ) ;
146: END IF;

Line 145: x_Flow_Schedule_Pvt_Rec.attribute7 := nvl(p_flow_schedule_rec.attribute7 ,FND_API.G_MISS_CHAR ) ;

141:
142: IF ( p_flow_schedule_rec.attribute7 = FND_API.G_MISS_CHAR ) THEN
143: x_Flow_Schedule_Pvt_Rec.attribute7 := NULL;
144: ELSE
145: x_Flow_Schedule_Pvt_Rec.attribute7 := nvl(p_flow_schedule_rec.attribute7 ,FND_API.G_MISS_CHAR ) ;
146: END IF;
147:
148: IF ( p_flow_schedule_rec.attribute8 = FND_API.G_MISS_CHAR ) THEN
149: x_Flow_Schedule_Pvt_Rec.attribute8 := NULL;

Line 148: IF ( p_flow_schedule_rec.attribute8 = FND_API.G_MISS_CHAR ) THEN

144: ELSE
145: x_Flow_Schedule_Pvt_Rec.attribute7 := nvl(p_flow_schedule_rec.attribute7 ,FND_API.G_MISS_CHAR ) ;
146: END IF;
147:
148: IF ( p_flow_schedule_rec.attribute8 = FND_API.G_MISS_CHAR ) THEN
149: x_Flow_Schedule_Pvt_Rec.attribute8 := NULL;
150: ELSE
151: x_Flow_Schedule_Pvt_Rec.attribute8 := nvl(p_flow_schedule_rec.attribute8 ,FND_API.G_MISS_CHAR ) ;
152: END IF;

Line 151: x_Flow_Schedule_Pvt_Rec.attribute8 := nvl(p_flow_schedule_rec.attribute8 ,FND_API.G_MISS_CHAR ) ;

147:
148: IF ( p_flow_schedule_rec.attribute8 = FND_API.G_MISS_CHAR ) THEN
149: x_Flow_Schedule_Pvt_Rec.attribute8 := NULL;
150: ELSE
151: x_Flow_Schedule_Pvt_Rec.attribute8 := nvl(p_flow_schedule_rec.attribute8 ,FND_API.G_MISS_CHAR ) ;
152: END IF;
153:
154: IF ( p_flow_schedule_rec.attribute9 = FND_API.G_MISS_CHAR ) THEN
155: x_Flow_Schedule_Pvt_Rec.attribute9 := NULL;

Line 154: IF ( p_flow_schedule_rec.attribute9 = FND_API.G_MISS_CHAR ) THEN

150: ELSE
151: x_Flow_Schedule_Pvt_Rec.attribute8 := nvl(p_flow_schedule_rec.attribute8 ,FND_API.G_MISS_CHAR ) ;
152: END IF;
153:
154: IF ( p_flow_schedule_rec.attribute9 = FND_API.G_MISS_CHAR ) THEN
155: x_Flow_Schedule_Pvt_Rec.attribute9 := NULL;
156: ELSE
157: x_Flow_Schedule_Pvt_Rec.attribute9 := nvl(p_flow_schedule_rec.attribute9 ,FND_API.G_MISS_CHAR ) ;
158: END IF;

Line 157: x_Flow_Schedule_Pvt_Rec.attribute9 := nvl(p_flow_schedule_rec.attribute9 ,FND_API.G_MISS_CHAR ) ;

153:
154: IF ( p_flow_schedule_rec.attribute9 = FND_API.G_MISS_CHAR ) THEN
155: x_Flow_Schedule_Pvt_Rec.attribute9 := NULL;
156: ELSE
157: x_Flow_Schedule_Pvt_Rec.attribute9 := nvl(p_flow_schedule_rec.attribute9 ,FND_API.G_MISS_CHAR ) ;
158: END IF;
159:
160: IF ( p_flow_schedule_rec.attribute_category = FND_API.G_MISS_CHAR ) THEN
161: x_Flow_Schedule_Pvt_Rec.attribute_category := NULL;

Line 160: IF ( p_flow_schedule_rec.attribute_category = FND_API.G_MISS_CHAR ) THEN

156: ELSE
157: x_Flow_Schedule_Pvt_Rec.attribute9 := nvl(p_flow_schedule_rec.attribute9 ,FND_API.G_MISS_CHAR ) ;
158: END IF;
159:
160: IF ( p_flow_schedule_rec.attribute_category = FND_API.G_MISS_CHAR ) THEN
161: x_Flow_Schedule_Pvt_Rec.attribute_category := NULL;
162: ELSE
163: x_Flow_Schedule_Pvt_Rec.attribute_category := nvl(p_flow_schedule_rec.attribute_category ,FND_API.G_MISS_CHAR ) ;
164: END IF;

Line 163: x_Flow_Schedule_Pvt_Rec.attribute_category := nvl(p_flow_schedule_rec.attribute_category ,FND_API.G_MISS_CHAR ) ;

159:
160: IF ( p_flow_schedule_rec.attribute_category = FND_API.G_MISS_CHAR ) THEN
161: x_Flow_Schedule_Pvt_Rec.attribute_category := NULL;
162: ELSE
163: x_Flow_Schedule_Pvt_Rec.attribute_category := nvl(p_flow_schedule_rec.attribute_category ,FND_API.G_MISS_CHAR ) ;
164: END IF;
165:
166: IF ( p_flow_schedule_rec.bom_revision = FND_API.G_MISS_CHAR ) THEN
167: x_Flow_Schedule_Pvt_Rec.bom_revision := NULL;

Line 166: IF ( p_flow_schedule_rec.bom_revision = FND_API.G_MISS_CHAR ) THEN

162: ELSE
163: x_Flow_Schedule_Pvt_Rec.attribute_category := nvl(p_flow_schedule_rec.attribute_category ,FND_API.G_MISS_CHAR ) ;
164: END IF;
165:
166: IF ( p_flow_schedule_rec.bom_revision = FND_API.G_MISS_CHAR ) THEN
167: x_Flow_Schedule_Pvt_Rec.bom_revision := NULL;
168: ELSE
169: x_Flow_Schedule_Pvt_Rec.bom_revision := nvl(p_flow_schedule_rec.bom_revision ,FND_API.G_MISS_CHAR ) ;
170: END IF;

Line 169: x_Flow_Schedule_Pvt_Rec.bom_revision := nvl(p_flow_schedule_rec.bom_revision ,FND_API.G_MISS_CHAR ) ;

165:
166: IF ( p_flow_schedule_rec.bom_revision = FND_API.G_MISS_CHAR ) THEN
167: x_Flow_Schedule_Pvt_Rec.bom_revision := NULL;
168: ELSE
169: x_Flow_Schedule_Pvt_Rec.bom_revision := nvl(p_flow_schedule_rec.bom_revision ,FND_API.G_MISS_CHAR ) ;
170: END IF;
171:
172: IF ( p_flow_schedule_rec.bom_revision_date = FND_API.G_MISS_DATE ) THEN
173: x_Flow_Schedule_Pvt_Rec.bom_revision_date := NULL;

Line 172: IF ( p_flow_schedule_rec.bom_revision_date = FND_API.G_MISS_DATE ) THEN

168: ELSE
169: x_Flow_Schedule_Pvt_Rec.bom_revision := nvl(p_flow_schedule_rec.bom_revision ,FND_API.G_MISS_CHAR ) ;
170: END IF;
171:
172: IF ( p_flow_schedule_rec.bom_revision_date = FND_API.G_MISS_DATE ) THEN
173: x_Flow_Schedule_Pvt_Rec.bom_revision_date := NULL;
174: ELSE
175: x_Flow_Schedule_Pvt_Rec.bom_revision_date := nvl(p_flow_schedule_rec.bom_revision_date,FND_API.G_MISS_DATE ) ;
176: END IF;

Line 175: x_Flow_Schedule_Pvt_Rec.bom_revision_date := nvl(p_flow_schedule_rec.bom_revision_date,FND_API.G_MISS_DATE ) ;

171:
172: IF ( p_flow_schedule_rec.bom_revision_date = FND_API.G_MISS_DATE ) THEN
173: x_Flow_Schedule_Pvt_Rec.bom_revision_date := NULL;
174: ELSE
175: x_Flow_Schedule_Pvt_Rec.bom_revision_date := nvl(p_flow_schedule_rec.bom_revision_date,FND_API.G_MISS_DATE ) ;
176: END IF;
177:
178: IF ( p_flow_schedule_rec.build_sequence = FND_API.G_MISS_NUM ) THEN
179: x_Flow_Schedule_Pvt_Rec.build_sequence := NULL;

Line 178: IF ( p_flow_schedule_rec.build_sequence = FND_API.G_MISS_NUM ) THEN

174: ELSE
175: x_Flow_Schedule_Pvt_Rec.bom_revision_date := nvl(p_flow_schedule_rec.bom_revision_date,FND_API.G_MISS_DATE ) ;
176: END IF;
177:
178: IF ( p_flow_schedule_rec.build_sequence = FND_API.G_MISS_NUM ) THEN
179: x_Flow_Schedule_Pvt_Rec.build_sequence := NULL;
180: ELSE
181: x_Flow_Schedule_Pvt_Rec.build_sequence := NVL(p_flow_schedule_rec.build_sequence , FND_API.G_MISS_NUM );
182: END IF;

Line 181: x_Flow_Schedule_Pvt_Rec.build_sequence := NVL(p_flow_schedule_rec.build_sequence , FND_API.G_MISS_NUM );

177:
178: IF ( p_flow_schedule_rec.build_sequence = FND_API.G_MISS_NUM ) THEN
179: x_Flow_Schedule_Pvt_Rec.build_sequence := NULL;
180: ELSE
181: x_Flow_Schedule_Pvt_Rec.build_sequence := NVL(p_flow_schedule_rec.build_sequence , FND_API.G_MISS_NUM );
182: END IF;
183:
184: IF ( p_flow_schedule_rec.class_code = FND_API.G_MISS_CHAR ) THEN
185: x_Flow_Schedule_Pvt_Rec.class_code := NULL;

Line 184: IF ( p_flow_schedule_rec.class_code = FND_API.G_MISS_CHAR ) THEN

180: ELSE
181: x_Flow_Schedule_Pvt_Rec.build_sequence := NVL(p_flow_schedule_rec.build_sequence , FND_API.G_MISS_NUM );
182: END IF;
183:
184: IF ( p_flow_schedule_rec.class_code = FND_API.G_MISS_CHAR ) THEN
185: x_Flow_Schedule_Pvt_Rec.class_code := NULL;
186: ELSE
187: x_Flow_Schedule_Pvt_Rec.class_code := nvl(p_flow_schedule_rec.class_code,FND_API.G_MISS_CHAR) ;
188: END IF;

Line 187: x_Flow_Schedule_Pvt_Rec.class_code := nvl(p_flow_schedule_rec.class_code,FND_API.G_MISS_CHAR) ;

183:
184: IF ( p_flow_schedule_rec.class_code = FND_API.G_MISS_CHAR ) THEN
185: x_Flow_Schedule_Pvt_Rec.class_code := NULL;
186: ELSE
187: x_Flow_Schedule_Pvt_Rec.class_code := nvl(p_flow_schedule_rec.class_code,FND_API.G_MISS_CHAR) ;
188: END IF;
189:
190: IF ( p_flow_schedule_rec.completion_locator_id = FND_API.G_MISS_NUM ) THEN
191: x_Flow_Schedule_Pvt_Rec.completion_locator_id := NULL;

Line 190: IF ( p_flow_schedule_rec.completion_locator_id = FND_API.G_MISS_NUM ) THEN

186: ELSE
187: x_Flow_Schedule_Pvt_Rec.class_code := nvl(p_flow_schedule_rec.class_code,FND_API.G_MISS_CHAR) ;
188: END IF;
189:
190: IF ( p_flow_schedule_rec.completion_locator_id = FND_API.G_MISS_NUM ) THEN
191: x_Flow_Schedule_Pvt_Rec.completion_locator_id := NULL;
192: ELSE
193: x_Flow_Schedule_Pvt_Rec.completion_locator_id := nvl(p_flow_schedule_rec.completion_locator_id,FND_API.G_MISS_NUM) ;
194: END IF;

Line 193: x_Flow_Schedule_Pvt_Rec.completion_locator_id := nvl(p_flow_schedule_rec.completion_locator_id,FND_API.G_MISS_NUM) ;

189:
190: IF ( p_flow_schedule_rec.completion_locator_id = FND_API.G_MISS_NUM ) THEN
191: x_Flow_Schedule_Pvt_Rec.completion_locator_id := NULL;
192: ELSE
193: x_Flow_Schedule_Pvt_Rec.completion_locator_id := nvl(p_flow_schedule_rec.completion_locator_id,FND_API.G_MISS_NUM) ;
194: END IF;
195:
196: IF ( p_flow_schedule_rec.completion_subinventory = FND_API.G_MISS_CHAR ) THEN
197: x_Flow_Schedule_Pvt_Rec.completion_subinventory := NULL;

Line 196: IF ( p_flow_schedule_rec.completion_subinventory = FND_API.G_MISS_CHAR ) THEN

192: ELSE
193: x_Flow_Schedule_Pvt_Rec.completion_locator_id := nvl(p_flow_schedule_rec.completion_locator_id,FND_API.G_MISS_NUM) ;
194: END IF;
195:
196: IF ( p_flow_schedule_rec.completion_subinventory = FND_API.G_MISS_CHAR ) THEN
197: x_Flow_Schedule_Pvt_Rec.completion_subinventory := NULL;
198: ELSE
199: x_Flow_Schedule_Pvt_Rec.completion_subinventory := nvl(p_flow_schedule_rec.completion_subinventory,FND_API.G_MISS_CHAR) ;
200: END IF;

Line 199: x_Flow_Schedule_Pvt_Rec.completion_subinventory := nvl(p_flow_schedule_rec.completion_subinventory,FND_API.G_MISS_CHAR) ;

195:
196: IF ( p_flow_schedule_rec.completion_subinventory = FND_API.G_MISS_CHAR ) THEN
197: x_Flow_Schedule_Pvt_Rec.completion_subinventory := NULL;
198: ELSE
199: x_Flow_Schedule_Pvt_Rec.completion_subinventory := nvl(p_flow_schedule_rec.completion_subinventory,FND_API.G_MISS_CHAR) ;
200: END IF;
201:
202: IF ( p_flow_schedule_rec.created_by = FND_API.G_MISS_NUM ) THEN
203: x_Flow_Schedule_Pvt_Rec.created_by := NULL;

Line 202: IF ( p_flow_schedule_rec.created_by = FND_API.G_MISS_NUM ) THEN

198: ELSE
199: x_Flow_Schedule_Pvt_Rec.completion_subinventory := nvl(p_flow_schedule_rec.completion_subinventory,FND_API.G_MISS_CHAR) ;
200: END IF;
201:
202: IF ( p_flow_schedule_rec.created_by = FND_API.G_MISS_NUM ) THEN
203: x_Flow_Schedule_Pvt_Rec.created_by := NULL;
204: ELSE
205: x_Flow_Schedule_Pvt_Rec.created_by := nvl(p_flow_schedule_rec.created_by,FND_API.G_MISS_NUM );
206: END IF;

Line 205: x_Flow_Schedule_Pvt_Rec.created_by := nvl(p_flow_schedule_rec.created_by,FND_API.G_MISS_NUM );

201:
202: IF ( p_flow_schedule_rec.created_by = FND_API.G_MISS_NUM ) THEN
203: x_Flow_Schedule_Pvt_Rec.created_by := NULL;
204: ELSE
205: x_Flow_Schedule_Pvt_Rec.created_by := nvl(p_flow_schedule_rec.created_by,FND_API.G_MISS_NUM );
206: END IF;
207:
208: IF ( p_flow_schedule_rec.creation_date = FND_API.G_MISS_DATE ) THEN
209: x_Flow_Schedule_Pvt_Rec.creation_date := NULL;

Line 208: IF ( p_flow_schedule_rec.creation_date = FND_API.G_MISS_DATE ) THEN

204: ELSE
205: x_Flow_Schedule_Pvt_Rec.created_by := nvl(p_flow_schedule_rec.created_by,FND_API.G_MISS_NUM );
206: END IF;
207:
208: IF ( p_flow_schedule_rec.creation_date = FND_API.G_MISS_DATE ) THEN
209: x_Flow_Schedule_Pvt_Rec.creation_date := NULL;
210: ELSE
211: x_Flow_Schedule_Pvt_Rec.creation_date := nvl(p_flow_schedule_rec.creation_date,FND_API.G_MISS_DATE ) ;
212: END IF;

Line 211: x_Flow_Schedule_Pvt_Rec.creation_date := nvl(p_flow_schedule_rec.creation_date,FND_API.G_MISS_DATE ) ;

207:
208: IF ( p_flow_schedule_rec.creation_date = FND_API.G_MISS_DATE ) THEN
209: x_Flow_Schedule_Pvt_Rec.creation_date := NULL;
210: ELSE
211: x_Flow_Schedule_Pvt_Rec.creation_date := nvl(p_flow_schedule_rec.creation_date,FND_API.G_MISS_DATE ) ;
212: END IF;
213:
214: IF ( p_flow_schedule_rec.date_closed = FND_API.G_MISS_DATE ) THEN
215: x_Flow_Schedule_Pvt_Rec.date_closed := NULL;

Line 214: IF ( p_flow_schedule_rec.date_closed = FND_API.G_MISS_DATE ) THEN

210: ELSE
211: x_Flow_Schedule_Pvt_Rec.creation_date := nvl(p_flow_schedule_rec.creation_date,FND_API.G_MISS_DATE ) ;
212: END IF;
213:
214: IF ( p_flow_schedule_rec.date_closed = FND_API.G_MISS_DATE ) THEN
215: x_Flow_Schedule_Pvt_Rec.date_closed := NULL;
216: ELSE
217: x_Flow_Schedule_Pvt_Rec.date_closed := nvl(p_flow_schedule_rec.date_closed,FND_API.G_MISS_DATE) ;
218: END IF;

Line 217: x_Flow_Schedule_Pvt_Rec.date_closed := nvl(p_flow_schedule_rec.date_closed,FND_API.G_MISS_DATE) ;

213:
214: IF ( p_flow_schedule_rec.date_closed = FND_API.G_MISS_DATE ) THEN
215: x_Flow_Schedule_Pvt_Rec.date_closed := NULL;
216: ELSE
217: x_Flow_Schedule_Pvt_Rec.date_closed := nvl(p_flow_schedule_rec.date_closed,FND_API.G_MISS_DATE) ;
218: END IF;
219:
220: IF ( p_flow_schedule_rec.demand_class = FND_API.G_MISS_CHAR ) THEN
221: x_Flow_Schedule_Pvt_Rec.demand_class := NULL;

Line 220: IF ( p_flow_schedule_rec.demand_class = FND_API.G_MISS_CHAR ) THEN

216: ELSE
217: x_Flow_Schedule_Pvt_Rec.date_closed := nvl(p_flow_schedule_rec.date_closed,FND_API.G_MISS_DATE) ;
218: END IF;
219:
220: IF ( p_flow_schedule_rec.demand_class = FND_API.G_MISS_CHAR ) THEN
221: x_Flow_Schedule_Pvt_Rec.demand_class := NULL;
222: ELSE
223: x_Flow_Schedule_Pvt_Rec.demand_class := nvl(p_flow_schedule_rec.demand_class ,FND_API.G_MISS_CHAR ) ;
224: END IF;

Line 223: x_Flow_Schedule_Pvt_Rec.demand_class := nvl(p_flow_schedule_rec.demand_class ,FND_API.G_MISS_CHAR ) ;

219:
220: IF ( p_flow_schedule_rec.demand_class = FND_API.G_MISS_CHAR ) THEN
221: x_Flow_Schedule_Pvt_Rec.demand_class := NULL;
222: ELSE
223: x_Flow_Schedule_Pvt_Rec.demand_class := nvl(p_flow_schedule_rec.demand_class ,FND_API.G_MISS_CHAR ) ;
224: END IF;
225:
226: IF ( p_flow_schedule_rec.demand_source_delivery = FND_API.G_MISS_CHAR ) THEN
227: x_Flow_Schedule_Pvt_Rec.demand_source_delivery := NULL;

Line 226: IF ( p_flow_schedule_rec.demand_source_delivery = FND_API.G_MISS_CHAR ) THEN

222: ELSE
223: x_Flow_Schedule_Pvt_Rec.demand_class := nvl(p_flow_schedule_rec.demand_class ,FND_API.G_MISS_CHAR ) ;
224: END IF;
225:
226: IF ( p_flow_schedule_rec.demand_source_delivery = FND_API.G_MISS_CHAR ) THEN
227: x_Flow_Schedule_Pvt_Rec.demand_source_delivery := NULL;
228: ELSE
229: x_Flow_Schedule_Pvt_Rec.demand_source_delivery := nvl(p_flow_schedule_rec.demand_source_delivery ,FND_API.G_MISS_CHAR) ;
230: END IF;

Line 229: x_Flow_Schedule_Pvt_Rec.demand_source_delivery := nvl(p_flow_schedule_rec.demand_source_delivery ,FND_API.G_MISS_CHAR) ;

225:
226: IF ( p_flow_schedule_rec.demand_source_delivery = FND_API.G_MISS_CHAR ) THEN
227: x_Flow_Schedule_Pvt_Rec.demand_source_delivery := NULL;
228: ELSE
229: x_Flow_Schedule_Pvt_Rec.demand_source_delivery := nvl(p_flow_schedule_rec.demand_source_delivery ,FND_API.G_MISS_CHAR) ;
230: END IF;
231:
232: IF ( p_flow_schedule_rec.demand_source_header_id = FND_API.G_MISS_NUM ) THEN
233: x_Flow_Schedule_Pvt_Rec.demand_source_header_id := NULL;

Line 232: IF ( p_flow_schedule_rec.demand_source_header_id = FND_API.G_MISS_NUM ) THEN

228: ELSE
229: x_Flow_Schedule_Pvt_Rec.demand_source_delivery := nvl(p_flow_schedule_rec.demand_source_delivery ,FND_API.G_MISS_CHAR) ;
230: END IF;
231:
232: IF ( p_flow_schedule_rec.demand_source_header_id = FND_API.G_MISS_NUM ) THEN
233: x_Flow_Schedule_Pvt_Rec.demand_source_header_id := NULL;
234: ELSE
235: x_Flow_Schedule_Pvt_Rec.demand_source_header_id := nvl(p_flow_schedule_rec.demand_source_header_id ,FND_API.G_MISS_NUM ) ;
236: END IF;

Line 235: x_Flow_Schedule_Pvt_Rec.demand_source_header_id := nvl(p_flow_schedule_rec.demand_source_header_id ,FND_API.G_MISS_NUM ) ;

231:
232: IF ( p_flow_schedule_rec.demand_source_header_id = FND_API.G_MISS_NUM ) THEN
233: x_Flow_Schedule_Pvt_Rec.demand_source_header_id := NULL;
234: ELSE
235: x_Flow_Schedule_Pvt_Rec.demand_source_header_id := nvl(p_flow_schedule_rec.demand_source_header_id ,FND_API.G_MISS_NUM ) ;
236: END IF;
237:
238: IF ( p_flow_schedule_rec.demand_source_line = FND_API.G_MISS_CHAR ) THEN
239: x_Flow_Schedule_Pvt_Rec.demand_source_line := NULL;

Line 238: IF ( p_flow_schedule_rec.demand_source_line = FND_API.G_MISS_CHAR ) THEN

234: ELSE
235: x_Flow_Schedule_Pvt_Rec.demand_source_header_id := nvl(p_flow_schedule_rec.demand_source_header_id ,FND_API.G_MISS_NUM ) ;
236: END IF;
237:
238: IF ( p_flow_schedule_rec.demand_source_line = FND_API.G_MISS_CHAR ) THEN
239: x_Flow_Schedule_Pvt_Rec.demand_source_line := NULL;
240: ELSE
241: x_Flow_Schedule_Pvt_Rec.demand_source_line := nvl(p_flow_schedule_rec.demand_source_line,FND_API.G_MISS_CHAR ) ;
242: END IF;

Line 241: x_Flow_Schedule_Pvt_Rec.demand_source_line := nvl(p_flow_schedule_rec.demand_source_line,FND_API.G_MISS_CHAR ) ;

237:
238: IF ( p_flow_schedule_rec.demand_source_line = FND_API.G_MISS_CHAR ) THEN
239: x_Flow_Schedule_Pvt_Rec.demand_source_line := NULL;
240: ELSE
241: x_Flow_Schedule_Pvt_Rec.demand_source_line := nvl(p_flow_schedule_rec.demand_source_line,FND_API.G_MISS_CHAR ) ;
242: END IF;
243:
244: IF ( p_flow_schedule_rec.demand_source_type = FND_API.G_MISS_NUM ) THEN
245: x_Flow_Schedule_Pvt_Rec.demand_source_type := NULL;

Line 244: IF ( p_flow_schedule_rec.demand_source_type = FND_API.G_MISS_NUM ) THEN

240: ELSE
241: x_Flow_Schedule_Pvt_Rec.demand_source_line := nvl(p_flow_schedule_rec.demand_source_line,FND_API.G_MISS_CHAR ) ;
242: END IF;
243:
244: IF ( p_flow_schedule_rec.demand_source_type = FND_API.G_MISS_NUM ) THEN
245: x_Flow_Schedule_Pvt_Rec.demand_source_type := NULL;
246: ELSE
247: x_Flow_Schedule_Pvt_Rec.demand_source_type := nvl(p_flow_schedule_rec.demand_source_type,FND_API.G_MISS_NUM ) ;
248: END IF;

Line 247: x_Flow_Schedule_Pvt_Rec.demand_source_type := nvl(p_flow_schedule_rec.demand_source_type,FND_API.G_MISS_NUM ) ;

243:
244: IF ( p_flow_schedule_rec.demand_source_type = FND_API.G_MISS_NUM ) THEN
245: x_Flow_Schedule_Pvt_Rec.demand_source_type := NULL;
246: ELSE
247: x_Flow_Schedule_Pvt_Rec.demand_source_type := nvl(p_flow_schedule_rec.demand_source_type,FND_API.G_MISS_NUM ) ;
248: END IF;
249:
250: IF ( p_flow_schedule_rec.last_updated_by = FND_API.G_MISS_NUM) THEN
251: x_Flow_Schedule_Pvt_Rec.last_updated_by := NULL;

Line 250: IF ( p_flow_schedule_rec.last_updated_by = FND_API.G_MISS_NUM) THEN

246: ELSE
247: x_Flow_Schedule_Pvt_Rec.demand_source_type := nvl(p_flow_schedule_rec.demand_source_type,FND_API.G_MISS_NUM ) ;
248: END IF;
249:
250: IF ( p_flow_schedule_rec.last_updated_by = FND_API.G_MISS_NUM) THEN
251: x_Flow_Schedule_Pvt_Rec.last_updated_by := NULL;
252: ELSE
253: x_Flow_Schedule_Pvt_Rec.last_updated_by := nvl(p_flow_schedule_rec.last_updated_by,FND_API.G_MISS_NUM) ;
254: END IF;

Line 253: x_Flow_Schedule_Pvt_Rec.last_updated_by := nvl(p_flow_schedule_rec.last_updated_by,FND_API.G_MISS_NUM) ;

249:
250: IF ( p_flow_schedule_rec.last_updated_by = FND_API.G_MISS_NUM) THEN
251: x_Flow_Schedule_Pvt_Rec.last_updated_by := NULL;
252: ELSE
253: x_Flow_Schedule_Pvt_Rec.last_updated_by := nvl(p_flow_schedule_rec.last_updated_by,FND_API.G_MISS_NUM) ;
254: END IF;
255:
256: IF ( p_flow_schedule_rec.last_update_date = FND_API.G_MISS_DATE ) THEN
257: x_Flow_Schedule_Pvt_Rec.last_update_date := NULL;

Line 256: IF ( p_flow_schedule_rec.last_update_date = FND_API.G_MISS_DATE ) THEN

252: ELSE
253: x_Flow_Schedule_Pvt_Rec.last_updated_by := nvl(p_flow_schedule_rec.last_updated_by,FND_API.G_MISS_NUM) ;
254: END IF;
255:
256: IF ( p_flow_schedule_rec.last_update_date = FND_API.G_MISS_DATE ) THEN
257: x_Flow_Schedule_Pvt_Rec.last_update_date := NULL;
258: ELSE
259: x_Flow_Schedule_Pvt_Rec.last_update_date := nvl(p_flow_schedule_rec.last_update_date,FND_API.G_MISS_DATE) ;
260: END IF;

Line 259: x_Flow_Schedule_Pvt_Rec.last_update_date := nvl(p_flow_schedule_rec.last_update_date,FND_API.G_MISS_DATE) ;

255:
256: IF ( p_flow_schedule_rec.last_update_date = FND_API.G_MISS_DATE ) THEN
257: x_Flow_Schedule_Pvt_Rec.last_update_date := NULL;
258: ELSE
259: x_Flow_Schedule_Pvt_Rec.last_update_date := nvl(p_flow_schedule_rec.last_update_date,FND_API.G_MISS_DATE) ;
260: END IF;
261:
262: IF ( p_flow_schedule_rec.last_update_login = FND_API.G_MISS_NUM ) THEN
263: x_Flow_Schedule_Pvt_Rec.last_update_login := NULL;

Line 262: IF ( p_flow_schedule_rec.last_update_login = FND_API.G_MISS_NUM ) THEN

258: ELSE
259: x_Flow_Schedule_Pvt_Rec.last_update_date := nvl(p_flow_schedule_rec.last_update_date,FND_API.G_MISS_DATE) ;
260: END IF;
261:
262: IF ( p_flow_schedule_rec.last_update_login = FND_API.G_MISS_NUM ) THEN
263: x_Flow_Schedule_Pvt_Rec.last_update_login := NULL;
264: ELSE
265: x_Flow_Schedule_Pvt_Rec.last_update_login := nvl(p_flow_schedule_rec.last_update_login,FND_API.G_MISS_NUM) ;
266: END IF;

Line 265: x_Flow_Schedule_Pvt_Rec.last_update_login := nvl(p_flow_schedule_rec.last_update_login,FND_API.G_MISS_NUM) ;

261:
262: IF ( p_flow_schedule_rec.last_update_login = FND_API.G_MISS_NUM ) THEN
263: x_Flow_Schedule_Pvt_Rec.last_update_login := NULL;
264: ELSE
265: x_Flow_Schedule_Pvt_Rec.last_update_login := nvl(p_flow_schedule_rec.last_update_login,FND_API.G_MISS_NUM) ;
266: END IF;
267:
268: IF ( p_flow_schedule_rec.line_id = FND_API.G_MISS_NUM ) THEN
269: x_Flow_Schedule_Pvt_Rec.line_id := NULL;

Line 268: IF ( p_flow_schedule_rec.line_id = FND_API.G_MISS_NUM ) THEN

264: ELSE
265: x_Flow_Schedule_Pvt_Rec.last_update_login := nvl(p_flow_schedule_rec.last_update_login,FND_API.G_MISS_NUM) ;
266: END IF;
267:
268: IF ( p_flow_schedule_rec.line_id = FND_API.G_MISS_NUM ) THEN
269: x_Flow_Schedule_Pvt_Rec.line_id := NULL;
270: ELSE
271: x_Flow_Schedule_Pvt_Rec.line_id := nvl(p_flow_schedule_rec.line_id ,FND_API.G_MISS_NUM) ;
272: END IF;

Line 271: x_Flow_Schedule_Pvt_Rec.line_id := nvl(p_flow_schedule_rec.line_id ,FND_API.G_MISS_NUM) ;

267:
268: IF ( p_flow_schedule_rec.line_id = FND_API.G_MISS_NUM ) THEN
269: x_Flow_Schedule_Pvt_Rec.line_id := NULL;
270: ELSE
271: x_Flow_Schedule_Pvt_Rec.line_id := nvl(p_flow_schedule_rec.line_id ,FND_API.G_MISS_NUM) ;
272: END IF;
273:
274: IF ( p_flow_schedule_rec.material_account = FND_API.G_MISS_NUM ) THEN
275: x_Flow_Schedule_Pvt_Rec.material_account := NULL;

Line 274: IF ( p_flow_schedule_rec.material_account = FND_API.G_MISS_NUM ) THEN

270: ELSE
271: x_Flow_Schedule_Pvt_Rec.line_id := nvl(p_flow_schedule_rec.line_id ,FND_API.G_MISS_NUM) ;
272: END IF;
273:
274: IF ( p_flow_schedule_rec.material_account = FND_API.G_MISS_NUM ) THEN
275: x_Flow_Schedule_Pvt_Rec.material_account := NULL;
276: ELSE
277: x_Flow_Schedule_Pvt_Rec.material_account := nvl(p_flow_schedule_rec.material_account,FND_API.G_MISS_NUM ) ;
278: END IF;

Line 277: x_Flow_Schedule_Pvt_Rec.material_account := nvl(p_flow_schedule_rec.material_account,FND_API.G_MISS_NUM ) ;

273:
274: IF ( p_flow_schedule_rec.material_account = FND_API.G_MISS_NUM ) THEN
275: x_Flow_Schedule_Pvt_Rec.material_account := NULL;
276: ELSE
277: x_Flow_Schedule_Pvt_Rec.material_account := nvl(p_flow_schedule_rec.material_account,FND_API.G_MISS_NUM ) ;
278: END IF;
279:
280: IF ( p_flow_schedule_rec.material_overhead_account = FND_API.G_MISS_NUM ) THEN
281: x_Flow_Schedule_Pvt_Rec.material_overhead_account := NULL;

Line 280: IF ( p_flow_schedule_rec.material_overhead_account = FND_API.G_MISS_NUM ) THEN

276: ELSE
277: x_Flow_Schedule_Pvt_Rec.material_account := nvl(p_flow_schedule_rec.material_account,FND_API.G_MISS_NUM ) ;
278: END IF;
279:
280: IF ( p_flow_schedule_rec.material_overhead_account = FND_API.G_MISS_NUM ) THEN
281: x_Flow_Schedule_Pvt_Rec.material_overhead_account := NULL;
282: ELSE
283: x_Flow_Schedule_Pvt_Rec.material_overhead_account := nvl(p_flow_schedule_rec.material_overhead_account,FND_API.G_MISS_NUM ) ;
284: END IF;

Line 283: x_Flow_Schedule_Pvt_Rec.material_overhead_account := nvl(p_flow_schedule_rec.material_overhead_account,FND_API.G_MISS_NUM ) ;

279:
280: IF ( p_flow_schedule_rec.material_overhead_account = FND_API.G_MISS_NUM ) THEN
281: x_Flow_Schedule_Pvt_Rec.material_overhead_account := NULL;
282: ELSE
283: x_Flow_Schedule_Pvt_Rec.material_overhead_account := nvl(p_flow_schedule_rec.material_overhead_account,FND_API.G_MISS_NUM ) ;
284: END IF;
285:
286: IF ( p_flow_schedule_rec.material_variance_account = FND_API.G_MISS_NUM ) THEN
287: x_Flow_Schedule_Pvt_Rec.material_variance_account := NULL;

Line 286: IF ( p_flow_schedule_rec.material_variance_account = FND_API.G_MISS_NUM ) THEN

282: ELSE
283: x_Flow_Schedule_Pvt_Rec.material_overhead_account := nvl(p_flow_schedule_rec.material_overhead_account,FND_API.G_MISS_NUM ) ;
284: END IF;
285:
286: IF ( p_flow_schedule_rec.material_variance_account = FND_API.G_MISS_NUM ) THEN
287: x_Flow_Schedule_Pvt_Rec.material_variance_account := NULL;
288: ELSE
289: x_Flow_Schedule_Pvt_Rec.material_variance_account := nvl(p_flow_schedule_rec.material_variance_account ,FND_API.G_MISS_NUM ) ;
290: END IF;

Line 289: x_Flow_Schedule_Pvt_Rec.material_variance_account := nvl(p_flow_schedule_rec.material_variance_account ,FND_API.G_MISS_NUM ) ;

285:
286: IF ( p_flow_schedule_rec.material_variance_account = FND_API.G_MISS_NUM ) THEN
287: x_Flow_Schedule_Pvt_Rec.material_variance_account := NULL;
288: ELSE
289: x_Flow_Schedule_Pvt_Rec.material_variance_account := nvl(p_flow_schedule_rec.material_variance_account ,FND_API.G_MISS_NUM ) ;
290: END IF;
291:
292: IF ( p_flow_schedule_rec.mps_net_quantity = FND_API.G_MISS_NUM ) THEN
293: x_Flow_Schedule_Pvt_Rec.mps_net_quantity := NULL;

Line 292: IF ( p_flow_schedule_rec.mps_net_quantity = FND_API.G_MISS_NUM ) THEN

288: ELSE
289: x_Flow_Schedule_Pvt_Rec.material_variance_account := nvl(p_flow_schedule_rec.material_variance_account ,FND_API.G_MISS_NUM ) ;
290: END IF;
291:
292: IF ( p_flow_schedule_rec.mps_net_quantity = FND_API.G_MISS_NUM ) THEN
293: x_Flow_Schedule_Pvt_Rec.mps_net_quantity := NULL;
294: ELSE
295: x_Flow_Schedule_Pvt_Rec.mps_net_quantity := nvl(p_flow_schedule_rec.mps_net_quantity,FND_API.G_MISS_NUM ) ;
296: END IF;

Line 295: x_Flow_Schedule_Pvt_Rec.mps_net_quantity := nvl(p_flow_schedule_rec.mps_net_quantity,FND_API.G_MISS_NUM ) ;

291:
292: IF ( p_flow_schedule_rec.mps_net_quantity = FND_API.G_MISS_NUM ) THEN
293: x_Flow_Schedule_Pvt_Rec.mps_net_quantity := NULL;
294: ELSE
295: x_Flow_Schedule_Pvt_Rec.mps_net_quantity := nvl(p_flow_schedule_rec.mps_net_quantity,FND_API.G_MISS_NUM ) ;
296: END IF;
297:
298: IF ( p_flow_schedule_rec.mps_scheduled_comp_date = FND_API.G_MISS_DATE) THEN
299: x_Flow_Schedule_Pvt_Rec.mps_scheduled_comp_date := NULL;

Line 298: IF ( p_flow_schedule_rec.mps_scheduled_comp_date = FND_API.G_MISS_DATE) THEN

294: ELSE
295: x_Flow_Schedule_Pvt_Rec.mps_net_quantity := nvl(p_flow_schedule_rec.mps_net_quantity,FND_API.G_MISS_NUM ) ;
296: END IF;
297:
298: IF ( p_flow_schedule_rec.mps_scheduled_comp_date = FND_API.G_MISS_DATE) THEN
299: x_Flow_Schedule_Pvt_Rec.mps_scheduled_comp_date := NULL;
300: ELSE
301: x_Flow_Schedule_Pvt_Rec.mps_scheduled_comp_date := nvl(p_flow_schedule_rec.mps_scheduled_comp_date,FND_API.G_MISS_DATE) ;
302: END IF;

Line 301: x_Flow_Schedule_Pvt_Rec.mps_scheduled_comp_date := nvl(p_flow_schedule_rec.mps_scheduled_comp_date,FND_API.G_MISS_DATE) ;

297:
298: IF ( p_flow_schedule_rec.mps_scheduled_comp_date = FND_API.G_MISS_DATE) THEN
299: x_Flow_Schedule_Pvt_Rec.mps_scheduled_comp_date := NULL;
300: ELSE
301: x_Flow_Schedule_Pvt_Rec.mps_scheduled_comp_date := nvl(p_flow_schedule_rec.mps_scheduled_comp_date,FND_API.G_MISS_DATE) ;
302: END IF;
303:
304: IF ( p_flow_schedule_rec.organization_id = FND_API.G_MISS_NUM ) THEN
305: x_Flow_Schedule_Pvt_Rec.organization_id := NULL;

Line 304: IF ( p_flow_schedule_rec.organization_id = FND_API.G_MISS_NUM ) THEN

300: ELSE
301: x_Flow_Schedule_Pvt_Rec.mps_scheduled_comp_date := nvl(p_flow_schedule_rec.mps_scheduled_comp_date,FND_API.G_MISS_DATE) ;
302: END IF;
303:
304: IF ( p_flow_schedule_rec.organization_id = FND_API.G_MISS_NUM ) THEN
305: x_Flow_Schedule_Pvt_Rec.organization_id := NULL;
306: ELSE
307: x_Flow_Schedule_Pvt_Rec.organization_id := nvl(p_flow_schedule_rec.organization_id,FND_API.G_MISS_NUM) ;
308: END IF;

Line 307: x_Flow_Schedule_Pvt_Rec.organization_id := nvl(p_flow_schedule_rec.organization_id,FND_API.G_MISS_NUM) ;

303:
304: IF ( p_flow_schedule_rec.organization_id = FND_API.G_MISS_NUM ) THEN
305: x_Flow_Schedule_Pvt_Rec.organization_id := NULL;
306: ELSE
307: x_Flow_Schedule_Pvt_Rec.organization_id := nvl(p_flow_schedule_rec.organization_id,FND_API.G_MISS_NUM) ;
308: END IF;
309:
310: IF ( p_flow_schedule_rec.outside_processing_acct = FND_API.G_MISS_NUM) THEN
311: x_Flow_Schedule_Pvt_Rec.outside_processing_acct := NULL;

Line 310: IF ( p_flow_schedule_rec.outside_processing_acct = FND_API.G_MISS_NUM) THEN

306: ELSE
307: x_Flow_Schedule_Pvt_Rec.organization_id := nvl(p_flow_schedule_rec.organization_id,FND_API.G_MISS_NUM) ;
308: END IF;
309:
310: IF ( p_flow_schedule_rec.outside_processing_acct = FND_API.G_MISS_NUM) THEN
311: x_Flow_Schedule_Pvt_Rec.outside_processing_acct := NULL;
312: ELSE
313: x_Flow_Schedule_Pvt_Rec.outside_processing_acct := nvl(p_flow_schedule_rec.outside_processing_acct,FND_API.G_MISS_NUM) ;
314: END IF;

Line 313: x_Flow_Schedule_Pvt_Rec.outside_processing_acct := nvl(p_flow_schedule_rec.outside_processing_acct,FND_API.G_MISS_NUM) ;

309:
310: IF ( p_flow_schedule_rec.outside_processing_acct = FND_API.G_MISS_NUM) THEN
311: x_Flow_Schedule_Pvt_Rec.outside_processing_acct := NULL;
312: ELSE
313: x_Flow_Schedule_Pvt_Rec.outside_processing_acct := nvl(p_flow_schedule_rec.outside_processing_acct,FND_API.G_MISS_NUM) ;
314: END IF;
315:
316: IF ( p_flow_schedule_rec.outside_proc_var_acct = FND_API.G_MISS_NUM ) THEN
317: x_Flow_Schedule_Pvt_Rec.outside_proc_var_acct := NULL;

Line 316: IF ( p_flow_schedule_rec.outside_proc_var_acct = FND_API.G_MISS_NUM ) THEN

312: ELSE
313: x_Flow_Schedule_Pvt_Rec.outside_processing_acct := nvl(p_flow_schedule_rec.outside_processing_acct,FND_API.G_MISS_NUM) ;
314: END IF;
315:
316: IF ( p_flow_schedule_rec.outside_proc_var_acct = FND_API.G_MISS_NUM ) THEN
317: x_Flow_Schedule_Pvt_Rec.outside_proc_var_acct := NULL;
318: ELSE
319: x_Flow_Schedule_Pvt_Rec.outside_proc_var_acct := nvl(p_flow_schedule_rec.outside_proc_var_acct,FND_API.G_MISS_NUM) ;
320: END IF;

Line 319: x_Flow_Schedule_Pvt_Rec.outside_proc_var_acct := nvl(p_flow_schedule_rec.outside_proc_var_acct,FND_API.G_MISS_NUM) ;

315:
316: IF ( p_flow_schedule_rec.outside_proc_var_acct = FND_API.G_MISS_NUM ) THEN
317: x_Flow_Schedule_Pvt_Rec.outside_proc_var_acct := NULL;
318: ELSE
319: x_Flow_Schedule_Pvt_Rec.outside_proc_var_acct := nvl(p_flow_schedule_rec.outside_proc_var_acct,FND_API.G_MISS_NUM) ;
320: END IF;
321:
322: IF ( p_flow_schedule_rec.overhead_account = FND_API.G_MISS_NUM ) THEN
323: x_Flow_Schedule_Pvt_Rec.overhead_account := NULL;

Line 322: IF ( p_flow_schedule_rec.overhead_account = FND_API.G_MISS_NUM ) THEN

318: ELSE
319: x_Flow_Schedule_Pvt_Rec.outside_proc_var_acct := nvl(p_flow_schedule_rec.outside_proc_var_acct,FND_API.G_MISS_NUM) ;
320: END IF;
321:
322: IF ( p_flow_schedule_rec.overhead_account = FND_API.G_MISS_NUM ) THEN
323: x_Flow_Schedule_Pvt_Rec.overhead_account := NULL;
324: ELSE
325: x_Flow_Schedule_Pvt_Rec.overhead_account := nvl(p_flow_schedule_rec.overhead_account,FND_API.G_MISS_NUM ) ;
326: END IF;

Line 325: x_Flow_Schedule_Pvt_Rec.overhead_account := nvl(p_flow_schedule_rec.overhead_account,FND_API.G_MISS_NUM ) ;

321:
322: IF ( p_flow_schedule_rec.overhead_account = FND_API.G_MISS_NUM ) THEN
323: x_Flow_Schedule_Pvt_Rec.overhead_account := NULL;
324: ELSE
325: x_Flow_Schedule_Pvt_Rec.overhead_account := nvl(p_flow_schedule_rec.overhead_account,FND_API.G_MISS_NUM ) ;
326: END IF;
327:
328: IF ( p_flow_schedule_rec.overhead_variance_account= FND_API.G_MISS_NUM ) THEN
329: x_Flow_Schedule_Pvt_Rec.overhead_variance_account:= NULL;

Line 328: IF ( p_flow_schedule_rec.overhead_variance_account= FND_API.G_MISS_NUM ) THEN

324: ELSE
325: x_Flow_Schedule_Pvt_Rec.overhead_account := nvl(p_flow_schedule_rec.overhead_account,FND_API.G_MISS_NUM ) ;
326: END IF;
327:
328: IF ( p_flow_schedule_rec.overhead_variance_account= FND_API.G_MISS_NUM ) THEN
329: x_Flow_Schedule_Pvt_Rec.overhead_variance_account:= NULL;
330: ELSE
331: x_Flow_Schedule_Pvt_Rec.overhead_variance_account:= nvl(p_flow_schedule_rec.overhead_variance_account,FND_API.G_MISS_NUM );
332: END IF;

Line 331: x_Flow_Schedule_Pvt_Rec.overhead_variance_account:= nvl(p_flow_schedule_rec.overhead_variance_account,FND_API.G_MISS_NUM );

327:
328: IF ( p_flow_schedule_rec.overhead_variance_account= FND_API.G_MISS_NUM ) THEN
329: x_Flow_Schedule_Pvt_Rec.overhead_variance_account:= NULL;
330: ELSE
331: x_Flow_Schedule_Pvt_Rec.overhead_variance_account:= nvl(p_flow_schedule_rec.overhead_variance_account,FND_API.G_MISS_NUM );
332: END IF;
333:
334: IF ( p_flow_schedule_rec.planned_quantity = FND_API.G_MISS_NUM ) THEN
335: x_Flow_Schedule_Pvt_Rec.planned_quantity := NULL;

Line 334: IF ( p_flow_schedule_rec.planned_quantity = FND_API.G_MISS_NUM ) THEN

330: ELSE
331: x_Flow_Schedule_Pvt_Rec.overhead_variance_account:= nvl(p_flow_schedule_rec.overhead_variance_account,FND_API.G_MISS_NUM );
332: END IF;
333:
334: IF ( p_flow_schedule_rec.planned_quantity = FND_API.G_MISS_NUM ) THEN
335: x_Flow_Schedule_Pvt_Rec.planned_quantity := NULL;
336: ELSE
337: x_Flow_Schedule_Pvt_Rec.planned_quantity := nvl(p_flow_schedule_rec.planned_quantity,FND_API.G_MISS_NUM ) ;
338: END IF;

Line 337: x_Flow_Schedule_Pvt_Rec.planned_quantity := nvl(p_flow_schedule_rec.planned_quantity,FND_API.G_MISS_NUM ) ;

333:
334: IF ( p_flow_schedule_rec.planned_quantity = FND_API.G_MISS_NUM ) THEN
335: x_Flow_Schedule_Pvt_Rec.planned_quantity := NULL;
336: ELSE
337: x_Flow_Schedule_Pvt_Rec.planned_quantity := nvl(p_flow_schedule_rec.planned_quantity,FND_API.G_MISS_NUM ) ;
338: END IF;
339:
340: IF ( p_flow_schedule_rec.primary_item_id = FND_API.G_MISS_NUM ) THEN
341: x_Flow_Schedule_Pvt_Rec.primary_item_id := NULL;

Line 340: IF ( p_flow_schedule_rec.primary_item_id = FND_API.G_MISS_NUM ) THEN

336: ELSE
337: x_Flow_Schedule_Pvt_Rec.planned_quantity := nvl(p_flow_schedule_rec.planned_quantity,FND_API.G_MISS_NUM ) ;
338: END IF;
339:
340: IF ( p_flow_schedule_rec.primary_item_id = FND_API.G_MISS_NUM ) THEN
341: x_Flow_Schedule_Pvt_Rec.primary_item_id := NULL;
342: ELSE
343: x_Flow_Schedule_Pvt_Rec.primary_item_id := nvl(p_flow_schedule_rec.primary_item_id,FND_API.G_MISS_NUM ) ;
344: END IF;

Line 343: x_Flow_Schedule_Pvt_Rec.primary_item_id := nvl(p_flow_schedule_rec.primary_item_id,FND_API.G_MISS_NUM ) ;

339:
340: IF ( p_flow_schedule_rec.primary_item_id = FND_API.G_MISS_NUM ) THEN
341: x_Flow_Schedule_Pvt_Rec.primary_item_id := NULL;
342: ELSE
343: x_Flow_Schedule_Pvt_Rec.primary_item_id := nvl(p_flow_schedule_rec.primary_item_id,FND_API.G_MISS_NUM ) ;
344: END IF;
345:
346: IF ( p_flow_schedule_rec.program_application_id= FND_API.G_MISS_NUM ) THEN
347: x_Flow_Schedule_Pvt_Rec.program_application_id:= NULL;

Line 346: IF ( p_flow_schedule_rec.program_application_id= FND_API.G_MISS_NUM ) THEN

342: ELSE
343: x_Flow_Schedule_Pvt_Rec.primary_item_id := nvl(p_flow_schedule_rec.primary_item_id,FND_API.G_MISS_NUM ) ;
344: END IF;
345:
346: IF ( p_flow_schedule_rec.program_application_id= FND_API.G_MISS_NUM ) THEN
347: x_Flow_Schedule_Pvt_Rec.program_application_id:= NULL;
348: ELSE
349: x_Flow_Schedule_Pvt_Rec.program_application_id:= nvl(p_flow_schedule_rec.program_application_id,FND_API.G_MISS_NUM );
350: END IF;

Line 349: x_Flow_Schedule_Pvt_Rec.program_application_id:= nvl(p_flow_schedule_rec.program_application_id,FND_API.G_MISS_NUM );

345:
346: IF ( p_flow_schedule_rec.program_application_id= FND_API.G_MISS_NUM ) THEN
347: x_Flow_Schedule_Pvt_Rec.program_application_id:= NULL;
348: ELSE
349: x_Flow_Schedule_Pvt_Rec.program_application_id:= nvl(p_flow_schedule_rec.program_application_id,FND_API.G_MISS_NUM );
350: END IF;
351:
352: IF ( p_flow_schedule_rec.program_id = FND_API.G_MISS_NUM ) THEN
353: x_Flow_Schedule_Pvt_Rec.program_id := NULL;

Line 352: IF ( p_flow_schedule_rec.program_id = FND_API.G_MISS_NUM ) THEN

348: ELSE
349: x_Flow_Schedule_Pvt_Rec.program_application_id:= nvl(p_flow_schedule_rec.program_application_id,FND_API.G_MISS_NUM );
350: END IF;
351:
352: IF ( p_flow_schedule_rec.program_id = FND_API.G_MISS_NUM ) THEN
353: x_Flow_Schedule_Pvt_Rec.program_id := NULL;
354: ELSE
355: x_Flow_Schedule_Pvt_Rec.program_id := nvl(p_flow_schedule_rec.program_id ,FND_API.G_MISS_NUM ) ;
356: END IF;

Line 355: x_Flow_Schedule_Pvt_Rec.program_id := nvl(p_flow_schedule_rec.program_id ,FND_API.G_MISS_NUM ) ;

351:
352: IF ( p_flow_schedule_rec.program_id = FND_API.G_MISS_NUM ) THEN
353: x_Flow_Schedule_Pvt_Rec.program_id := NULL;
354: ELSE
355: x_Flow_Schedule_Pvt_Rec.program_id := nvl(p_flow_schedule_rec.program_id ,FND_API.G_MISS_NUM ) ;
356: END IF;
357:
358: IF ( p_flow_schedule_rec.program_update_date = FND_API.G_MISS_DATE ) THEN
359: x_Flow_Schedule_Pvt_Rec.program_update_date := NULL;

Line 358: IF ( p_flow_schedule_rec.program_update_date = FND_API.G_MISS_DATE ) THEN

354: ELSE
355: x_Flow_Schedule_Pvt_Rec.program_id := nvl(p_flow_schedule_rec.program_id ,FND_API.G_MISS_NUM ) ;
356: END IF;
357:
358: IF ( p_flow_schedule_rec.program_update_date = FND_API.G_MISS_DATE ) THEN
359: x_Flow_Schedule_Pvt_Rec.program_update_date := NULL;
360: ELSE
361: x_Flow_Schedule_Pvt_Rec.program_update_date := nvl(p_flow_schedule_rec.program_update_date,FND_API.G_MISS_DATE) ;
362: END IF;

Line 361: x_Flow_Schedule_Pvt_Rec.program_update_date := nvl(p_flow_schedule_rec.program_update_date,FND_API.G_MISS_DATE) ;

357:
358: IF ( p_flow_schedule_rec.program_update_date = FND_API.G_MISS_DATE ) THEN
359: x_Flow_Schedule_Pvt_Rec.program_update_date := NULL;
360: ELSE
361: x_Flow_Schedule_Pvt_Rec.program_update_date := nvl(p_flow_schedule_rec.program_update_date,FND_API.G_MISS_DATE) ;
362: END IF;
363:
364: IF ( p_flow_schedule_rec.project_id = FND_API.G_MISS_NUM ) THEN
365: x_Flow_Schedule_Pvt_Rec.project_id := NULL;

Line 364: IF ( p_flow_schedule_rec.project_id = FND_API.G_MISS_NUM ) THEN

360: ELSE
361: x_Flow_Schedule_Pvt_Rec.program_update_date := nvl(p_flow_schedule_rec.program_update_date,FND_API.G_MISS_DATE) ;
362: END IF;
363:
364: IF ( p_flow_schedule_rec.project_id = FND_API.G_MISS_NUM ) THEN
365: x_Flow_Schedule_Pvt_Rec.project_id := NULL;
366: ELSE
367: x_Flow_Schedule_Pvt_Rec.project_id := nvl(p_flow_schedule_rec.project_id,FND_API.G_MISS_NUM) ;
368: END IF;

Line 367: x_Flow_Schedule_Pvt_Rec.project_id := nvl(p_flow_schedule_rec.project_id,FND_API.G_MISS_NUM) ;

363:
364: IF ( p_flow_schedule_rec.project_id = FND_API.G_MISS_NUM ) THEN
365: x_Flow_Schedule_Pvt_Rec.project_id := NULL;
366: ELSE
367: x_Flow_Schedule_Pvt_Rec.project_id := nvl(p_flow_schedule_rec.project_id,FND_API.G_MISS_NUM) ;
368: END IF;
369:
370: IF ( p_flow_schedule_rec.quantity_completed = FND_API.G_MISS_NUM) THEN
371: x_Flow_Schedule_Pvt_Rec.quantity_completed := NULL;

Line 370: IF ( p_flow_schedule_rec.quantity_completed = FND_API.G_MISS_NUM) THEN

366: ELSE
367: x_Flow_Schedule_Pvt_Rec.project_id := nvl(p_flow_schedule_rec.project_id,FND_API.G_MISS_NUM) ;
368: END IF;
369:
370: IF ( p_flow_schedule_rec.quantity_completed = FND_API.G_MISS_NUM) THEN
371: x_Flow_Schedule_Pvt_Rec.quantity_completed := NULL;
372: ELSE
373: x_Flow_Schedule_Pvt_Rec.quantity_completed := nvl(p_flow_schedule_rec.quantity_completed ,FND_API.G_MISS_NUM) ;
374: END IF;

Line 373: x_Flow_Schedule_Pvt_Rec.quantity_completed := nvl(p_flow_schedule_rec.quantity_completed ,FND_API.G_MISS_NUM) ;

369:
370: IF ( p_flow_schedule_rec.quantity_completed = FND_API.G_MISS_NUM) THEN
371: x_Flow_Schedule_Pvt_Rec.quantity_completed := NULL;
372: ELSE
373: x_Flow_Schedule_Pvt_Rec.quantity_completed := nvl(p_flow_schedule_rec.quantity_completed ,FND_API.G_MISS_NUM) ;
374: END IF;
375:
376: IF ( p_flow_schedule_rec.request_id = FND_API.G_MISS_NUM) THEN
377: x_Flow_Schedule_Pvt_Rec.request_id := NULL;

Line 376: IF ( p_flow_schedule_rec.request_id = FND_API.G_MISS_NUM) THEN

372: ELSE
373: x_Flow_Schedule_Pvt_Rec.quantity_completed := nvl(p_flow_schedule_rec.quantity_completed ,FND_API.G_MISS_NUM) ;
374: END IF;
375:
376: IF ( p_flow_schedule_rec.request_id = FND_API.G_MISS_NUM) THEN
377: x_Flow_Schedule_Pvt_Rec.request_id := NULL;
378: ELSE
379: x_Flow_Schedule_Pvt_Rec.request_id := nvl(p_flow_schedule_rec.request_id ,FND_API.G_MISS_NUM) ;
380: END IF;

Line 379: x_Flow_Schedule_Pvt_Rec.request_id := nvl(p_flow_schedule_rec.request_id ,FND_API.G_MISS_NUM) ;

375:
376: IF ( p_flow_schedule_rec.request_id = FND_API.G_MISS_NUM) THEN
377: x_Flow_Schedule_Pvt_Rec.request_id := NULL;
378: ELSE
379: x_Flow_Schedule_Pvt_Rec.request_id := nvl(p_flow_schedule_rec.request_id ,FND_API.G_MISS_NUM) ;
380: END IF;
381:
382: IF ( p_flow_schedule_rec.resource_account = FND_API.G_MISS_NUM) THEN
383: x_Flow_Schedule_Pvt_Rec.resource_account := NULL;

Line 382: IF ( p_flow_schedule_rec.resource_account = FND_API.G_MISS_NUM) THEN

378: ELSE
379: x_Flow_Schedule_Pvt_Rec.request_id := nvl(p_flow_schedule_rec.request_id ,FND_API.G_MISS_NUM) ;
380: END IF;
381:
382: IF ( p_flow_schedule_rec.resource_account = FND_API.G_MISS_NUM) THEN
383: x_Flow_Schedule_Pvt_Rec.resource_account := NULL;
384: ELSE
385: x_Flow_Schedule_Pvt_Rec.resource_account := nvl(p_flow_schedule_rec.resource_account ,FND_API.G_MISS_NUM) ;
386: END IF;

Line 385: x_Flow_Schedule_Pvt_Rec.resource_account := nvl(p_flow_schedule_rec.resource_account ,FND_API.G_MISS_NUM) ;

381:
382: IF ( p_flow_schedule_rec.resource_account = FND_API.G_MISS_NUM) THEN
383: x_Flow_Schedule_Pvt_Rec.resource_account := NULL;
384: ELSE
385: x_Flow_Schedule_Pvt_Rec.resource_account := nvl(p_flow_schedule_rec.resource_account ,FND_API.G_MISS_NUM) ;
386: END IF;
387:
388: IF ( p_flow_schedule_rec.resource_variance_account = FND_API.G_MISS_NUM) THEN
389: x_Flow_Schedule_Pvt_Rec.resource_variance_account := NULL;

Line 388: IF ( p_flow_schedule_rec.resource_variance_account = FND_API.G_MISS_NUM) THEN

384: ELSE
385: x_Flow_Schedule_Pvt_Rec.resource_account := nvl(p_flow_schedule_rec.resource_account ,FND_API.G_MISS_NUM) ;
386: END IF;
387:
388: IF ( p_flow_schedule_rec.resource_variance_account = FND_API.G_MISS_NUM) THEN
389: x_Flow_Schedule_Pvt_Rec.resource_variance_account := NULL;
390: ELSE
391: x_Flow_Schedule_Pvt_Rec.resource_variance_account := nvl(p_flow_schedule_rec.resource_variance_account,FND_API.G_MISS_NUM) ;
392: END IF;

Line 391: x_Flow_Schedule_Pvt_Rec.resource_variance_account := nvl(p_flow_schedule_rec.resource_variance_account,FND_API.G_MISS_NUM) ;

387:
388: IF ( p_flow_schedule_rec.resource_variance_account = FND_API.G_MISS_NUM) THEN
389: x_Flow_Schedule_Pvt_Rec.resource_variance_account := NULL;
390: ELSE
391: x_Flow_Schedule_Pvt_Rec.resource_variance_account := nvl(p_flow_schedule_rec.resource_variance_account,FND_API.G_MISS_NUM) ;
392: END IF;
393:
394: IF ( p_flow_schedule_rec.routing_revision = FND_API.G_MISS_CHAR ) THEN
395: x_Flow_Schedule_Pvt_Rec.routing_revision := NULL;

Line 394: IF ( p_flow_schedule_rec.routing_revision = FND_API.G_MISS_CHAR ) THEN

390: ELSE
391: x_Flow_Schedule_Pvt_Rec.resource_variance_account := nvl(p_flow_schedule_rec.resource_variance_account,FND_API.G_MISS_NUM) ;
392: END IF;
393:
394: IF ( p_flow_schedule_rec.routing_revision = FND_API.G_MISS_CHAR ) THEN
395: x_Flow_Schedule_Pvt_Rec.routing_revision := NULL;
396: ELSE
397: x_Flow_Schedule_Pvt_Rec.routing_revision := nvl(p_flow_schedule_rec.routing_revision ,FND_API.G_MISS_CHAR ) ;
398: END IF;

Line 397: x_Flow_Schedule_Pvt_Rec.routing_revision := nvl(p_flow_schedule_rec.routing_revision ,FND_API.G_MISS_CHAR ) ;

393:
394: IF ( p_flow_schedule_rec.routing_revision = FND_API.G_MISS_CHAR ) THEN
395: x_Flow_Schedule_Pvt_Rec.routing_revision := NULL;
396: ELSE
397: x_Flow_Schedule_Pvt_Rec.routing_revision := nvl(p_flow_schedule_rec.routing_revision ,FND_API.G_MISS_CHAR ) ;
398: END IF;
399:
400: IF ( p_flow_schedule_rec.routing_revision_date= FND_API.G_MISS_DATE ) THEN
401: x_Flow_Schedule_Pvt_Rec.routing_revision_date := NULL;

Line 400: IF ( p_flow_schedule_rec.routing_revision_date= FND_API.G_MISS_DATE ) THEN

396: ELSE
397: x_Flow_Schedule_Pvt_Rec.routing_revision := nvl(p_flow_schedule_rec.routing_revision ,FND_API.G_MISS_CHAR ) ;
398: END IF;
399:
400: IF ( p_flow_schedule_rec.routing_revision_date= FND_API.G_MISS_DATE ) THEN
401: x_Flow_Schedule_Pvt_Rec.routing_revision_date := NULL;
402: ELSE
403: x_Flow_Schedule_Pvt_Rec.routing_revision_date := nvl(p_flow_schedule_rec.routing_revision_date ,FND_API.G_MISS_DATE);
404: END IF;

Line 403: x_Flow_Schedule_Pvt_Rec.routing_revision_date := nvl(p_flow_schedule_rec.routing_revision_date ,FND_API.G_MISS_DATE);

399:
400: IF ( p_flow_schedule_rec.routing_revision_date= FND_API.G_MISS_DATE ) THEN
401: x_Flow_Schedule_Pvt_Rec.routing_revision_date := NULL;
402: ELSE
403: x_Flow_Schedule_Pvt_Rec.routing_revision_date := nvl(p_flow_schedule_rec.routing_revision_date ,FND_API.G_MISS_DATE);
404: END IF;
405:
406: IF ( p_flow_schedule_rec.scheduled_completion_date = FND_API.G_MISS_DATE ) THEN
407: x_Flow_Schedule_Pvt_Rec.scheduled_completion_date:= NULL;

Line 406: IF ( p_flow_schedule_rec.scheduled_completion_date = FND_API.G_MISS_DATE ) THEN

402: ELSE
403: x_Flow_Schedule_Pvt_Rec.routing_revision_date := nvl(p_flow_schedule_rec.routing_revision_date ,FND_API.G_MISS_DATE);
404: END IF;
405:
406: IF ( p_flow_schedule_rec.scheduled_completion_date = FND_API.G_MISS_DATE ) THEN
407: x_Flow_Schedule_Pvt_Rec.scheduled_completion_date:= NULL;
408: ELSE
409: x_Flow_Schedule_Pvt_Rec.scheduled_completion_date:= nvl(p_flow_schedule_rec.scheduled_completion_date,FND_API.G_MISS_DATE);
410: END IF;

Line 409: x_Flow_Schedule_Pvt_Rec.scheduled_completion_date:= nvl(p_flow_schedule_rec.scheduled_completion_date,FND_API.G_MISS_DATE);

405:
406: IF ( p_flow_schedule_rec.scheduled_completion_date = FND_API.G_MISS_DATE ) THEN
407: x_Flow_Schedule_Pvt_Rec.scheduled_completion_date:= NULL;
408: ELSE
409: x_Flow_Schedule_Pvt_Rec.scheduled_completion_date:= nvl(p_flow_schedule_rec.scheduled_completion_date,FND_API.G_MISS_DATE);
410: END IF;
411:
412: IF ( p_flow_schedule_rec.scheduled_flag = FND_API.G_MISS_NUM ) THEN
413: x_Flow_Schedule_Pvt_Rec.scheduled_flag := NULL;

Line 412: IF ( p_flow_schedule_rec.scheduled_flag = FND_API.G_MISS_NUM ) THEN

408: ELSE
409: x_Flow_Schedule_Pvt_Rec.scheduled_completion_date:= nvl(p_flow_schedule_rec.scheduled_completion_date,FND_API.G_MISS_DATE);
410: END IF;
411:
412: IF ( p_flow_schedule_rec.scheduled_flag = FND_API.G_MISS_NUM ) THEN
413: x_Flow_Schedule_Pvt_Rec.scheduled_flag := NULL;
414: ELSE
415: x_Flow_Schedule_Pvt_Rec.scheduled_flag := nvl(p_flow_schedule_rec.scheduled_flag,FND_API.G_MISS_NUM );
416: END IF;

Line 415: x_Flow_Schedule_Pvt_Rec.scheduled_flag := nvl(p_flow_schedule_rec.scheduled_flag,FND_API.G_MISS_NUM );

411:
412: IF ( p_flow_schedule_rec.scheduled_flag = FND_API.G_MISS_NUM ) THEN
413: x_Flow_Schedule_Pvt_Rec.scheduled_flag := NULL;
414: ELSE
415: x_Flow_Schedule_Pvt_Rec.scheduled_flag := nvl(p_flow_schedule_rec.scheduled_flag,FND_API.G_MISS_NUM );
416: END IF;
417:
418: IF ( p_flow_schedule_rec.scheduled_start_date = FND_API.G_MISS_DATE ) THEN
419: x_Flow_Schedule_Pvt_Rec.scheduled_start_date := NULL;

Line 418: IF ( p_flow_schedule_rec.scheduled_start_date = FND_API.G_MISS_DATE ) THEN

414: ELSE
415: x_Flow_Schedule_Pvt_Rec.scheduled_flag := nvl(p_flow_schedule_rec.scheduled_flag,FND_API.G_MISS_NUM );
416: END IF;
417:
418: IF ( p_flow_schedule_rec.scheduled_start_date = FND_API.G_MISS_DATE ) THEN
419: x_Flow_Schedule_Pvt_Rec.scheduled_start_date := NULL;
420: ELSE
421: x_Flow_Schedule_Pvt_Rec.scheduled_start_date := nvl(p_flow_schedule_rec.scheduled_start_date,FND_API.G_MISS_DATE) ;
422: END IF;

Line 421: x_Flow_Schedule_Pvt_Rec.scheduled_start_date := nvl(p_flow_schedule_rec.scheduled_start_date,FND_API.G_MISS_DATE) ;

417:
418: IF ( p_flow_schedule_rec.scheduled_start_date = FND_API.G_MISS_DATE ) THEN
419: x_Flow_Schedule_Pvt_Rec.scheduled_start_date := NULL;
420: ELSE
421: x_Flow_Schedule_Pvt_Rec.scheduled_start_date := nvl(p_flow_schedule_rec.scheduled_start_date,FND_API.G_MISS_DATE) ;
422: END IF;
423:
424: IF ( p_flow_schedule_rec.schedule_group_id = FND_API.G_MISS_NUM ) THEN
425: x_Flow_Schedule_Pvt_Rec.schedule_group_id := NULL;

Line 424: IF ( p_flow_schedule_rec.schedule_group_id = FND_API.G_MISS_NUM ) THEN

420: ELSE
421: x_Flow_Schedule_Pvt_Rec.scheduled_start_date := nvl(p_flow_schedule_rec.scheduled_start_date,FND_API.G_MISS_DATE) ;
422: END IF;
423:
424: IF ( p_flow_schedule_rec.schedule_group_id = FND_API.G_MISS_NUM ) THEN
425: x_Flow_Schedule_Pvt_Rec.schedule_group_id := NULL;
426: ELSE
427: x_Flow_Schedule_Pvt_Rec.schedule_group_id := nvl(p_flow_schedule_rec.schedule_group_id ,FND_API.G_MISS_NUM) ;
428: END IF;

Line 427: x_Flow_Schedule_Pvt_Rec.schedule_group_id := nvl(p_flow_schedule_rec.schedule_group_id ,FND_API.G_MISS_NUM) ;

423:
424: IF ( p_flow_schedule_rec.schedule_group_id = FND_API.G_MISS_NUM ) THEN
425: x_Flow_Schedule_Pvt_Rec.schedule_group_id := NULL;
426: ELSE
427: x_Flow_Schedule_Pvt_Rec.schedule_group_id := nvl(p_flow_schedule_rec.schedule_group_id ,FND_API.G_MISS_NUM) ;
428: END IF;
429:
430: IF ( p_flow_schedule_rec.schedule_number = FND_API.G_MISS_CHAR ) THEN
431: x_Flow_Schedule_Pvt_Rec.schedule_number := NULL;

Line 430: IF ( p_flow_schedule_rec.schedule_number = FND_API.G_MISS_CHAR ) THEN

426: ELSE
427: x_Flow_Schedule_Pvt_Rec.schedule_group_id := nvl(p_flow_schedule_rec.schedule_group_id ,FND_API.G_MISS_NUM) ;
428: END IF;
429:
430: IF ( p_flow_schedule_rec.schedule_number = FND_API.G_MISS_CHAR ) THEN
431: x_Flow_Schedule_Pvt_Rec.schedule_number := NULL;
432: ELSE
433: x_Flow_Schedule_Pvt_Rec.schedule_number := nvl(p_flow_schedule_rec.schedule_number ,FND_API.G_MISS_CHAR );
434: END IF;

Line 433: x_Flow_Schedule_Pvt_Rec.schedule_number := nvl(p_flow_schedule_rec.schedule_number ,FND_API.G_MISS_CHAR );

429:
430: IF ( p_flow_schedule_rec.schedule_number = FND_API.G_MISS_CHAR ) THEN
431: x_Flow_Schedule_Pvt_Rec.schedule_number := NULL;
432: ELSE
433: x_Flow_Schedule_Pvt_Rec.schedule_number := nvl(p_flow_schedule_rec.schedule_number ,FND_API.G_MISS_CHAR );
434: END IF;
435:
436:
437: IF ( p_flow_schedule_rec.status = FND_API.G_MISS_NUM ) THEN

Line 437: IF ( p_flow_schedule_rec.status = FND_API.G_MISS_NUM ) THEN

433: x_Flow_Schedule_Pvt_Rec.schedule_number := nvl(p_flow_schedule_rec.schedule_number ,FND_API.G_MISS_CHAR );
434: END IF;
435:
436:
437: IF ( p_flow_schedule_rec.status = FND_API.G_MISS_NUM ) THEN
438: x_Flow_Schedule_Pvt_Rec.status := NULL;
439: ELSE
440: x_Flow_Schedule_Pvt_Rec.status := nvl(p_flow_schedule_rec.status ,FND_API.G_MISS_NUM) ;
441: END IF;

Line 440: x_Flow_Schedule_Pvt_Rec.status := nvl(p_flow_schedule_rec.status ,FND_API.G_MISS_NUM) ;

436:
437: IF ( p_flow_schedule_rec.status = FND_API.G_MISS_NUM ) THEN
438: x_Flow_Schedule_Pvt_Rec.status := NULL;
439: ELSE
440: x_Flow_Schedule_Pvt_Rec.status := nvl(p_flow_schedule_rec.status ,FND_API.G_MISS_NUM) ;
441: END IF;
442:
443: IF ( p_flow_schedule_rec.std_cost_adjustment_acct = FND_API.G_MISS_NUM) THEN
444: x_Flow_Schedule_Pvt_Rec.std_cost_adjustment_acct := NULL;

Line 443: IF ( p_flow_schedule_rec.std_cost_adjustment_acct = FND_API.G_MISS_NUM) THEN

439: ELSE
440: x_Flow_Schedule_Pvt_Rec.status := nvl(p_flow_schedule_rec.status ,FND_API.G_MISS_NUM) ;
441: END IF;
442:
443: IF ( p_flow_schedule_rec.std_cost_adjustment_acct = FND_API.G_MISS_NUM) THEN
444: x_Flow_Schedule_Pvt_Rec.std_cost_adjustment_acct := NULL;
445: ELSE
446: x_Flow_Schedule_Pvt_Rec.std_cost_adjustment_acct := nvl(p_flow_schedule_rec.std_cost_adjustment_acct ,FND_API.G_MISS_NUM) ;
447: END IF;

Line 446: x_Flow_Schedule_Pvt_Rec.std_cost_adjustment_acct := nvl(p_flow_schedule_rec.std_cost_adjustment_acct ,FND_API.G_MISS_NUM) ;

442:
443: IF ( p_flow_schedule_rec.std_cost_adjustment_acct = FND_API.G_MISS_NUM) THEN
444: x_Flow_Schedule_Pvt_Rec.std_cost_adjustment_acct := NULL;
445: ELSE
446: x_Flow_Schedule_Pvt_Rec.std_cost_adjustment_acct := nvl(p_flow_schedule_rec.std_cost_adjustment_acct ,FND_API.G_MISS_NUM) ;
447: END IF;
448:
449: IF ( p_flow_schedule_rec.task_id = FND_API.G_MISS_NUM) THEN
450: x_Flow_Schedule_Pvt_Rec.task_id := NULL;

Line 449: IF ( p_flow_schedule_rec.task_id = FND_API.G_MISS_NUM) THEN

445: ELSE
446: x_Flow_Schedule_Pvt_Rec.std_cost_adjustment_acct := nvl(p_flow_schedule_rec.std_cost_adjustment_acct ,FND_API.G_MISS_NUM) ;
447: END IF;
448:
449: IF ( p_flow_schedule_rec.task_id = FND_API.G_MISS_NUM) THEN
450: x_Flow_Schedule_Pvt_Rec.task_id := NULL;
451: ELSE
452: x_Flow_Schedule_Pvt_Rec.task_id := nvl(p_flow_schedule_rec.task_id ,FND_API.G_MISS_NUM) ;
453: END IF;

Line 452: x_Flow_Schedule_Pvt_Rec.task_id := nvl(p_flow_schedule_rec.task_id ,FND_API.G_MISS_NUM) ;

448:
449: IF ( p_flow_schedule_rec.task_id = FND_API.G_MISS_NUM) THEN
450: x_Flow_Schedule_Pvt_Rec.task_id := NULL;
451: ELSE
452: x_Flow_Schedule_Pvt_Rec.task_id := nvl(p_flow_schedule_rec.task_id ,FND_API.G_MISS_NUM) ;
453: END IF;
454:
455: IF ( p_flow_schedule_rec.wip_entity_id = FND_API.G_MISS_NUM) THEN
456: x_Flow_Schedule_Pvt_Rec.wip_entity_id := NULL;

Line 455: IF ( p_flow_schedule_rec.wip_entity_id = FND_API.G_MISS_NUM) THEN

451: ELSE
452: x_Flow_Schedule_Pvt_Rec.task_id := nvl(p_flow_schedule_rec.task_id ,FND_API.G_MISS_NUM) ;
453: END IF;
454:
455: IF ( p_flow_schedule_rec.wip_entity_id = FND_API.G_MISS_NUM) THEN
456: x_Flow_Schedule_Pvt_Rec.wip_entity_id := NULL;
457: ELSE
458: x_Flow_Schedule_Pvt_Rec.wip_entity_id := nvl(p_flow_schedule_rec.wip_entity_id ,FND_API.G_MISS_NUM) ;
459: END IF;

Line 458: x_Flow_Schedule_Pvt_Rec.wip_entity_id := nvl(p_flow_schedule_rec.wip_entity_id ,FND_API.G_MISS_NUM) ;

454:
455: IF ( p_flow_schedule_rec.wip_entity_id = FND_API.G_MISS_NUM) THEN
456: x_Flow_Schedule_Pvt_Rec.wip_entity_id := NULL;
457: ELSE
458: x_Flow_Schedule_Pvt_Rec.wip_entity_id := nvl(p_flow_schedule_rec.wip_entity_id ,FND_API.G_MISS_NUM) ;
459: END IF;
460:
461: IF ( p_flow_schedule_rec.scheduled_by = FND_API.G_MISS_NUM) THEN
462: x_Flow_Schedule_Pvt_Rec.scheduled_by := NULL;

Line 461: IF ( p_flow_schedule_rec.scheduled_by = FND_API.G_MISS_NUM) THEN

457: ELSE
458: x_Flow_Schedule_Pvt_Rec.wip_entity_id := nvl(p_flow_schedule_rec.wip_entity_id ,FND_API.G_MISS_NUM) ;
459: END IF;
460:
461: IF ( p_flow_schedule_rec.scheduled_by = FND_API.G_MISS_NUM) THEN
462: x_Flow_Schedule_Pvt_Rec.scheduled_by := NULL;
463: ELSE
464: x_Flow_Schedule_Pvt_Rec.scheduled_by := nvl(p_flow_schedule_rec.scheduled_by,FND_API.G_MISS_NUM) ;
465: END IF;

Line 464: x_Flow_Schedule_Pvt_Rec.scheduled_by := nvl(p_flow_schedule_rec.scheduled_by,FND_API.G_MISS_NUM) ;

460:
461: IF ( p_flow_schedule_rec.scheduled_by = FND_API.G_MISS_NUM) THEN
462: x_Flow_Schedule_Pvt_Rec.scheduled_by := NULL;
463: ELSE
464: x_Flow_Schedule_Pvt_Rec.scheduled_by := nvl(p_flow_schedule_rec.scheduled_by,FND_API.G_MISS_NUM) ;
465: END IF;
466:
467: IF ( p_flow_schedule_rec.return_status = FND_API.G_MISS_CHAR ) THEN
468: x_Flow_Schedule_Pvt_Rec.return_status := NULL;

Line 467: IF ( p_flow_schedule_rec.return_status = FND_API.G_MISS_CHAR ) THEN

463: ELSE
464: x_Flow_Schedule_Pvt_Rec.scheduled_by := nvl(p_flow_schedule_rec.scheduled_by,FND_API.G_MISS_NUM) ;
465: END IF;
466:
467: IF ( p_flow_schedule_rec.return_status = FND_API.G_MISS_CHAR ) THEN
468: x_Flow_Schedule_Pvt_Rec.return_status := NULL;
469: ELSE
470: x_Flow_Schedule_Pvt_Rec.return_status := nvl(p_flow_schedule_rec.return_status ,FND_API.G_MISS_CHAR) ;
471: END IF;

Line 470: x_Flow_Schedule_Pvt_Rec.return_status := nvl(p_flow_schedule_rec.return_status ,FND_API.G_MISS_CHAR) ;

466:
467: IF ( p_flow_schedule_rec.return_status = FND_API.G_MISS_CHAR ) THEN
468: x_Flow_Schedule_Pvt_Rec.return_status := NULL;
469: ELSE
470: x_Flow_Schedule_Pvt_Rec.return_status := nvl(p_flow_schedule_rec.return_status ,FND_API.G_MISS_CHAR) ;
471: END IF;
472:
473: IF ( p_flow_schedule_rec.db_flag = FND_API.G_MISS_CHAR ) THEN
474: x_Flow_Schedule_Pvt_Rec.db_flag := NULL;

Line 473: IF ( p_flow_schedule_rec.db_flag = FND_API.G_MISS_CHAR ) THEN

469: ELSE
470: x_Flow_Schedule_Pvt_Rec.return_status := nvl(p_flow_schedule_rec.return_status ,FND_API.G_MISS_CHAR) ;
471: END IF;
472:
473: IF ( p_flow_schedule_rec.db_flag = FND_API.G_MISS_CHAR ) THEN
474: x_Flow_Schedule_Pvt_Rec.db_flag := NULL;
475: ELSE
476: x_Flow_Schedule_Pvt_Rec.db_flag := nvl(p_flow_schedule_rec.db_flag ,FND_API.G_MISS_CHAR ) ;
477: END IF;

Line 476: x_Flow_Schedule_Pvt_Rec.db_flag := nvl(p_flow_schedule_rec.db_flag ,FND_API.G_MISS_CHAR ) ;

472:
473: IF ( p_flow_schedule_rec.db_flag = FND_API.G_MISS_CHAR ) THEN
474: x_Flow_Schedule_Pvt_Rec.db_flag := NULL;
475: ELSE
476: x_Flow_Schedule_Pvt_Rec.db_flag := nvl(p_flow_schedule_rec.db_flag ,FND_API.G_MISS_CHAR ) ;
477: END IF;
478:
479: IF ( p_flow_schedule_rec.operation = FND_API.G_MISS_CHAR ) THEN
480: x_Flow_Schedule_Pvt_Rec.operation := NULL;

Line 479: IF ( p_flow_schedule_rec.operation = FND_API.G_MISS_CHAR ) THEN

475: ELSE
476: x_Flow_Schedule_Pvt_Rec.db_flag := nvl(p_flow_schedule_rec.db_flag ,FND_API.G_MISS_CHAR ) ;
477: END IF;
478:
479: IF ( p_flow_schedule_rec.operation = FND_API.G_MISS_CHAR ) THEN
480: x_Flow_Schedule_Pvt_Rec.operation := NULL;
481: ELSE
482: x_Flow_Schedule_Pvt_Rec.operation := nvl(p_flow_schedule_rec.operation ,FND_API.G_MISS_CHAR ) ;
483: END IF;

Line 482: x_Flow_Schedule_Pvt_Rec.operation := nvl(p_flow_schedule_rec.operation ,FND_API.G_MISS_CHAR ) ;

478:
479: IF ( p_flow_schedule_rec.operation = FND_API.G_MISS_CHAR ) THEN
480: x_Flow_Schedule_Pvt_Rec.operation := NULL;
481: ELSE
482: x_Flow_Schedule_Pvt_Rec.operation := nvl(p_flow_schedule_rec.operation ,FND_API.G_MISS_CHAR ) ;
483: END IF;
484:
485: IF ( p_flow_schedule_rec.end_item_unit_number = FND_API.G_MISS_CHAR ) THEN
486: x_Flow_Schedule_Pvt_Rec.end_item_unit_number := NULL;

Line 485: IF ( p_flow_schedule_rec.end_item_unit_number = FND_API.G_MISS_CHAR ) THEN

481: ELSE
482: x_Flow_Schedule_Pvt_Rec.operation := nvl(p_flow_schedule_rec.operation ,FND_API.G_MISS_CHAR ) ;
483: END IF;
484:
485: IF ( p_flow_schedule_rec.end_item_unit_number = FND_API.G_MISS_CHAR ) THEN
486: x_Flow_Schedule_Pvt_Rec.end_item_unit_number := NULL;
487: ELSE
488: x_Flow_Schedule_Pvt_Rec.end_item_unit_number := nvl(p_flow_schedule_rec.end_item_unit_number,FND_API.G_MISS_CHAR ) ;
489: END IF;

Line 488: x_Flow_Schedule_Pvt_Rec.end_item_unit_number := nvl(p_flow_schedule_rec.end_item_unit_number,FND_API.G_MISS_CHAR ) ;

484:
485: IF ( p_flow_schedule_rec.end_item_unit_number = FND_API.G_MISS_CHAR ) THEN
486: x_Flow_Schedule_Pvt_Rec.end_item_unit_number := NULL;
487: ELSE
488: x_Flow_Schedule_Pvt_Rec.end_item_unit_number := nvl(p_flow_schedule_rec.end_item_unit_number,FND_API.G_MISS_CHAR ) ;
489: END IF;
490:
491: IF ( p_flow_schedule_rec.quantity_scrapped = FND_API.G_MISS_NUM ) THEN
492: x_Flow_Schedule_Pvt_Rec.quantity_scrapped := NULL;

Line 491: IF ( p_flow_schedule_rec.quantity_scrapped = FND_API.G_MISS_NUM ) THEN

487: ELSE
488: x_Flow_Schedule_Pvt_Rec.end_item_unit_number := nvl(p_flow_schedule_rec.end_item_unit_number,FND_API.G_MISS_CHAR ) ;
489: END IF;
490:
491: IF ( p_flow_schedule_rec.quantity_scrapped = FND_API.G_MISS_NUM ) THEN
492: x_Flow_Schedule_Pvt_Rec.quantity_scrapped := NULL;
493: ELSE
494: x_Flow_Schedule_Pvt_Rec.quantity_scrapped := nvl(p_flow_schedule_rec.quantity_scrapped ,FND_API.G_MISS_NUM) ;
495: END IF;

Line 494: x_Flow_Schedule_Pvt_Rec.quantity_scrapped := nvl(p_flow_schedule_rec.quantity_scrapped ,FND_API.G_MISS_NUM) ;

490:
491: IF ( p_flow_schedule_rec.quantity_scrapped = FND_API.G_MISS_NUM ) THEN
492: x_Flow_Schedule_Pvt_Rec.quantity_scrapped := NULL;
493: ELSE
494: x_Flow_Schedule_Pvt_Rec.quantity_scrapped := nvl(p_flow_schedule_rec.quantity_scrapped ,FND_API.G_MISS_NUM) ;
495: END IF;
496:
497: IF ( p_flow_schedule_rec.kanban_card_id = FND_API.G_MISS_NUM) THEN
498: x_Flow_Schedule_Pvt_Rec.kanban_card_id := NULL;

Line 497: IF ( p_flow_schedule_rec.kanban_card_id = FND_API.G_MISS_NUM) THEN

493: ELSE
494: x_Flow_Schedule_Pvt_Rec.quantity_scrapped := nvl(p_flow_schedule_rec.quantity_scrapped ,FND_API.G_MISS_NUM) ;
495: END IF;
496:
497: IF ( p_flow_schedule_rec.kanban_card_id = FND_API.G_MISS_NUM) THEN
498: x_Flow_Schedule_Pvt_Rec.kanban_card_id := NULL;
499: ELSE
500: x_Flow_Schedule_Pvt_Rec.kanban_card_id := nvl(p_flow_schedule_rec.kanban_card_id ,FND_API.G_MISS_NUM) ;
501: END IF;

Line 500: x_Flow_Schedule_Pvt_Rec.kanban_card_id := nvl(p_flow_schedule_rec.kanban_card_id ,FND_API.G_MISS_NUM) ;

496:
497: IF ( p_flow_schedule_rec.kanban_card_id = FND_API.G_MISS_NUM) THEN
498: x_Flow_Schedule_Pvt_Rec.kanban_card_id := NULL;
499: ELSE
500: x_Flow_Schedule_Pvt_Rec.kanban_card_id := nvl(p_flow_schedule_rec.kanban_card_id ,FND_API.G_MISS_NUM) ;
501: END IF;
502:
503: IF ( p_flow_schedule_rec.synch_schedule_num = FND_API.G_MISS_CHAR ) THEN
504: x_Flow_Schedule_Pvt_Rec.synch_schedule_num := NULL;

Line 503: IF ( p_flow_schedule_rec.synch_schedule_num = FND_API.G_MISS_CHAR ) THEN

499: ELSE
500: x_Flow_Schedule_Pvt_Rec.kanban_card_id := nvl(p_flow_schedule_rec.kanban_card_id ,FND_API.G_MISS_NUM) ;
501: END IF;
502:
503: IF ( p_flow_schedule_rec.synch_schedule_num = FND_API.G_MISS_CHAR ) THEN
504: x_Flow_Schedule_Pvt_Rec.synch_schedule_num := NULL;
505: ELSE
506: x_Flow_Schedule_Pvt_Rec.synch_schedule_num := nvl(p_flow_schedule_rec.synch_schedule_num ,FND_API.G_MISS_CHAR ) ;
507: END IF;

Line 506: x_Flow_Schedule_Pvt_Rec.synch_schedule_num := nvl(p_flow_schedule_rec.synch_schedule_num ,FND_API.G_MISS_CHAR ) ;

502:
503: IF ( p_flow_schedule_rec.synch_schedule_num = FND_API.G_MISS_CHAR ) THEN
504: x_Flow_Schedule_Pvt_Rec.synch_schedule_num := NULL;
505: ELSE
506: x_Flow_Schedule_Pvt_Rec.synch_schedule_num := nvl(p_flow_schedule_rec.synch_schedule_num ,FND_API.G_MISS_CHAR ) ;
507: END IF;
508:
509: IF ( p_flow_schedule_rec.synch_operation_seq_num = FND_API.G_MISS_NUM) THEN
510: x_Flow_Schedule_Pvt_Rec.synch_operation_seq_num := NULL;

Line 509: IF ( p_flow_schedule_rec.synch_operation_seq_num = FND_API.G_MISS_NUM) THEN

505: ELSE
506: x_Flow_Schedule_Pvt_Rec.synch_schedule_num := nvl(p_flow_schedule_rec.synch_schedule_num ,FND_API.G_MISS_CHAR ) ;
507: END IF;
508:
509: IF ( p_flow_schedule_rec.synch_operation_seq_num = FND_API.G_MISS_NUM) THEN
510: x_Flow_Schedule_Pvt_Rec.synch_operation_seq_num := NULL;
511: ELSE
512: x_Flow_Schedule_Pvt_Rec.synch_operation_seq_num := nvl(p_flow_schedule_rec.synch_operation_seq_num ,FND_API.G_MISS_NUM) ;
513: END IF;

Line 512: x_Flow_Schedule_Pvt_Rec.synch_operation_seq_num := nvl(p_flow_schedule_rec.synch_operation_seq_num ,FND_API.G_MISS_NUM) ;

508:
509: IF ( p_flow_schedule_rec.synch_operation_seq_num = FND_API.G_MISS_NUM) THEN
510: x_Flow_Schedule_Pvt_Rec.synch_operation_seq_num := NULL;
511: ELSE
512: x_Flow_Schedule_Pvt_Rec.synch_operation_seq_num := nvl(p_flow_schedule_rec.synch_operation_seq_num ,FND_API.G_MISS_NUM) ;
513: END IF;
514:
515: IF ( p_flow_schedule_rec.roll_forwarded_flag = FND_API.G_MISS_NUM ) THEN
516: x_Flow_Schedule_Pvt_Rec.roll_forwarded_flag := NULL;

Line 515: IF ( p_flow_schedule_rec.roll_forwarded_flag = FND_API.G_MISS_NUM ) THEN

511: ELSE
512: x_Flow_Schedule_Pvt_Rec.synch_operation_seq_num := nvl(p_flow_schedule_rec.synch_operation_seq_num ,FND_API.G_MISS_NUM) ;
513: END IF;
514:
515: IF ( p_flow_schedule_rec.roll_forwarded_flag = FND_API.G_MISS_NUM ) THEN
516: x_Flow_Schedule_Pvt_Rec.roll_forwarded_flag := NULL;
517: ELSE
518: x_Flow_Schedule_Pvt_Rec.roll_forwarded_flag := nvl(p_flow_schedule_rec.roll_forwarded_flag,FND_API.G_MISS_NUM);
519: END IF;

Line 518: x_Flow_Schedule_Pvt_Rec.roll_forwarded_flag := nvl(p_flow_schedule_rec.roll_forwarded_flag,FND_API.G_MISS_NUM);

514:
515: IF ( p_flow_schedule_rec.roll_forwarded_flag = FND_API.G_MISS_NUM ) THEN
516: x_Flow_Schedule_Pvt_Rec.roll_forwarded_flag := NULL;
517: ELSE
518: x_Flow_Schedule_Pvt_Rec.roll_forwarded_flag := nvl(p_flow_schedule_rec.roll_forwarded_flag,FND_API.G_MISS_NUM);
519: END IF;
520:
521: IF ( p_flow_schedule_rec.current_line_operation = FND_API.G_MISS_NUM) THEN
522: x_Flow_Schedule_Pvt_Rec.current_line_operation := NULL;

Line 521: IF ( p_flow_schedule_rec.current_line_operation = FND_API.G_MISS_NUM) THEN

517: ELSE
518: x_Flow_Schedule_Pvt_Rec.roll_forwarded_flag := nvl(p_flow_schedule_rec.roll_forwarded_flag,FND_API.G_MISS_NUM);
519: END IF;
520:
521: IF ( p_flow_schedule_rec.current_line_operation = FND_API.G_MISS_NUM) THEN
522: x_Flow_Schedule_Pvt_Rec.current_line_operation := NULL;
523: ELSE
524: x_Flow_Schedule_Pvt_Rec.current_line_operation := nvl(p_flow_schedule_rec.current_line_operation ,FND_API.G_MISS_NUM);
525: END IF;

Line 524: x_Flow_Schedule_Pvt_Rec.current_line_operation := nvl(p_flow_schedule_rec.current_line_operation ,FND_API.G_MISS_NUM);

520:
521: IF ( p_flow_schedule_rec.current_line_operation = FND_API.G_MISS_NUM) THEN
522: x_Flow_Schedule_Pvt_Rec.current_line_operation := NULL;
523: ELSE
524: x_Flow_Schedule_Pvt_Rec.current_line_operation := nvl(p_flow_schedule_rec.current_line_operation ,FND_API.G_MISS_NUM);
525: END IF;
526: END;
527:
528: PROCEDURE PVT_Flow_Sched_Val_Rec_To_PUB (

Line 534: IF ( p_flow_schedule_val_pvt_rec.Completion_locator = FND_API.G_MISS_CHAR ) THEN

530: x_flow_schedule_val_rec OUT NOCOPY MRP_Flow_Schedule_PUB.Flow_Schedule_Val_Rec_Type )
531: IS
532: BEGIN
533:
534: IF ( p_flow_schedule_val_pvt_rec.Completion_locator = FND_API.G_MISS_CHAR ) THEN
535: x_flow_schedule_val_rec.completion_locator := NULL;
536: ELSE
537: x_flow_schedule_val_rec.completion_locator := nvl(p_flow_schedule_val_pvt_rec.Completion_locator,FND_API.G_MISS_CHAR ) ;
538: END IF;

Line 537: x_flow_schedule_val_rec.completion_locator := nvl(p_flow_schedule_val_pvt_rec.Completion_locator,FND_API.G_MISS_CHAR ) ;

533:
534: IF ( p_flow_schedule_val_pvt_rec.Completion_locator = FND_API.G_MISS_CHAR ) THEN
535: x_flow_schedule_val_rec.completion_locator := NULL;
536: ELSE
537: x_flow_schedule_val_rec.completion_locator := nvl(p_flow_schedule_val_pvt_rec.Completion_locator,FND_API.G_MISS_CHAR ) ;
538: END IF;
539:
540: IF ( p_flow_schedule_val_pvt_rec.line = FND_API.G_MISS_CHAR ) THEN
541: x_flow_schedule_val_rec.line := NULL;

Line 540: IF ( p_flow_schedule_val_pvt_rec.line = FND_API.G_MISS_CHAR ) THEN

536: ELSE
537: x_flow_schedule_val_rec.completion_locator := nvl(p_flow_schedule_val_pvt_rec.Completion_locator,FND_API.G_MISS_CHAR ) ;
538: END IF;
539:
540: IF ( p_flow_schedule_val_pvt_rec.line = FND_API.G_MISS_CHAR ) THEN
541: x_flow_schedule_val_rec.line := NULL;
542: ELSE
543: x_flow_schedule_val_rec.line := nvl(p_flow_schedule_val_pvt_rec.line,FND_API.G_MISS_CHAR ) ;
544: END IF;

Line 543: x_flow_schedule_val_rec.line := nvl(p_flow_schedule_val_pvt_rec.line,FND_API.G_MISS_CHAR ) ;

539:
540: IF ( p_flow_schedule_val_pvt_rec.line = FND_API.G_MISS_CHAR ) THEN
541: x_flow_schedule_val_rec.line := NULL;
542: ELSE
543: x_flow_schedule_val_rec.line := nvl(p_flow_schedule_val_pvt_rec.line,FND_API.G_MISS_CHAR ) ;
544: END IF;
545:
546: IF ( p_flow_schedule_val_pvt_rec.organization = FND_API.G_MISS_CHAR ) THEN
547: x_flow_schedule_val_rec.organization := NULL;

Line 546: IF ( p_flow_schedule_val_pvt_rec.organization = FND_API.G_MISS_CHAR ) THEN

542: ELSE
543: x_flow_schedule_val_rec.line := nvl(p_flow_schedule_val_pvt_rec.line,FND_API.G_MISS_CHAR ) ;
544: END IF;
545:
546: IF ( p_flow_schedule_val_pvt_rec.organization = FND_API.G_MISS_CHAR ) THEN
547: x_flow_schedule_val_rec.organization := NULL;
548: ELSE
549: x_flow_schedule_val_rec.organization:= nvl(p_flow_schedule_val_pvt_rec.organization,FND_API.G_MISS_CHAR ) ;
550: END IF;

Line 549: x_flow_schedule_val_rec.organization:= nvl(p_flow_schedule_val_pvt_rec.organization,FND_API.G_MISS_CHAR ) ;

545:
546: IF ( p_flow_schedule_val_pvt_rec.organization = FND_API.G_MISS_CHAR ) THEN
547: x_flow_schedule_val_rec.organization := NULL;
548: ELSE
549: x_flow_schedule_val_rec.organization:= nvl(p_flow_schedule_val_pvt_rec.organization,FND_API.G_MISS_CHAR ) ;
550: END IF;
551:
552: IF ( p_flow_schedule_val_pvt_rec.primary_item = FND_API.G_MISS_CHAR ) THEN
553: x_flow_schedule_val_rec.primary_item := NULL;

Line 552: IF ( p_flow_schedule_val_pvt_rec.primary_item = FND_API.G_MISS_CHAR ) THEN

548: ELSE
549: x_flow_schedule_val_rec.organization:= nvl(p_flow_schedule_val_pvt_rec.organization,FND_API.G_MISS_CHAR ) ;
550: END IF;
551:
552: IF ( p_flow_schedule_val_pvt_rec.primary_item = FND_API.G_MISS_CHAR ) THEN
553: x_flow_schedule_val_rec.primary_item := NULL;
554: ELSE
555: x_flow_schedule_val_rec.primary_item := nvl(p_flow_schedule_val_pvt_rec.primary_item,FND_API.G_MISS_CHAR ) ;
556: END IF;

Line 555: x_flow_schedule_val_rec.primary_item := nvl(p_flow_schedule_val_pvt_rec.primary_item,FND_API.G_MISS_CHAR ) ;

551:
552: IF ( p_flow_schedule_val_pvt_rec.primary_item = FND_API.G_MISS_CHAR ) THEN
553: x_flow_schedule_val_rec.primary_item := NULL;
554: ELSE
555: x_flow_schedule_val_rec.primary_item := nvl(p_flow_schedule_val_pvt_rec.primary_item,FND_API.G_MISS_CHAR ) ;
556: END IF;
557:
558: IF ( p_flow_schedule_val_pvt_rec.project = FND_API.G_MISS_CHAR ) THEN
559: x_flow_schedule_val_rec.project := NULL;

Line 558: IF ( p_flow_schedule_val_pvt_rec.project = FND_API.G_MISS_CHAR ) THEN

554: ELSE
555: x_flow_schedule_val_rec.primary_item := nvl(p_flow_schedule_val_pvt_rec.primary_item,FND_API.G_MISS_CHAR ) ;
556: END IF;
557:
558: IF ( p_flow_schedule_val_pvt_rec.project = FND_API.G_MISS_CHAR ) THEN
559: x_flow_schedule_val_rec.project := NULL;
560: ELSE
561: x_flow_schedule_val_rec.project := nvl(p_flow_schedule_val_pvt_rec.project,FND_API.G_MISS_CHAR ) ;
562: END IF;

Line 561: x_flow_schedule_val_rec.project := nvl(p_flow_schedule_val_pvt_rec.project,FND_API.G_MISS_CHAR ) ;

557:
558: IF ( p_flow_schedule_val_pvt_rec.project = FND_API.G_MISS_CHAR ) THEN
559: x_flow_schedule_val_rec.project := NULL;
560: ELSE
561: x_flow_schedule_val_rec.project := nvl(p_flow_schedule_val_pvt_rec.project,FND_API.G_MISS_CHAR ) ;
562: END IF;
563:
564: IF ( p_flow_schedule_val_pvt_rec.schedule_group = FND_API.G_MISS_CHAR ) THEN
565: x_flow_schedule_val_rec.schedule_group := NULL;

Line 564: IF ( p_flow_schedule_val_pvt_rec.schedule_group = FND_API.G_MISS_CHAR ) THEN

560: ELSE
561: x_flow_schedule_val_rec.project := nvl(p_flow_schedule_val_pvt_rec.project,FND_API.G_MISS_CHAR ) ;
562: END IF;
563:
564: IF ( p_flow_schedule_val_pvt_rec.schedule_group = FND_API.G_MISS_CHAR ) THEN
565: x_flow_schedule_val_rec.schedule_group := NULL;
566: ELSE
567: x_flow_schedule_val_rec.schedule_group := nvl(p_flow_schedule_val_pvt_rec.schedule_group,FND_API.G_MISS_CHAR ) ;
568: END IF;

Line 567: x_flow_schedule_val_rec.schedule_group := nvl(p_flow_schedule_val_pvt_rec.schedule_group,FND_API.G_MISS_CHAR ) ;

563:
564: IF ( p_flow_schedule_val_pvt_rec.schedule_group = FND_API.G_MISS_CHAR ) THEN
565: x_flow_schedule_val_rec.schedule_group := NULL;
566: ELSE
567: x_flow_schedule_val_rec.schedule_group := nvl(p_flow_schedule_val_pvt_rec.schedule_group,FND_API.G_MISS_CHAR ) ;
568: END IF;
569:
570: END;
571:

Line 578: IF ( p_flow_schedule_pvt_rec.alternate_bom_designator = FND_API.G_MISS_CHAR ) THEN

574: x_Flow_Schedule_Rec OUT NOCOPY MRP_Flow_Schedule_PUB.Flow_Schedule_Rec_Type )
575: IS
576: BEGIN
577:
578: IF ( p_flow_schedule_pvt_rec.alternate_bom_designator = FND_API.G_MISS_CHAR ) THEN
579: x_Flow_Schedule_Rec.alternate_bom_designator := NULL;
580: ELSE
581: x_Flow_Schedule_Rec.alternate_bom_designator := nvl(p_flow_schedule_pvt_rec.alternate_bom_designator,FND_API.G_MISS_CHAR ) ;
582: END IF;

Line 581: x_Flow_Schedule_Rec.alternate_bom_designator := nvl(p_flow_schedule_pvt_rec.alternate_bom_designator,FND_API.G_MISS_CHAR ) ;

577:
578: IF ( p_flow_schedule_pvt_rec.alternate_bom_designator = FND_API.G_MISS_CHAR ) THEN
579: x_Flow_Schedule_Rec.alternate_bom_designator := NULL;
580: ELSE
581: x_Flow_Schedule_Rec.alternate_bom_designator := nvl(p_flow_schedule_pvt_rec.alternate_bom_designator,FND_API.G_MISS_CHAR ) ;
582: END IF;
583:
584: IF ( p_flow_schedule_pvt_rec.alternate_routing_desig = FND_API.G_MISS_CHAR ) THEN
585: x_Flow_Schedule_Rec.alternate_routing_desig := NULL;

Line 584: IF ( p_flow_schedule_pvt_rec.alternate_routing_desig = FND_API.G_MISS_CHAR ) THEN

580: ELSE
581: x_Flow_Schedule_Rec.alternate_bom_designator := nvl(p_flow_schedule_pvt_rec.alternate_bom_designator,FND_API.G_MISS_CHAR ) ;
582: END IF;
583:
584: IF ( p_flow_schedule_pvt_rec.alternate_routing_desig = FND_API.G_MISS_CHAR ) THEN
585: x_Flow_Schedule_Rec.alternate_routing_desig := NULL;
586: ELSE
587: x_Flow_Schedule_Rec.alternate_routing_desig := nvl(p_flow_schedule_pvt_rec.alternate_routing_desig,FND_API.G_MISS_CHAR ) ;
588: END IF;

Line 587: x_Flow_Schedule_Rec.alternate_routing_desig := nvl(p_flow_schedule_pvt_rec.alternate_routing_desig,FND_API.G_MISS_CHAR ) ;

583:
584: IF ( p_flow_schedule_pvt_rec.alternate_routing_desig = FND_API.G_MISS_CHAR ) THEN
585: x_Flow_Schedule_Rec.alternate_routing_desig := NULL;
586: ELSE
587: x_Flow_Schedule_Rec.alternate_routing_desig := nvl(p_flow_schedule_pvt_rec.alternate_routing_desig,FND_API.G_MISS_CHAR ) ;
588: END IF;
589:
590: IF ( p_flow_schedule_pvt_rec.attribute1 = FND_API.G_MISS_CHAR ) THEN
591: x_Flow_Schedule_Rec.attribute1 := NULL;

Line 590: IF ( p_flow_schedule_pvt_rec.attribute1 = FND_API.G_MISS_CHAR ) THEN

586: ELSE
587: x_Flow_Schedule_Rec.alternate_routing_desig := nvl(p_flow_schedule_pvt_rec.alternate_routing_desig,FND_API.G_MISS_CHAR ) ;
588: END IF;
589:
590: IF ( p_flow_schedule_pvt_rec.attribute1 = FND_API.G_MISS_CHAR ) THEN
591: x_Flow_Schedule_Rec.attribute1 := NULL;
592: ELSE
593: x_Flow_Schedule_Rec.attribute1 := nvl(p_flow_schedule_pvt_rec.attribute1,FND_API.G_MISS_CHAR ) ;
594: END IF;

Line 593: x_Flow_Schedule_Rec.attribute1 := nvl(p_flow_schedule_pvt_rec.attribute1,FND_API.G_MISS_CHAR ) ;

589:
590: IF ( p_flow_schedule_pvt_rec.attribute1 = FND_API.G_MISS_CHAR ) THEN
591: x_Flow_Schedule_Rec.attribute1 := NULL;
592: ELSE
593: x_Flow_Schedule_Rec.attribute1 := nvl(p_flow_schedule_pvt_rec.attribute1,FND_API.G_MISS_CHAR ) ;
594: END IF;
595:
596: IF ( p_flow_schedule_pvt_rec.attribute10 = FND_API.G_MISS_CHAR ) THEN
597: x_Flow_Schedule_Rec.attribute10 := NULL;

Line 596: IF ( p_flow_schedule_pvt_rec.attribute10 = FND_API.G_MISS_CHAR ) THEN

592: ELSE
593: x_Flow_Schedule_Rec.attribute1 := nvl(p_flow_schedule_pvt_rec.attribute1,FND_API.G_MISS_CHAR ) ;
594: END IF;
595:
596: IF ( p_flow_schedule_pvt_rec.attribute10 = FND_API.G_MISS_CHAR ) THEN
597: x_Flow_Schedule_Rec.attribute10 := NULL;
598: ELSE
599: x_Flow_Schedule_Rec.attribute10 := nvl(p_flow_schedule_pvt_rec.attribute10,FND_API.G_MISS_CHAR ) ;
600: END IF;

Line 599: x_Flow_Schedule_Rec.attribute10 := nvl(p_flow_schedule_pvt_rec.attribute10,FND_API.G_MISS_CHAR ) ;

595:
596: IF ( p_flow_schedule_pvt_rec.attribute10 = FND_API.G_MISS_CHAR ) THEN
597: x_Flow_Schedule_Rec.attribute10 := NULL;
598: ELSE
599: x_Flow_Schedule_Rec.attribute10 := nvl(p_flow_schedule_pvt_rec.attribute10,FND_API.G_MISS_CHAR ) ;
600: END IF;
601:
602: IF ( p_flow_schedule_pvt_rec.attribute11 = FND_API.G_MISS_CHAR ) THEN
603: x_Flow_Schedule_Rec.attribute11 := NULL;

Line 602: IF ( p_flow_schedule_pvt_rec.attribute11 = FND_API.G_MISS_CHAR ) THEN

598: ELSE
599: x_Flow_Schedule_Rec.attribute10 := nvl(p_flow_schedule_pvt_rec.attribute10,FND_API.G_MISS_CHAR ) ;
600: END IF;
601:
602: IF ( p_flow_schedule_pvt_rec.attribute11 = FND_API.G_MISS_CHAR ) THEN
603: x_Flow_Schedule_Rec.attribute11 := NULL;
604: ELSE
605: x_Flow_Schedule_Rec.attribute11 := nvl(p_flow_schedule_pvt_rec.attribute11,FND_API.G_MISS_CHAR ) ;
606: END IF;

Line 605: x_Flow_Schedule_Rec.attribute11 := nvl(p_flow_schedule_pvt_rec.attribute11,FND_API.G_MISS_CHAR ) ;

601:
602: IF ( p_flow_schedule_pvt_rec.attribute11 = FND_API.G_MISS_CHAR ) THEN
603: x_Flow_Schedule_Rec.attribute11 := NULL;
604: ELSE
605: x_Flow_Schedule_Rec.attribute11 := nvl(p_flow_schedule_pvt_rec.attribute11,FND_API.G_MISS_CHAR ) ;
606: END IF;
607:
608: IF ( p_flow_schedule_pvt_rec.attribute12 = FND_API.G_MISS_CHAR ) THEN
609: x_Flow_Schedule_Rec.attribute12 := NULL;

Line 608: IF ( p_flow_schedule_pvt_rec.attribute12 = FND_API.G_MISS_CHAR ) THEN

604: ELSE
605: x_Flow_Schedule_Rec.attribute11 := nvl(p_flow_schedule_pvt_rec.attribute11,FND_API.G_MISS_CHAR ) ;
606: END IF;
607:
608: IF ( p_flow_schedule_pvt_rec.attribute12 = FND_API.G_MISS_CHAR ) THEN
609: x_Flow_Schedule_Rec.attribute12 := NULL;
610: ELSE
611: x_Flow_Schedule_Rec.attribute12 := nvl(p_flow_schedule_pvt_rec.attribute12,FND_API.G_MISS_CHAR ) ;
612: END IF;

Line 611: x_Flow_Schedule_Rec.attribute12 := nvl(p_flow_schedule_pvt_rec.attribute12,FND_API.G_MISS_CHAR ) ;

607:
608: IF ( p_flow_schedule_pvt_rec.attribute12 = FND_API.G_MISS_CHAR ) THEN
609: x_Flow_Schedule_Rec.attribute12 := NULL;
610: ELSE
611: x_Flow_Schedule_Rec.attribute12 := nvl(p_flow_schedule_pvt_rec.attribute12,FND_API.G_MISS_CHAR ) ;
612: END IF;
613:
614: IF ( p_flow_schedule_pvt_rec.attribute13 = FND_API.G_MISS_CHAR ) THEN
615: x_Flow_Schedule_Rec.attribute13 := NULL;

Line 614: IF ( p_flow_schedule_pvt_rec.attribute13 = FND_API.G_MISS_CHAR ) THEN

610: ELSE
611: x_Flow_Schedule_Rec.attribute12 := nvl(p_flow_schedule_pvt_rec.attribute12,FND_API.G_MISS_CHAR ) ;
612: END IF;
613:
614: IF ( p_flow_schedule_pvt_rec.attribute13 = FND_API.G_MISS_CHAR ) THEN
615: x_Flow_Schedule_Rec.attribute13 := NULL;
616: ELSE
617: x_Flow_Schedule_Rec.attribute13 := nvl(p_flow_schedule_pvt_rec.attribute13,FND_API.G_MISS_CHAR ) ;
618: END IF;

Line 617: x_Flow_Schedule_Rec.attribute13 := nvl(p_flow_schedule_pvt_rec.attribute13,FND_API.G_MISS_CHAR ) ;

613:
614: IF ( p_flow_schedule_pvt_rec.attribute13 = FND_API.G_MISS_CHAR ) THEN
615: x_Flow_Schedule_Rec.attribute13 := NULL;
616: ELSE
617: x_Flow_Schedule_Rec.attribute13 := nvl(p_flow_schedule_pvt_rec.attribute13,FND_API.G_MISS_CHAR ) ;
618: END IF;
619:
620: IF ( p_flow_schedule_pvt_rec.attribute14 = FND_API.G_MISS_CHAR ) THEN
621: x_Flow_Schedule_Rec.attribute14 := NULL;

Line 620: IF ( p_flow_schedule_pvt_rec.attribute14 = FND_API.G_MISS_CHAR ) THEN

616: ELSE
617: x_Flow_Schedule_Rec.attribute13 := nvl(p_flow_schedule_pvt_rec.attribute13,FND_API.G_MISS_CHAR ) ;
618: END IF;
619:
620: IF ( p_flow_schedule_pvt_rec.attribute14 = FND_API.G_MISS_CHAR ) THEN
621: x_Flow_Schedule_Rec.attribute14 := NULL;
622: ELSE
623: x_Flow_Schedule_Rec.attribute14 := nvl(p_flow_schedule_pvt_rec.attribute14,FND_API.G_MISS_CHAR ) ;
624: END IF;

Line 623: x_Flow_Schedule_Rec.attribute14 := nvl(p_flow_schedule_pvt_rec.attribute14,FND_API.G_MISS_CHAR ) ;

619:
620: IF ( p_flow_schedule_pvt_rec.attribute14 = FND_API.G_MISS_CHAR ) THEN
621: x_Flow_Schedule_Rec.attribute14 := NULL;
622: ELSE
623: x_Flow_Schedule_Rec.attribute14 := nvl(p_flow_schedule_pvt_rec.attribute14,FND_API.G_MISS_CHAR ) ;
624: END IF;
625:
626: IF ( p_flow_schedule_pvt_rec.attribute15 = FND_API.G_MISS_CHAR ) THEN
627: x_Flow_Schedule_Rec.attribute15 := NULL;

Line 626: IF ( p_flow_schedule_pvt_rec.attribute15 = FND_API.G_MISS_CHAR ) THEN

622: ELSE
623: x_Flow_Schedule_Rec.attribute14 := nvl(p_flow_schedule_pvt_rec.attribute14,FND_API.G_MISS_CHAR ) ;
624: END IF;
625:
626: IF ( p_flow_schedule_pvt_rec.attribute15 = FND_API.G_MISS_CHAR ) THEN
627: x_Flow_Schedule_Rec.attribute15 := NULL;
628: ELSE
629: x_Flow_Schedule_Rec.attribute15 := nvl(p_flow_schedule_pvt_rec.attribute15,FND_API.G_MISS_CHAR ) ;
630: END IF;

Line 629: x_Flow_Schedule_Rec.attribute15 := nvl(p_flow_schedule_pvt_rec.attribute15,FND_API.G_MISS_CHAR ) ;

625:
626: IF ( p_flow_schedule_pvt_rec.attribute15 = FND_API.G_MISS_CHAR ) THEN
627: x_Flow_Schedule_Rec.attribute15 := NULL;
628: ELSE
629: x_Flow_Schedule_Rec.attribute15 := nvl(p_flow_schedule_pvt_rec.attribute15,FND_API.G_MISS_CHAR ) ;
630: END IF;
631:
632: IF ( p_flow_schedule_pvt_rec.attribute2 = FND_API.G_MISS_CHAR ) THEN
633: x_Flow_Schedule_Rec.attribute2 := NULL;

Line 632: IF ( p_flow_schedule_pvt_rec.attribute2 = FND_API.G_MISS_CHAR ) THEN

628: ELSE
629: x_Flow_Schedule_Rec.attribute15 := nvl(p_flow_schedule_pvt_rec.attribute15,FND_API.G_MISS_CHAR ) ;
630: END IF;
631:
632: IF ( p_flow_schedule_pvt_rec.attribute2 = FND_API.G_MISS_CHAR ) THEN
633: x_Flow_Schedule_Rec.attribute2 := NULL;
634: ELSE
635: x_Flow_Schedule_Rec.attribute2 := nvl(p_flow_schedule_pvt_rec.attribute2,FND_API.G_MISS_CHAR ) ;
636: END IF;

Line 635: x_Flow_Schedule_Rec.attribute2 := nvl(p_flow_schedule_pvt_rec.attribute2,FND_API.G_MISS_CHAR ) ;

631:
632: IF ( p_flow_schedule_pvt_rec.attribute2 = FND_API.G_MISS_CHAR ) THEN
633: x_Flow_Schedule_Rec.attribute2 := NULL;
634: ELSE
635: x_Flow_Schedule_Rec.attribute2 := nvl(p_flow_schedule_pvt_rec.attribute2,FND_API.G_MISS_CHAR ) ;
636: END IF;
637:
638: IF ( p_flow_schedule_pvt_rec.attribute3 = FND_API.G_MISS_CHAR ) THEN
639: x_Flow_Schedule_Rec.attribute3 := NULL;

Line 638: IF ( p_flow_schedule_pvt_rec.attribute3 = FND_API.G_MISS_CHAR ) THEN

634: ELSE
635: x_Flow_Schedule_Rec.attribute2 := nvl(p_flow_schedule_pvt_rec.attribute2,FND_API.G_MISS_CHAR ) ;
636: END IF;
637:
638: IF ( p_flow_schedule_pvt_rec.attribute3 = FND_API.G_MISS_CHAR ) THEN
639: x_Flow_Schedule_Rec.attribute3 := NULL;
640: ELSE
641: x_Flow_Schedule_Rec.attribute3 := nvl(p_flow_schedule_pvt_rec.attribute3,FND_API.G_MISS_CHAR ) ;
642: END IF;

Line 641: x_Flow_Schedule_Rec.attribute3 := nvl(p_flow_schedule_pvt_rec.attribute3,FND_API.G_MISS_CHAR ) ;

637:
638: IF ( p_flow_schedule_pvt_rec.attribute3 = FND_API.G_MISS_CHAR ) THEN
639: x_Flow_Schedule_Rec.attribute3 := NULL;
640: ELSE
641: x_Flow_Schedule_Rec.attribute3 := nvl(p_flow_schedule_pvt_rec.attribute3,FND_API.G_MISS_CHAR ) ;
642: END IF;
643:
644: IF ( p_flow_schedule_pvt_rec.attribute4 = FND_API.G_MISS_CHAR ) THEN
645: x_Flow_Schedule_Rec.attribute4 := NULL;

Line 644: IF ( p_flow_schedule_pvt_rec.attribute4 = FND_API.G_MISS_CHAR ) THEN

640: ELSE
641: x_Flow_Schedule_Rec.attribute3 := nvl(p_flow_schedule_pvt_rec.attribute3,FND_API.G_MISS_CHAR ) ;
642: END IF;
643:
644: IF ( p_flow_schedule_pvt_rec.attribute4 = FND_API.G_MISS_CHAR ) THEN
645: x_Flow_Schedule_Rec.attribute4 := NULL;
646: ELSE
647: x_Flow_Schedule_Rec.attribute4 := nvl(p_flow_schedule_pvt_rec.attribute4 ,FND_API.G_MISS_CHAR ) ;
648: END IF;

Line 647: x_Flow_Schedule_Rec.attribute4 := nvl(p_flow_schedule_pvt_rec.attribute4 ,FND_API.G_MISS_CHAR ) ;

643:
644: IF ( p_flow_schedule_pvt_rec.attribute4 = FND_API.G_MISS_CHAR ) THEN
645: x_Flow_Schedule_Rec.attribute4 := NULL;
646: ELSE
647: x_Flow_Schedule_Rec.attribute4 := nvl(p_flow_schedule_pvt_rec.attribute4 ,FND_API.G_MISS_CHAR ) ;
648: END IF;
649:
650: IF ( p_flow_schedule_pvt_rec.attribute5 = FND_API.G_MISS_CHAR ) THEN
651: x_Flow_Schedule_Rec.attribute5 := NULL;

Line 650: IF ( p_flow_schedule_pvt_rec.attribute5 = FND_API.G_MISS_CHAR ) THEN

646: ELSE
647: x_Flow_Schedule_Rec.attribute4 := nvl(p_flow_schedule_pvt_rec.attribute4 ,FND_API.G_MISS_CHAR ) ;
648: END IF;
649:
650: IF ( p_flow_schedule_pvt_rec.attribute5 = FND_API.G_MISS_CHAR ) THEN
651: x_Flow_Schedule_Rec.attribute5 := NULL;
652: ELSE
653: x_Flow_Schedule_Rec.attribute5 := nvl(p_flow_schedule_pvt_rec.attribute5 ,FND_API.G_MISS_CHAR ) ;
654: END IF;

Line 653: x_Flow_Schedule_Rec.attribute5 := nvl(p_flow_schedule_pvt_rec.attribute5 ,FND_API.G_MISS_CHAR ) ;

649:
650: IF ( p_flow_schedule_pvt_rec.attribute5 = FND_API.G_MISS_CHAR ) THEN
651: x_Flow_Schedule_Rec.attribute5 := NULL;
652: ELSE
653: x_Flow_Schedule_Rec.attribute5 := nvl(p_flow_schedule_pvt_rec.attribute5 ,FND_API.G_MISS_CHAR ) ;
654: END IF;
655:
656: IF ( p_flow_schedule_pvt_rec.attribute6 = FND_API.G_MISS_CHAR ) THEN
657: x_Flow_Schedule_Rec.attribute6 := NULL;

Line 656: IF ( p_flow_schedule_pvt_rec.attribute6 = FND_API.G_MISS_CHAR ) THEN

652: ELSE
653: x_Flow_Schedule_Rec.attribute5 := nvl(p_flow_schedule_pvt_rec.attribute5 ,FND_API.G_MISS_CHAR ) ;
654: END IF;
655:
656: IF ( p_flow_schedule_pvt_rec.attribute6 = FND_API.G_MISS_CHAR ) THEN
657: x_Flow_Schedule_Rec.attribute6 := NULL;
658: ELSE
659: x_Flow_Schedule_Rec.attribute6 := nvl(p_flow_schedule_pvt_rec.attribute6 ,FND_API.G_MISS_CHAR ) ;
660: END IF;

Line 659: x_Flow_Schedule_Rec.attribute6 := nvl(p_flow_schedule_pvt_rec.attribute6 ,FND_API.G_MISS_CHAR ) ;

655:
656: IF ( p_flow_schedule_pvt_rec.attribute6 = FND_API.G_MISS_CHAR ) THEN
657: x_Flow_Schedule_Rec.attribute6 := NULL;
658: ELSE
659: x_Flow_Schedule_Rec.attribute6 := nvl(p_flow_schedule_pvt_rec.attribute6 ,FND_API.G_MISS_CHAR ) ;
660: END IF;
661:
662: IF ( p_flow_schedule_pvt_rec.attribute7 = FND_API.G_MISS_CHAR ) THEN
663: x_Flow_Schedule_Rec.attribute7 := NULL;

Line 662: IF ( p_flow_schedule_pvt_rec.attribute7 = FND_API.G_MISS_CHAR ) THEN

658: ELSE
659: x_Flow_Schedule_Rec.attribute6 := nvl(p_flow_schedule_pvt_rec.attribute6 ,FND_API.G_MISS_CHAR ) ;
660: END IF;
661:
662: IF ( p_flow_schedule_pvt_rec.attribute7 = FND_API.G_MISS_CHAR ) THEN
663: x_Flow_Schedule_Rec.attribute7 := NULL;
664: ELSE
665: x_Flow_Schedule_Rec.attribute7 := nvl(p_flow_schedule_pvt_rec.attribute7 ,FND_API.G_MISS_CHAR ) ;
666: END IF;

Line 665: x_Flow_Schedule_Rec.attribute7 := nvl(p_flow_schedule_pvt_rec.attribute7 ,FND_API.G_MISS_CHAR ) ;

661:
662: IF ( p_flow_schedule_pvt_rec.attribute7 = FND_API.G_MISS_CHAR ) THEN
663: x_Flow_Schedule_Rec.attribute7 := NULL;
664: ELSE
665: x_Flow_Schedule_Rec.attribute7 := nvl(p_flow_schedule_pvt_rec.attribute7 ,FND_API.G_MISS_CHAR ) ;
666: END IF;
667:
668: IF ( p_flow_schedule_pvt_rec.attribute8 = FND_API.G_MISS_CHAR ) THEN
669: x_Flow_Schedule_Rec.attribute8 := NULL;

Line 668: IF ( p_flow_schedule_pvt_rec.attribute8 = FND_API.G_MISS_CHAR ) THEN

664: ELSE
665: x_Flow_Schedule_Rec.attribute7 := nvl(p_flow_schedule_pvt_rec.attribute7 ,FND_API.G_MISS_CHAR ) ;
666: END IF;
667:
668: IF ( p_flow_schedule_pvt_rec.attribute8 = FND_API.G_MISS_CHAR ) THEN
669: x_Flow_Schedule_Rec.attribute8 := NULL;
670: ELSE
671: x_Flow_Schedule_Rec.attribute8 := nvl(p_flow_schedule_pvt_rec.attribute8 ,FND_API.G_MISS_CHAR ) ;
672: END IF;

Line 671: x_Flow_Schedule_Rec.attribute8 := nvl(p_flow_schedule_pvt_rec.attribute8 ,FND_API.G_MISS_CHAR ) ;

667:
668: IF ( p_flow_schedule_pvt_rec.attribute8 = FND_API.G_MISS_CHAR ) THEN
669: x_Flow_Schedule_Rec.attribute8 := NULL;
670: ELSE
671: x_Flow_Schedule_Rec.attribute8 := nvl(p_flow_schedule_pvt_rec.attribute8 ,FND_API.G_MISS_CHAR ) ;
672: END IF;
673:
674: IF ( p_flow_schedule_pvt_rec.attribute9 = FND_API.G_MISS_CHAR ) THEN
675: x_Flow_Schedule_Rec.attribute9 := NULL;

Line 674: IF ( p_flow_schedule_pvt_rec.attribute9 = FND_API.G_MISS_CHAR ) THEN

670: ELSE
671: x_Flow_Schedule_Rec.attribute8 := nvl(p_flow_schedule_pvt_rec.attribute8 ,FND_API.G_MISS_CHAR ) ;
672: END IF;
673:
674: IF ( p_flow_schedule_pvt_rec.attribute9 = FND_API.G_MISS_CHAR ) THEN
675: x_Flow_Schedule_Rec.attribute9 := NULL;
676: ELSE
677: x_Flow_Schedule_Rec.attribute9 := nvl(p_flow_schedule_pvt_rec.attribute9 ,FND_API.G_MISS_CHAR ) ;
678: END IF;

Line 677: x_Flow_Schedule_Rec.attribute9 := nvl(p_flow_schedule_pvt_rec.attribute9 ,FND_API.G_MISS_CHAR ) ;

673:
674: IF ( p_flow_schedule_pvt_rec.attribute9 = FND_API.G_MISS_CHAR ) THEN
675: x_Flow_Schedule_Rec.attribute9 := NULL;
676: ELSE
677: x_Flow_Schedule_Rec.attribute9 := nvl(p_flow_schedule_pvt_rec.attribute9 ,FND_API.G_MISS_CHAR ) ;
678: END IF;
679:
680: IF ( p_flow_schedule_pvt_rec.attribute_category = FND_API.G_MISS_CHAR ) THEN
681: x_Flow_Schedule_Rec.attribute_category := NULL;

Line 680: IF ( p_flow_schedule_pvt_rec.attribute_category = FND_API.G_MISS_CHAR ) THEN

676: ELSE
677: x_Flow_Schedule_Rec.attribute9 := nvl(p_flow_schedule_pvt_rec.attribute9 ,FND_API.G_MISS_CHAR ) ;
678: END IF;
679:
680: IF ( p_flow_schedule_pvt_rec.attribute_category = FND_API.G_MISS_CHAR ) THEN
681: x_Flow_Schedule_Rec.attribute_category := NULL;
682: ELSE
683: x_Flow_Schedule_Rec.attribute_category := nvl(p_flow_schedule_pvt_rec.attribute_category ,FND_API.G_MISS_CHAR ) ;
684: END IF;

Line 683: x_Flow_Schedule_Rec.attribute_category := nvl(p_flow_schedule_pvt_rec.attribute_category ,FND_API.G_MISS_CHAR ) ;

679:
680: IF ( p_flow_schedule_pvt_rec.attribute_category = FND_API.G_MISS_CHAR ) THEN
681: x_Flow_Schedule_Rec.attribute_category := NULL;
682: ELSE
683: x_Flow_Schedule_Rec.attribute_category := nvl(p_flow_schedule_pvt_rec.attribute_category ,FND_API.G_MISS_CHAR ) ;
684: END IF;
685:
686: IF ( p_flow_schedule_pvt_rec.bom_revision = FND_API.G_MISS_CHAR ) THEN
687: x_Flow_Schedule_Rec.bom_revision := NULL;

Line 686: IF ( p_flow_schedule_pvt_rec.bom_revision = FND_API.G_MISS_CHAR ) THEN

682: ELSE
683: x_Flow_Schedule_Rec.attribute_category := nvl(p_flow_schedule_pvt_rec.attribute_category ,FND_API.G_MISS_CHAR ) ;
684: END IF;
685:
686: IF ( p_flow_schedule_pvt_rec.bom_revision = FND_API.G_MISS_CHAR ) THEN
687: x_Flow_Schedule_Rec.bom_revision := NULL;
688: ELSE
689: x_Flow_Schedule_Rec.bom_revision := nvl(p_flow_schedule_pvt_rec.bom_revision ,FND_API.G_MISS_CHAR ) ;
690: END IF;

Line 689: x_Flow_Schedule_Rec.bom_revision := nvl(p_flow_schedule_pvt_rec.bom_revision ,FND_API.G_MISS_CHAR ) ;

685:
686: IF ( p_flow_schedule_pvt_rec.bom_revision = FND_API.G_MISS_CHAR ) THEN
687: x_Flow_Schedule_Rec.bom_revision := NULL;
688: ELSE
689: x_Flow_Schedule_Rec.bom_revision := nvl(p_flow_schedule_pvt_rec.bom_revision ,FND_API.G_MISS_CHAR ) ;
690: END IF;
691:
692: IF ( p_flow_schedule_pvt_rec.bom_revision_date = FND_API.G_MISS_DATE ) THEN
693: x_Flow_Schedule_Rec.bom_revision_date := NULL;

Line 692: IF ( p_flow_schedule_pvt_rec.bom_revision_date = FND_API.G_MISS_DATE ) THEN

688: ELSE
689: x_Flow_Schedule_Rec.bom_revision := nvl(p_flow_schedule_pvt_rec.bom_revision ,FND_API.G_MISS_CHAR ) ;
690: END IF;
691:
692: IF ( p_flow_schedule_pvt_rec.bom_revision_date = FND_API.G_MISS_DATE ) THEN
693: x_Flow_Schedule_Rec.bom_revision_date := NULL;
694: ELSE
695: x_Flow_Schedule_Rec.bom_revision_date := nvl(p_flow_schedule_pvt_rec.bom_revision_date,FND_API.G_MISS_DATE ) ;
696: END IF;

Line 695: x_Flow_Schedule_Rec.bom_revision_date := nvl(p_flow_schedule_pvt_rec.bom_revision_date,FND_API.G_MISS_DATE ) ;

691:
692: IF ( p_flow_schedule_pvt_rec.bom_revision_date = FND_API.G_MISS_DATE ) THEN
693: x_Flow_Schedule_Rec.bom_revision_date := NULL;
694: ELSE
695: x_Flow_Schedule_Rec.bom_revision_date := nvl(p_flow_schedule_pvt_rec.bom_revision_date,FND_API.G_MISS_DATE ) ;
696: END IF;
697:
698: IF ( p_flow_schedule_pvt_rec.build_sequence = FND_API.G_MISS_NUM ) THEN
699: x_Flow_Schedule_Rec.build_sequence := NULL;

Line 698: IF ( p_flow_schedule_pvt_rec.build_sequence = FND_API.G_MISS_NUM ) THEN

694: ELSE
695: x_Flow_Schedule_Rec.bom_revision_date := nvl(p_flow_schedule_pvt_rec.bom_revision_date,FND_API.G_MISS_DATE ) ;
696: END IF;
697:
698: IF ( p_flow_schedule_pvt_rec.build_sequence = FND_API.G_MISS_NUM ) THEN
699: x_Flow_Schedule_Rec.build_sequence := NULL;
700: ELSE
701: x_Flow_Schedule_Rec.build_sequence := NVL(p_flow_schedule_pvt_rec.build_sequence , FND_API.G_MISS_NUM );
702: END IF;

Line 701: x_Flow_Schedule_Rec.build_sequence := NVL(p_flow_schedule_pvt_rec.build_sequence , FND_API.G_MISS_NUM );

697:
698: IF ( p_flow_schedule_pvt_rec.build_sequence = FND_API.G_MISS_NUM ) THEN
699: x_Flow_Schedule_Rec.build_sequence := NULL;
700: ELSE
701: x_Flow_Schedule_Rec.build_sequence := NVL(p_flow_schedule_pvt_rec.build_sequence , FND_API.G_MISS_NUM );
702: END IF;
703:
704: IF ( p_flow_schedule_pvt_rec.class_code = FND_API.G_MISS_CHAR ) THEN
705: x_Flow_Schedule_Rec.class_code := NULL;

Line 704: IF ( p_flow_schedule_pvt_rec.class_code = FND_API.G_MISS_CHAR ) THEN

700: ELSE
701: x_Flow_Schedule_Rec.build_sequence := NVL(p_flow_schedule_pvt_rec.build_sequence , FND_API.G_MISS_NUM );
702: END IF;
703:
704: IF ( p_flow_schedule_pvt_rec.class_code = FND_API.G_MISS_CHAR ) THEN
705: x_Flow_Schedule_Rec.class_code := NULL;
706: ELSE
707: x_Flow_Schedule_Rec.class_code := nvl(p_flow_schedule_pvt_rec.class_code,FND_API.G_MISS_CHAR) ;
708: END IF;

Line 707: x_Flow_Schedule_Rec.class_code := nvl(p_flow_schedule_pvt_rec.class_code,FND_API.G_MISS_CHAR) ;

703:
704: IF ( p_flow_schedule_pvt_rec.class_code = FND_API.G_MISS_CHAR ) THEN
705: x_Flow_Schedule_Rec.class_code := NULL;
706: ELSE
707: x_Flow_Schedule_Rec.class_code := nvl(p_flow_schedule_pvt_rec.class_code,FND_API.G_MISS_CHAR) ;
708: END IF;
709:
710: IF ( p_flow_schedule_pvt_rec.completion_locator_id = FND_API.G_MISS_NUM ) THEN
711: x_Flow_Schedule_Rec.completion_locator_id := NULL;

Line 710: IF ( p_flow_schedule_pvt_rec.completion_locator_id = FND_API.G_MISS_NUM ) THEN

706: ELSE
707: x_Flow_Schedule_Rec.class_code := nvl(p_flow_schedule_pvt_rec.class_code,FND_API.G_MISS_CHAR) ;
708: END IF;
709:
710: IF ( p_flow_schedule_pvt_rec.completion_locator_id = FND_API.G_MISS_NUM ) THEN
711: x_Flow_Schedule_Rec.completion_locator_id := NULL;
712: ELSE
713: x_Flow_Schedule_Rec.completion_locator_id := nvl(p_flow_schedule_pvt_rec.completion_locator_id,FND_API.G_MISS_NUM) ;
714: END IF;

Line 713: x_Flow_Schedule_Rec.completion_locator_id := nvl(p_flow_schedule_pvt_rec.completion_locator_id,FND_API.G_MISS_NUM) ;

709:
710: IF ( p_flow_schedule_pvt_rec.completion_locator_id = FND_API.G_MISS_NUM ) THEN
711: x_Flow_Schedule_Rec.completion_locator_id := NULL;
712: ELSE
713: x_Flow_Schedule_Rec.completion_locator_id := nvl(p_flow_schedule_pvt_rec.completion_locator_id,FND_API.G_MISS_NUM) ;
714: END IF;
715:
716: IF ( p_flow_schedule_pvt_rec.completion_subinventory = FND_API.G_MISS_CHAR ) THEN
717: x_Flow_Schedule_Rec.completion_subinventory := NULL;

Line 716: IF ( p_flow_schedule_pvt_rec.completion_subinventory = FND_API.G_MISS_CHAR ) THEN

712: ELSE
713: x_Flow_Schedule_Rec.completion_locator_id := nvl(p_flow_schedule_pvt_rec.completion_locator_id,FND_API.G_MISS_NUM) ;
714: END IF;
715:
716: IF ( p_flow_schedule_pvt_rec.completion_subinventory = FND_API.G_MISS_CHAR ) THEN
717: x_Flow_Schedule_Rec.completion_subinventory := NULL;
718: ELSE
719: x_Flow_Schedule_Rec.completion_subinventory := nvl(p_flow_schedule_pvt_rec.completion_subinventory,FND_API.G_MISS_CHAR) ;
720: END IF;

Line 719: x_Flow_Schedule_Rec.completion_subinventory := nvl(p_flow_schedule_pvt_rec.completion_subinventory,FND_API.G_MISS_CHAR) ;

715:
716: IF ( p_flow_schedule_pvt_rec.completion_subinventory = FND_API.G_MISS_CHAR ) THEN
717: x_Flow_Schedule_Rec.completion_subinventory := NULL;
718: ELSE
719: x_Flow_Schedule_Rec.completion_subinventory := nvl(p_flow_schedule_pvt_rec.completion_subinventory,FND_API.G_MISS_CHAR) ;
720: END IF;
721:
722: IF ( p_flow_schedule_pvt_rec.created_by = FND_API.G_MISS_NUM ) THEN
723: x_Flow_Schedule_Rec.created_by := NULL;

Line 722: IF ( p_flow_schedule_pvt_rec.created_by = FND_API.G_MISS_NUM ) THEN

718: ELSE
719: x_Flow_Schedule_Rec.completion_subinventory := nvl(p_flow_schedule_pvt_rec.completion_subinventory,FND_API.G_MISS_CHAR) ;
720: END IF;
721:
722: IF ( p_flow_schedule_pvt_rec.created_by = FND_API.G_MISS_NUM ) THEN
723: x_Flow_Schedule_Rec.created_by := NULL;
724: ELSE
725: x_Flow_Schedule_Rec.created_by := nvl(p_flow_schedule_pvt_rec.created_by,FND_API.G_MISS_NUM );
726: END IF;

Line 725: x_Flow_Schedule_Rec.created_by := nvl(p_flow_schedule_pvt_rec.created_by,FND_API.G_MISS_NUM );

721:
722: IF ( p_flow_schedule_pvt_rec.created_by = FND_API.G_MISS_NUM ) THEN
723: x_Flow_Schedule_Rec.created_by := NULL;
724: ELSE
725: x_Flow_Schedule_Rec.created_by := nvl(p_flow_schedule_pvt_rec.created_by,FND_API.G_MISS_NUM );
726: END IF;
727:
728: IF ( p_flow_schedule_pvt_rec.creation_date = FND_API.G_MISS_DATE ) THEN
729: x_Flow_Schedule_Rec.creation_date := NULL;

Line 728: IF ( p_flow_schedule_pvt_rec.creation_date = FND_API.G_MISS_DATE ) THEN

724: ELSE
725: x_Flow_Schedule_Rec.created_by := nvl(p_flow_schedule_pvt_rec.created_by,FND_API.G_MISS_NUM );
726: END IF;
727:
728: IF ( p_flow_schedule_pvt_rec.creation_date = FND_API.G_MISS_DATE ) THEN
729: x_Flow_Schedule_Rec.creation_date := NULL;
730: ELSE
731: x_Flow_Schedule_Rec.creation_date := nvl(p_flow_schedule_pvt_rec.creation_date,FND_API.G_MISS_DATE ) ;
732: END IF;

Line 731: x_Flow_Schedule_Rec.creation_date := nvl(p_flow_schedule_pvt_rec.creation_date,FND_API.G_MISS_DATE ) ;

727:
728: IF ( p_flow_schedule_pvt_rec.creation_date = FND_API.G_MISS_DATE ) THEN
729: x_Flow_Schedule_Rec.creation_date := NULL;
730: ELSE
731: x_Flow_Schedule_Rec.creation_date := nvl(p_flow_schedule_pvt_rec.creation_date,FND_API.G_MISS_DATE ) ;
732: END IF;
733:
734: IF ( p_flow_schedule_pvt_rec.date_closed = FND_API.G_MISS_DATE ) THEN
735: x_Flow_Schedule_Rec.date_closed := NULL;

Line 734: IF ( p_flow_schedule_pvt_rec.date_closed = FND_API.G_MISS_DATE ) THEN

730: ELSE
731: x_Flow_Schedule_Rec.creation_date := nvl(p_flow_schedule_pvt_rec.creation_date,FND_API.G_MISS_DATE ) ;
732: END IF;
733:
734: IF ( p_flow_schedule_pvt_rec.date_closed = FND_API.G_MISS_DATE ) THEN
735: x_Flow_Schedule_Rec.date_closed := NULL;
736: ELSE
737: x_Flow_Schedule_Rec.date_closed := nvl(p_flow_schedule_pvt_rec.date_closed,FND_API.G_MISS_DATE) ;
738: END IF;

Line 737: x_Flow_Schedule_Rec.date_closed := nvl(p_flow_schedule_pvt_rec.date_closed,FND_API.G_MISS_DATE) ;

733:
734: IF ( p_flow_schedule_pvt_rec.date_closed = FND_API.G_MISS_DATE ) THEN
735: x_Flow_Schedule_Rec.date_closed := NULL;
736: ELSE
737: x_Flow_Schedule_Rec.date_closed := nvl(p_flow_schedule_pvt_rec.date_closed,FND_API.G_MISS_DATE) ;
738: END IF;
739:
740: IF ( p_flow_schedule_pvt_rec.demand_class = FND_API.G_MISS_CHAR ) THEN
741: x_Flow_Schedule_Rec.demand_class := NULL;

Line 740: IF ( p_flow_schedule_pvt_rec.demand_class = FND_API.G_MISS_CHAR ) THEN

736: ELSE
737: x_Flow_Schedule_Rec.date_closed := nvl(p_flow_schedule_pvt_rec.date_closed,FND_API.G_MISS_DATE) ;
738: END IF;
739:
740: IF ( p_flow_schedule_pvt_rec.demand_class = FND_API.G_MISS_CHAR ) THEN
741: x_Flow_Schedule_Rec.demand_class := NULL;
742: ELSE
743: x_Flow_Schedule_Rec.demand_class := nvl(p_flow_schedule_pvt_rec.demand_class ,FND_API.G_MISS_CHAR ) ;
744: END IF;

Line 743: x_Flow_Schedule_Rec.demand_class := nvl(p_flow_schedule_pvt_rec.demand_class ,FND_API.G_MISS_CHAR ) ;

739:
740: IF ( p_flow_schedule_pvt_rec.demand_class = FND_API.G_MISS_CHAR ) THEN
741: x_Flow_Schedule_Rec.demand_class := NULL;
742: ELSE
743: x_Flow_Schedule_Rec.demand_class := nvl(p_flow_schedule_pvt_rec.demand_class ,FND_API.G_MISS_CHAR ) ;
744: END IF;
745:
746: IF ( p_flow_schedule_pvt_rec.demand_source_delivery = FND_API.G_MISS_CHAR ) THEN
747: x_Flow_Schedule_Rec.demand_source_delivery := NULL;

Line 746: IF ( p_flow_schedule_pvt_rec.demand_source_delivery = FND_API.G_MISS_CHAR ) THEN

742: ELSE
743: x_Flow_Schedule_Rec.demand_class := nvl(p_flow_schedule_pvt_rec.demand_class ,FND_API.G_MISS_CHAR ) ;
744: END IF;
745:
746: IF ( p_flow_schedule_pvt_rec.demand_source_delivery = FND_API.G_MISS_CHAR ) THEN
747: x_Flow_Schedule_Rec.demand_source_delivery := NULL;
748: ELSE
749: x_Flow_Schedule_Rec.demand_source_delivery := nvl(p_flow_schedule_pvt_rec.demand_source_delivery ,FND_API.G_MISS_CHAR) ;
750: END IF;

Line 749: x_Flow_Schedule_Rec.demand_source_delivery := nvl(p_flow_schedule_pvt_rec.demand_source_delivery ,FND_API.G_MISS_CHAR) ;

745:
746: IF ( p_flow_schedule_pvt_rec.demand_source_delivery = FND_API.G_MISS_CHAR ) THEN
747: x_Flow_Schedule_Rec.demand_source_delivery := NULL;
748: ELSE
749: x_Flow_Schedule_Rec.demand_source_delivery := nvl(p_flow_schedule_pvt_rec.demand_source_delivery ,FND_API.G_MISS_CHAR) ;
750: END IF;
751:
752: IF ( p_flow_schedule_pvt_rec.demand_source_header_id = FND_API.G_MISS_NUM ) THEN
753: x_Flow_Schedule_Rec.demand_source_header_id := NULL;

Line 752: IF ( p_flow_schedule_pvt_rec.demand_source_header_id = FND_API.G_MISS_NUM ) THEN

748: ELSE
749: x_Flow_Schedule_Rec.demand_source_delivery := nvl(p_flow_schedule_pvt_rec.demand_source_delivery ,FND_API.G_MISS_CHAR) ;
750: END IF;
751:
752: IF ( p_flow_schedule_pvt_rec.demand_source_header_id = FND_API.G_MISS_NUM ) THEN
753: x_Flow_Schedule_Rec.demand_source_header_id := NULL;
754: ELSE
755: x_Flow_Schedule_Rec.demand_source_header_id := nvl(p_flow_schedule_pvt_rec.demand_source_header_id ,FND_API.G_MISS_NUM ) ;
756: END IF;

Line 755: x_Flow_Schedule_Rec.demand_source_header_id := nvl(p_flow_schedule_pvt_rec.demand_source_header_id ,FND_API.G_MISS_NUM ) ;

751:
752: IF ( p_flow_schedule_pvt_rec.demand_source_header_id = FND_API.G_MISS_NUM ) THEN
753: x_Flow_Schedule_Rec.demand_source_header_id := NULL;
754: ELSE
755: x_Flow_Schedule_Rec.demand_source_header_id := nvl(p_flow_schedule_pvt_rec.demand_source_header_id ,FND_API.G_MISS_NUM ) ;
756: END IF;
757:
758: IF ( p_flow_schedule_pvt_rec.demand_source_line = FND_API.G_MISS_CHAR ) THEN
759: x_Flow_Schedule_Rec.demand_source_line := NULL;

Line 758: IF ( p_flow_schedule_pvt_rec.demand_source_line = FND_API.G_MISS_CHAR ) THEN

754: ELSE
755: x_Flow_Schedule_Rec.demand_source_header_id := nvl(p_flow_schedule_pvt_rec.demand_source_header_id ,FND_API.G_MISS_NUM ) ;
756: END IF;
757:
758: IF ( p_flow_schedule_pvt_rec.demand_source_line = FND_API.G_MISS_CHAR ) THEN
759: x_Flow_Schedule_Rec.demand_source_line := NULL;
760: ELSE
761: x_Flow_Schedule_Rec.demand_source_line := nvl(p_flow_schedule_pvt_rec.demand_source_line,FND_API.G_MISS_CHAR ) ;
762: END IF;

Line 761: x_Flow_Schedule_Rec.demand_source_line := nvl(p_flow_schedule_pvt_rec.demand_source_line,FND_API.G_MISS_CHAR ) ;

757:
758: IF ( p_flow_schedule_pvt_rec.demand_source_line = FND_API.G_MISS_CHAR ) THEN
759: x_Flow_Schedule_Rec.demand_source_line := NULL;
760: ELSE
761: x_Flow_Schedule_Rec.demand_source_line := nvl(p_flow_schedule_pvt_rec.demand_source_line,FND_API.G_MISS_CHAR ) ;
762: END IF;
763:
764: IF ( p_flow_schedule_pvt_rec.demand_source_type = FND_API.G_MISS_NUM ) THEN
765: x_Flow_Schedule_Rec.demand_source_type := NULL;

Line 764: IF ( p_flow_schedule_pvt_rec.demand_source_type = FND_API.G_MISS_NUM ) THEN

760: ELSE
761: x_Flow_Schedule_Rec.demand_source_line := nvl(p_flow_schedule_pvt_rec.demand_source_line,FND_API.G_MISS_CHAR ) ;
762: END IF;
763:
764: IF ( p_flow_schedule_pvt_rec.demand_source_type = FND_API.G_MISS_NUM ) THEN
765: x_Flow_Schedule_Rec.demand_source_type := NULL;
766: ELSE
767: x_Flow_Schedule_Rec.demand_source_type := nvl(p_flow_schedule_pvt_rec.demand_source_type,FND_API.G_MISS_NUM ) ;
768: END IF;

Line 767: x_Flow_Schedule_Rec.demand_source_type := nvl(p_flow_schedule_pvt_rec.demand_source_type,FND_API.G_MISS_NUM ) ;

763:
764: IF ( p_flow_schedule_pvt_rec.demand_source_type = FND_API.G_MISS_NUM ) THEN
765: x_Flow_Schedule_Rec.demand_source_type := NULL;
766: ELSE
767: x_Flow_Schedule_Rec.demand_source_type := nvl(p_flow_schedule_pvt_rec.demand_source_type,FND_API.G_MISS_NUM ) ;
768: END IF;
769:
770: IF ( p_flow_schedule_pvt_rec.last_updated_by = FND_API.G_MISS_NUM) THEN
771: x_Flow_Schedule_Rec.last_updated_by := NULL;

Line 770: IF ( p_flow_schedule_pvt_rec.last_updated_by = FND_API.G_MISS_NUM) THEN

766: ELSE
767: x_Flow_Schedule_Rec.demand_source_type := nvl(p_flow_schedule_pvt_rec.demand_source_type,FND_API.G_MISS_NUM ) ;
768: END IF;
769:
770: IF ( p_flow_schedule_pvt_rec.last_updated_by = FND_API.G_MISS_NUM) THEN
771: x_Flow_Schedule_Rec.last_updated_by := NULL;
772: ELSE
773: x_Flow_Schedule_Rec.last_updated_by := nvl(p_flow_schedule_pvt_rec.last_updated_by,FND_API.G_MISS_NUM) ;
774: END IF;

Line 773: x_Flow_Schedule_Rec.last_updated_by := nvl(p_flow_schedule_pvt_rec.last_updated_by,FND_API.G_MISS_NUM) ;

769:
770: IF ( p_flow_schedule_pvt_rec.last_updated_by = FND_API.G_MISS_NUM) THEN
771: x_Flow_Schedule_Rec.last_updated_by := NULL;
772: ELSE
773: x_Flow_Schedule_Rec.last_updated_by := nvl(p_flow_schedule_pvt_rec.last_updated_by,FND_API.G_MISS_NUM) ;
774: END IF;
775:
776: IF ( p_flow_schedule_pvt_rec.last_update_date = FND_API.G_MISS_DATE ) THEN
777: x_Flow_Schedule_Rec.last_update_date := NULL;

Line 776: IF ( p_flow_schedule_pvt_rec.last_update_date = FND_API.G_MISS_DATE ) THEN

772: ELSE
773: x_Flow_Schedule_Rec.last_updated_by := nvl(p_flow_schedule_pvt_rec.last_updated_by,FND_API.G_MISS_NUM) ;
774: END IF;
775:
776: IF ( p_flow_schedule_pvt_rec.last_update_date = FND_API.G_MISS_DATE ) THEN
777: x_Flow_Schedule_Rec.last_update_date := NULL;
778: ELSE
779: x_Flow_Schedule_Rec.last_update_date := nvl(p_flow_schedule_pvt_rec.last_update_date,FND_API.G_MISS_DATE) ;
780: END IF;

Line 779: x_Flow_Schedule_Rec.last_update_date := nvl(p_flow_schedule_pvt_rec.last_update_date,FND_API.G_MISS_DATE) ;

775:
776: IF ( p_flow_schedule_pvt_rec.last_update_date = FND_API.G_MISS_DATE ) THEN
777: x_Flow_Schedule_Rec.last_update_date := NULL;
778: ELSE
779: x_Flow_Schedule_Rec.last_update_date := nvl(p_flow_schedule_pvt_rec.last_update_date,FND_API.G_MISS_DATE) ;
780: END IF;
781:
782: IF ( p_flow_schedule_pvt_rec.last_update_login = FND_API.G_MISS_NUM ) THEN
783: x_Flow_Schedule_Rec.last_update_login := NULL;

Line 782: IF ( p_flow_schedule_pvt_rec.last_update_login = FND_API.G_MISS_NUM ) THEN

778: ELSE
779: x_Flow_Schedule_Rec.last_update_date := nvl(p_flow_schedule_pvt_rec.last_update_date,FND_API.G_MISS_DATE) ;
780: END IF;
781:
782: IF ( p_flow_schedule_pvt_rec.last_update_login = FND_API.G_MISS_NUM ) THEN
783: x_Flow_Schedule_Rec.last_update_login := NULL;
784: ELSE
785: x_Flow_Schedule_Rec.last_update_login := nvl(p_flow_schedule_pvt_rec.last_update_login,FND_API.G_MISS_NUM) ;
786: END IF;

Line 785: x_Flow_Schedule_Rec.last_update_login := nvl(p_flow_schedule_pvt_rec.last_update_login,FND_API.G_MISS_NUM) ;

781:
782: IF ( p_flow_schedule_pvt_rec.last_update_login = FND_API.G_MISS_NUM ) THEN
783: x_Flow_Schedule_Rec.last_update_login := NULL;
784: ELSE
785: x_Flow_Schedule_Rec.last_update_login := nvl(p_flow_schedule_pvt_rec.last_update_login,FND_API.G_MISS_NUM) ;
786: END IF;
787:
788: IF ( p_flow_schedule_pvt_rec.line_id = FND_API.G_MISS_NUM ) THEN
789: x_Flow_Schedule_Rec.line_id := NULL;

Line 788: IF ( p_flow_schedule_pvt_rec.line_id = FND_API.G_MISS_NUM ) THEN

784: ELSE
785: x_Flow_Schedule_Rec.last_update_login := nvl(p_flow_schedule_pvt_rec.last_update_login,FND_API.G_MISS_NUM) ;
786: END IF;
787:
788: IF ( p_flow_schedule_pvt_rec.line_id = FND_API.G_MISS_NUM ) THEN
789: x_Flow_Schedule_Rec.line_id := NULL;
790: ELSE
791: x_Flow_Schedule_Rec.line_id := nvl(p_flow_schedule_pvt_rec.line_id ,FND_API.G_MISS_NUM) ;
792: END IF;

Line 791: x_Flow_Schedule_Rec.line_id := nvl(p_flow_schedule_pvt_rec.line_id ,FND_API.G_MISS_NUM) ;

787:
788: IF ( p_flow_schedule_pvt_rec.line_id = FND_API.G_MISS_NUM ) THEN
789: x_Flow_Schedule_Rec.line_id := NULL;
790: ELSE
791: x_Flow_Schedule_Rec.line_id := nvl(p_flow_schedule_pvt_rec.line_id ,FND_API.G_MISS_NUM) ;
792: END IF;
793:
794: IF ( p_flow_schedule_pvt_rec.material_account = FND_API.G_MISS_NUM ) THEN
795: x_Flow_Schedule_Rec.material_account := NULL;

Line 794: IF ( p_flow_schedule_pvt_rec.material_account = FND_API.G_MISS_NUM ) THEN

790: ELSE
791: x_Flow_Schedule_Rec.line_id := nvl(p_flow_schedule_pvt_rec.line_id ,FND_API.G_MISS_NUM) ;
792: END IF;
793:
794: IF ( p_flow_schedule_pvt_rec.material_account = FND_API.G_MISS_NUM ) THEN
795: x_Flow_Schedule_Rec.material_account := NULL;
796: ELSE
797: x_Flow_Schedule_Rec.material_account := nvl(p_flow_schedule_pvt_rec.material_account,FND_API.G_MISS_NUM ) ;
798: END IF;

Line 797: x_Flow_Schedule_Rec.material_account := nvl(p_flow_schedule_pvt_rec.material_account,FND_API.G_MISS_NUM ) ;

793:
794: IF ( p_flow_schedule_pvt_rec.material_account = FND_API.G_MISS_NUM ) THEN
795: x_Flow_Schedule_Rec.material_account := NULL;
796: ELSE
797: x_Flow_Schedule_Rec.material_account := nvl(p_flow_schedule_pvt_rec.material_account,FND_API.G_MISS_NUM ) ;
798: END IF;
799:
800: IF ( p_flow_schedule_pvt_rec.material_overhead_account = FND_API.G_MISS_NUM ) THEN
801: x_Flow_Schedule_Rec.material_overhead_account := NULL;

Line 800: IF ( p_flow_schedule_pvt_rec.material_overhead_account = FND_API.G_MISS_NUM ) THEN

796: ELSE
797: x_Flow_Schedule_Rec.material_account := nvl(p_flow_schedule_pvt_rec.material_account,FND_API.G_MISS_NUM ) ;
798: END IF;
799:
800: IF ( p_flow_schedule_pvt_rec.material_overhead_account = FND_API.G_MISS_NUM ) THEN
801: x_Flow_Schedule_Rec.material_overhead_account := NULL;
802: ELSE
803: x_Flow_Schedule_Rec.material_overhead_account := nvl(p_flow_schedule_pvt_rec.material_overhead_account,FND_API.G_MISS_NUM ) ;
804: END IF;

Line 803: x_Flow_Schedule_Rec.material_overhead_account := nvl(p_flow_schedule_pvt_rec.material_overhead_account,FND_API.G_MISS_NUM ) ;

799:
800: IF ( p_flow_schedule_pvt_rec.material_overhead_account = FND_API.G_MISS_NUM ) THEN
801: x_Flow_Schedule_Rec.material_overhead_account := NULL;
802: ELSE
803: x_Flow_Schedule_Rec.material_overhead_account := nvl(p_flow_schedule_pvt_rec.material_overhead_account,FND_API.G_MISS_NUM ) ;
804: END IF;
805:
806: IF ( p_flow_schedule_pvt_rec.material_variance_account = FND_API.G_MISS_NUM ) THEN
807: x_Flow_Schedule_Rec.material_variance_account := NULL;

Line 806: IF ( p_flow_schedule_pvt_rec.material_variance_account = FND_API.G_MISS_NUM ) THEN

802: ELSE
803: x_Flow_Schedule_Rec.material_overhead_account := nvl(p_flow_schedule_pvt_rec.material_overhead_account,FND_API.G_MISS_NUM ) ;
804: END IF;
805:
806: IF ( p_flow_schedule_pvt_rec.material_variance_account = FND_API.G_MISS_NUM ) THEN
807: x_Flow_Schedule_Rec.material_variance_account := NULL;
808: ELSE
809: x_Flow_Schedule_Rec.material_variance_account := nvl(p_flow_schedule_pvt_rec.material_variance_account ,FND_API.G_MISS_NUM ) ;
810: END IF;

Line 809: x_Flow_Schedule_Rec.material_variance_account := nvl(p_flow_schedule_pvt_rec.material_variance_account ,FND_API.G_MISS_NUM ) ;

805:
806: IF ( p_flow_schedule_pvt_rec.material_variance_account = FND_API.G_MISS_NUM ) THEN
807: x_Flow_Schedule_Rec.material_variance_account := NULL;
808: ELSE
809: x_Flow_Schedule_Rec.material_variance_account := nvl(p_flow_schedule_pvt_rec.material_variance_account ,FND_API.G_MISS_NUM ) ;
810: END IF;
811:
812: IF ( p_flow_schedule_pvt_rec.mps_net_quantity = FND_API.G_MISS_NUM ) THEN
813: x_Flow_Schedule_Rec.mps_net_quantity := NULL;

Line 812: IF ( p_flow_schedule_pvt_rec.mps_net_quantity = FND_API.G_MISS_NUM ) THEN

808: ELSE
809: x_Flow_Schedule_Rec.material_variance_account := nvl(p_flow_schedule_pvt_rec.material_variance_account ,FND_API.G_MISS_NUM ) ;
810: END IF;
811:
812: IF ( p_flow_schedule_pvt_rec.mps_net_quantity = FND_API.G_MISS_NUM ) THEN
813: x_Flow_Schedule_Rec.mps_net_quantity := NULL;
814: ELSE
815: x_Flow_Schedule_Rec.mps_net_quantity := nvl(p_flow_schedule_pvt_rec.mps_net_quantity,FND_API.G_MISS_NUM ) ;
816: END IF;

Line 815: x_Flow_Schedule_Rec.mps_net_quantity := nvl(p_flow_schedule_pvt_rec.mps_net_quantity,FND_API.G_MISS_NUM ) ;

811:
812: IF ( p_flow_schedule_pvt_rec.mps_net_quantity = FND_API.G_MISS_NUM ) THEN
813: x_Flow_Schedule_Rec.mps_net_quantity := NULL;
814: ELSE
815: x_Flow_Schedule_Rec.mps_net_quantity := nvl(p_flow_schedule_pvt_rec.mps_net_quantity,FND_API.G_MISS_NUM ) ;
816: END IF;
817:
818: IF ( p_flow_schedule_pvt_rec.mps_scheduled_comp_date = FND_API.G_MISS_DATE) THEN
819: x_Flow_Schedule_Rec.mps_scheduled_comp_date := NULL;

Line 818: IF ( p_flow_schedule_pvt_rec.mps_scheduled_comp_date = FND_API.G_MISS_DATE) THEN

814: ELSE
815: x_Flow_Schedule_Rec.mps_net_quantity := nvl(p_flow_schedule_pvt_rec.mps_net_quantity,FND_API.G_MISS_NUM ) ;
816: END IF;
817:
818: IF ( p_flow_schedule_pvt_rec.mps_scheduled_comp_date = FND_API.G_MISS_DATE) THEN
819: x_Flow_Schedule_Rec.mps_scheduled_comp_date := NULL;
820: ELSE
821: x_Flow_Schedule_Rec.mps_scheduled_comp_date := nvl(p_flow_schedule_pvt_rec.mps_scheduled_comp_date,FND_API.G_MISS_DATE) ;
822: END IF;

Line 821: x_Flow_Schedule_Rec.mps_scheduled_comp_date := nvl(p_flow_schedule_pvt_rec.mps_scheduled_comp_date,FND_API.G_MISS_DATE) ;

817:
818: IF ( p_flow_schedule_pvt_rec.mps_scheduled_comp_date = FND_API.G_MISS_DATE) THEN
819: x_Flow_Schedule_Rec.mps_scheduled_comp_date := NULL;
820: ELSE
821: x_Flow_Schedule_Rec.mps_scheduled_comp_date := nvl(p_flow_schedule_pvt_rec.mps_scheduled_comp_date,FND_API.G_MISS_DATE) ;
822: END IF;
823:
824: IF ( p_flow_schedule_pvt_rec.organization_id = FND_API.G_MISS_NUM ) THEN
825: x_Flow_Schedule_Rec.organization_id := NULL;

Line 824: IF ( p_flow_schedule_pvt_rec.organization_id = FND_API.G_MISS_NUM ) THEN

820: ELSE
821: x_Flow_Schedule_Rec.mps_scheduled_comp_date := nvl(p_flow_schedule_pvt_rec.mps_scheduled_comp_date,FND_API.G_MISS_DATE) ;
822: END IF;
823:
824: IF ( p_flow_schedule_pvt_rec.organization_id = FND_API.G_MISS_NUM ) THEN
825: x_Flow_Schedule_Rec.organization_id := NULL;
826: ELSE
827: x_Flow_Schedule_Rec.organization_id := nvl(p_flow_schedule_pvt_rec.organization_id,FND_API.G_MISS_NUM) ;
828: END IF;

Line 827: x_Flow_Schedule_Rec.organization_id := nvl(p_flow_schedule_pvt_rec.organization_id,FND_API.G_MISS_NUM) ;

823:
824: IF ( p_flow_schedule_pvt_rec.organization_id = FND_API.G_MISS_NUM ) THEN
825: x_Flow_Schedule_Rec.organization_id := NULL;
826: ELSE
827: x_Flow_Schedule_Rec.organization_id := nvl(p_flow_schedule_pvt_rec.organization_id,FND_API.G_MISS_NUM) ;
828: END IF;
829:
830: IF ( p_flow_schedule_pvt_rec.outside_processing_acct = FND_API.G_MISS_NUM) THEN
831: x_Flow_Schedule_Rec.outside_processing_acct := NULL;

Line 830: IF ( p_flow_schedule_pvt_rec.outside_processing_acct = FND_API.G_MISS_NUM) THEN

826: ELSE
827: x_Flow_Schedule_Rec.organization_id := nvl(p_flow_schedule_pvt_rec.organization_id,FND_API.G_MISS_NUM) ;
828: END IF;
829:
830: IF ( p_flow_schedule_pvt_rec.outside_processing_acct = FND_API.G_MISS_NUM) THEN
831: x_Flow_Schedule_Rec.outside_processing_acct := NULL;
832: ELSE
833: x_Flow_Schedule_Rec.outside_processing_acct := nvl(p_flow_schedule_pvt_rec.outside_processing_acct,FND_API.G_MISS_NUM) ;
834: END IF;

Line 833: x_Flow_Schedule_Rec.outside_processing_acct := nvl(p_flow_schedule_pvt_rec.outside_processing_acct,FND_API.G_MISS_NUM) ;

829:
830: IF ( p_flow_schedule_pvt_rec.outside_processing_acct = FND_API.G_MISS_NUM) THEN
831: x_Flow_Schedule_Rec.outside_processing_acct := NULL;
832: ELSE
833: x_Flow_Schedule_Rec.outside_processing_acct := nvl(p_flow_schedule_pvt_rec.outside_processing_acct,FND_API.G_MISS_NUM) ;
834: END IF;
835:
836: IF ( p_flow_schedule_pvt_rec.outside_proc_var_acct = FND_API.G_MISS_NUM ) THEN
837: x_Flow_Schedule_Rec.outside_proc_var_acct := NULL;

Line 836: IF ( p_flow_schedule_pvt_rec.outside_proc_var_acct = FND_API.G_MISS_NUM ) THEN

832: ELSE
833: x_Flow_Schedule_Rec.outside_processing_acct := nvl(p_flow_schedule_pvt_rec.outside_processing_acct,FND_API.G_MISS_NUM) ;
834: END IF;
835:
836: IF ( p_flow_schedule_pvt_rec.outside_proc_var_acct = FND_API.G_MISS_NUM ) THEN
837: x_Flow_Schedule_Rec.outside_proc_var_acct := NULL;
838: ELSE
839: x_Flow_Schedule_Rec.outside_proc_var_acct := nvl(p_flow_schedule_pvt_rec.outside_proc_var_acct,FND_API.G_MISS_NUM) ;
840: END IF;

Line 839: x_Flow_Schedule_Rec.outside_proc_var_acct := nvl(p_flow_schedule_pvt_rec.outside_proc_var_acct,FND_API.G_MISS_NUM) ;

835:
836: IF ( p_flow_schedule_pvt_rec.outside_proc_var_acct = FND_API.G_MISS_NUM ) THEN
837: x_Flow_Schedule_Rec.outside_proc_var_acct := NULL;
838: ELSE
839: x_Flow_Schedule_Rec.outside_proc_var_acct := nvl(p_flow_schedule_pvt_rec.outside_proc_var_acct,FND_API.G_MISS_NUM) ;
840: END IF;
841:
842: IF ( p_flow_schedule_pvt_rec.overhead_account = FND_API.G_MISS_NUM ) THEN
843: x_Flow_Schedule_Rec.overhead_account := NULL;

Line 842: IF ( p_flow_schedule_pvt_rec.overhead_account = FND_API.G_MISS_NUM ) THEN

838: ELSE
839: x_Flow_Schedule_Rec.outside_proc_var_acct := nvl(p_flow_schedule_pvt_rec.outside_proc_var_acct,FND_API.G_MISS_NUM) ;
840: END IF;
841:
842: IF ( p_flow_schedule_pvt_rec.overhead_account = FND_API.G_MISS_NUM ) THEN
843: x_Flow_Schedule_Rec.overhead_account := NULL;
844: ELSE
845: x_Flow_Schedule_Rec.overhead_account := nvl(p_flow_schedule_pvt_rec.overhead_account,FND_API.G_MISS_NUM ) ;
846: END IF;

Line 845: x_Flow_Schedule_Rec.overhead_account := nvl(p_flow_schedule_pvt_rec.overhead_account,FND_API.G_MISS_NUM ) ;

841:
842: IF ( p_flow_schedule_pvt_rec.overhead_account = FND_API.G_MISS_NUM ) THEN
843: x_Flow_Schedule_Rec.overhead_account := NULL;
844: ELSE
845: x_Flow_Schedule_Rec.overhead_account := nvl(p_flow_schedule_pvt_rec.overhead_account,FND_API.G_MISS_NUM ) ;
846: END IF;
847:
848: IF ( p_flow_schedule_pvt_rec.overhead_variance_account= FND_API.G_MISS_NUM ) THEN
849: x_Flow_Schedule_Rec.overhead_variance_account:= NULL;

Line 848: IF ( p_flow_schedule_pvt_rec.overhead_variance_account= FND_API.G_MISS_NUM ) THEN

844: ELSE
845: x_Flow_Schedule_Rec.overhead_account := nvl(p_flow_schedule_pvt_rec.overhead_account,FND_API.G_MISS_NUM ) ;
846: END IF;
847:
848: IF ( p_flow_schedule_pvt_rec.overhead_variance_account= FND_API.G_MISS_NUM ) THEN
849: x_Flow_Schedule_Rec.overhead_variance_account:= NULL;
850: ELSE
851: x_Flow_Schedule_Rec.overhead_variance_account:= nvl(p_flow_schedule_pvt_rec.overhead_variance_account,FND_API.G_MISS_NUM );
852: END IF;

Line 851: x_Flow_Schedule_Rec.overhead_variance_account:= nvl(p_flow_schedule_pvt_rec.overhead_variance_account,FND_API.G_MISS_NUM );

847:
848: IF ( p_flow_schedule_pvt_rec.overhead_variance_account= FND_API.G_MISS_NUM ) THEN
849: x_Flow_Schedule_Rec.overhead_variance_account:= NULL;
850: ELSE
851: x_Flow_Schedule_Rec.overhead_variance_account:= nvl(p_flow_schedule_pvt_rec.overhead_variance_account,FND_API.G_MISS_NUM );
852: END IF;
853:
854: IF ( p_flow_schedule_pvt_rec.planned_quantity = FND_API.G_MISS_NUM ) THEN
855: x_Flow_Schedule_Rec.planned_quantity := NULL;

Line 854: IF ( p_flow_schedule_pvt_rec.planned_quantity = FND_API.G_MISS_NUM ) THEN

850: ELSE
851: x_Flow_Schedule_Rec.overhead_variance_account:= nvl(p_flow_schedule_pvt_rec.overhead_variance_account,FND_API.G_MISS_NUM );
852: END IF;
853:
854: IF ( p_flow_schedule_pvt_rec.planned_quantity = FND_API.G_MISS_NUM ) THEN
855: x_Flow_Schedule_Rec.planned_quantity := NULL;
856: ELSE
857: x_Flow_Schedule_Rec.planned_quantity := nvl(p_flow_schedule_pvt_rec.planned_quantity,FND_API.G_MISS_NUM ) ;
858: END IF;

Line 857: x_Flow_Schedule_Rec.planned_quantity := nvl(p_flow_schedule_pvt_rec.planned_quantity,FND_API.G_MISS_NUM ) ;

853:
854: IF ( p_flow_schedule_pvt_rec.planned_quantity = FND_API.G_MISS_NUM ) THEN
855: x_Flow_Schedule_Rec.planned_quantity := NULL;
856: ELSE
857: x_Flow_Schedule_Rec.planned_quantity := nvl(p_flow_schedule_pvt_rec.planned_quantity,FND_API.G_MISS_NUM ) ;
858: END IF;
859:
860: IF ( p_flow_schedule_pvt_rec.primary_item_id = FND_API.G_MISS_NUM ) THEN
861: x_Flow_Schedule_Rec.primary_item_id := NULL;

Line 860: IF ( p_flow_schedule_pvt_rec.primary_item_id = FND_API.G_MISS_NUM ) THEN

856: ELSE
857: x_Flow_Schedule_Rec.planned_quantity := nvl(p_flow_schedule_pvt_rec.planned_quantity,FND_API.G_MISS_NUM ) ;
858: END IF;
859:
860: IF ( p_flow_schedule_pvt_rec.primary_item_id = FND_API.G_MISS_NUM ) THEN
861: x_Flow_Schedule_Rec.primary_item_id := NULL;
862: ELSE
863: x_Flow_Schedule_Rec.primary_item_id := nvl(p_flow_schedule_pvt_rec.primary_item_id,FND_API.G_MISS_NUM ) ;
864: END IF;

Line 863: x_Flow_Schedule_Rec.primary_item_id := nvl(p_flow_schedule_pvt_rec.primary_item_id,FND_API.G_MISS_NUM ) ;

859:
860: IF ( p_flow_schedule_pvt_rec.primary_item_id = FND_API.G_MISS_NUM ) THEN
861: x_Flow_Schedule_Rec.primary_item_id := NULL;
862: ELSE
863: x_Flow_Schedule_Rec.primary_item_id := nvl(p_flow_schedule_pvt_rec.primary_item_id,FND_API.G_MISS_NUM ) ;
864: END IF;
865:
866: IF ( p_flow_schedule_pvt_rec.program_application_id= FND_API.G_MISS_NUM ) THEN
867: x_Flow_Schedule_Rec.program_application_id:= NULL;

Line 866: IF ( p_flow_schedule_pvt_rec.program_application_id= FND_API.G_MISS_NUM ) THEN

862: ELSE
863: x_Flow_Schedule_Rec.primary_item_id := nvl(p_flow_schedule_pvt_rec.primary_item_id,FND_API.G_MISS_NUM ) ;
864: END IF;
865:
866: IF ( p_flow_schedule_pvt_rec.program_application_id= FND_API.G_MISS_NUM ) THEN
867: x_Flow_Schedule_Rec.program_application_id:= NULL;
868: ELSE
869: x_Flow_Schedule_Rec.program_application_id:= nvl(p_flow_schedule_pvt_rec.program_application_id,FND_API.G_MISS_NUM );
870: END IF;

Line 869: x_Flow_Schedule_Rec.program_application_id:= nvl(p_flow_schedule_pvt_rec.program_application_id,FND_API.G_MISS_NUM );

865:
866: IF ( p_flow_schedule_pvt_rec.program_application_id= FND_API.G_MISS_NUM ) THEN
867: x_Flow_Schedule_Rec.program_application_id:= NULL;
868: ELSE
869: x_Flow_Schedule_Rec.program_application_id:= nvl(p_flow_schedule_pvt_rec.program_application_id,FND_API.G_MISS_NUM );
870: END IF;
871:
872: IF ( p_flow_schedule_pvt_rec.program_id = FND_API.G_MISS_NUM ) THEN
873: x_Flow_Schedule_Rec.program_id := NULL;

Line 872: IF ( p_flow_schedule_pvt_rec.program_id = FND_API.G_MISS_NUM ) THEN

868: ELSE
869: x_Flow_Schedule_Rec.program_application_id:= nvl(p_flow_schedule_pvt_rec.program_application_id,FND_API.G_MISS_NUM );
870: END IF;
871:
872: IF ( p_flow_schedule_pvt_rec.program_id = FND_API.G_MISS_NUM ) THEN
873: x_Flow_Schedule_Rec.program_id := NULL;
874: ELSE
875: x_Flow_Schedule_Rec.program_id := nvl(p_flow_schedule_pvt_rec.program_id ,FND_API.G_MISS_NUM ) ;
876: END IF;

Line 875: x_Flow_Schedule_Rec.program_id := nvl(p_flow_schedule_pvt_rec.program_id ,FND_API.G_MISS_NUM ) ;

871:
872: IF ( p_flow_schedule_pvt_rec.program_id = FND_API.G_MISS_NUM ) THEN
873: x_Flow_Schedule_Rec.program_id := NULL;
874: ELSE
875: x_Flow_Schedule_Rec.program_id := nvl(p_flow_schedule_pvt_rec.program_id ,FND_API.G_MISS_NUM ) ;
876: END IF;
877:
878: IF ( p_flow_schedule_pvt_rec.program_update_date = FND_API.G_MISS_DATE ) THEN
879: x_Flow_Schedule_Rec.program_update_date := NULL;

Line 878: IF ( p_flow_schedule_pvt_rec.program_update_date = FND_API.G_MISS_DATE ) THEN

874: ELSE
875: x_Flow_Schedule_Rec.program_id := nvl(p_flow_schedule_pvt_rec.program_id ,FND_API.G_MISS_NUM ) ;
876: END IF;
877:
878: IF ( p_flow_schedule_pvt_rec.program_update_date = FND_API.G_MISS_DATE ) THEN
879: x_Flow_Schedule_Rec.program_update_date := NULL;
880: ELSE
881: x_Flow_Schedule_Rec.program_update_date := nvl(p_flow_schedule_pvt_rec.program_update_date,FND_API.G_MISS_DATE) ;
882: END IF;

Line 881: x_Flow_Schedule_Rec.program_update_date := nvl(p_flow_schedule_pvt_rec.program_update_date,FND_API.G_MISS_DATE) ;

877:
878: IF ( p_flow_schedule_pvt_rec.program_update_date = FND_API.G_MISS_DATE ) THEN
879: x_Flow_Schedule_Rec.program_update_date := NULL;
880: ELSE
881: x_Flow_Schedule_Rec.program_update_date := nvl(p_flow_schedule_pvt_rec.program_update_date,FND_API.G_MISS_DATE) ;
882: END IF;
883:
884: IF ( p_flow_schedule_pvt_rec.project_id = FND_API.G_MISS_NUM ) THEN
885: x_Flow_Schedule_Rec.project_id := NULL;

Line 884: IF ( p_flow_schedule_pvt_rec.project_id = FND_API.G_MISS_NUM ) THEN

880: ELSE
881: x_Flow_Schedule_Rec.program_update_date := nvl(p_flow_schedule_pvt_rec.program_update_date,FND_API.G_MISS_DATE) ;
882: END IF;
883:
884: IF ( p_flow_schedule_pvt_rec.project_id = FND_API.G_MISS_NUM ) THEN
885: x_Flow_Schedule_Rec.project_id := NULL;
886: ELSE
887: x_Flow_Schedule_Rec.project_id := nvl(p_flow_schedule_pvt_rec.project_id,FND_API.G_MISS_NUM) ;
888: END IF;

Line 887: x_Flow_Schedule_Rec.project_id := nvl(p_flow_schedule_pvt_rec.project_id,FND_API.G_MISS_NUM) ;

883:
884: IF ( p_flow_schedule_pvt_rec.project_id = FND_API.G_MISS_NUM ) THEN
885: x_Flow_Schedule_Rec.project_id := NULL;
886: ELSE
887: x_Flow_Schedule_Rec.project_id := nvl(p_flow_schedule_pvt_rec.project_id,FND_API.G_MISS_NUM) ;
888: END IF;
889:
890: IF ( p_flow_schedule_pvt_rec.quantity_completed = FND_API.G_MISS_NUM) THEN
891: x_Flow_Schedule_Rec.quantity_completed := NULL;

Line 890: IF ( p_flow_schedule_pvt_rec.quantity_completed = FND_API.G_MISS_NUM) THEN

886: ELSE
887: x_Flow_Schedule_Rec.project_id := nvl(p_flow_schedule_pvt_rec.project_id,FND_API.G_MISS_NUM) ;
888: END IF;
889:
890: IF ( p_flow_schedule_pvt_rec.quantity_completed = FND_API.G_MISS_NUM) THEN
891: x_Flow_Schedule_Rec.quantity_completed := NULL;
892: ELSE
893: x_Flow_Schedule_Rec.quantity_completed := nvl(p_flow_schedule_pvt_rec.quantity_completed ,FND_API.G_MISS_NUM) ;
894: END IF;

Line 893: x_Flow_Schedule_Rec.quantity_completed := nvl(p_flow_schedule_pvt_rec.quantity_completed ,FND_API.G_MISS_NUM) ;

889:
890: IF ( p_flow_schedule_pvt_rec.quantity_completed = FND_API.G_MISS_NUM) THEN
891: x_Flow_Schedule_Rec.quantity_completed := NULL;
892: ELSE
893: x_Flow_Schedule_Rec.quantity_completed := nvl(p_flow_schedule_pvt_rec.quantity_completed ,FND_API.G_MISS_NUM) ;
894: END IF;
895:
896: IF ( p_flow_schedule_pvt_rec.request_id = FND_API.G_MISS_NUM) THEN
897: x_Flow_Schedule_Rec.request_id := NULL;

Line 896: IF ( p_flow_schedule_pvt_rec.request_id = FND_API.G_MISS_NUM) THEN

892: ELSE
893: x_Flow_Schedule_Rec.quantity_completed := nvl(p_flow_schedule_pvt_rec.quantity_completed ,FND_API.G_MISS_NUM) ;
894: END IF;
895:
896: IF ( p_flow_schedule_pvt_rec.request_id = FND_API.G_MISS_NUM) THEN
897: x_Flow_Schedule_Rec.request_id := NULL;
898: ELSE
899: x_Flow_Schedule_Rec.request_id := nvl(p_flow_schedule_pvt_rec.request_id ,FND_API.G_MISS_NUM) ;
900: END IF;

Line 899: x_Flow_Schedule_Rec.request_id := nvl(p_flow_schedule_pvt_rec.request_id ,FND_API.G_MISS_NUM) ;

895:
896: IF ( p_flow_schedule_pvt_rec.request_id = FND_API.G_MISS_NUM) THEN
897: x_Flow_Schedule_Rec.request_id := NULL;
898: ELSE
899: x_Flow_Schedule_Rec.request_id := nvl(p_flow_schedule_pvt_rec.request_id ,FND_API.G_MISS_NUM) ;
900: END IF;
901:
902: IF ( p_flow_schedule_pvt_rec.resource_account = FND_API.G_MISS_NUM) THEN
903: x_Flow_Schedule_Rec.resource_account := NULL;

Line 902: IF ( p_flow_schedule_pvt_rec.resource_account = FND_API.G_MISS_NUM) THEN

898: ELSE
899: x_Flow_Schedule_Rec.request_id := nvl(p_flow_schedule_pvt_rec.request_id ,FND_API.G_MISS_NUM) ;
900: END IF;
901:
902: IF ( p_flow_schedule_pvt_rec.resource_account = FND_API.G_MISS_NUM) THEN
903: x_Flow_Schedule_Rec.resource_account := NULL;
904: ELSE
905: x_Flow_Schedule_Rec.resource_account := nvl(p_flow_schedule_pvt_rec.resource_account ,FND_API.G_MISS_NUM) ;
906: END IF;

Line 905: x_Flow_Schedule_Rec.resource_account := nvl(p_flow_schedule_pvt_rec.resource_account ,FND_API.G_MISS_NUM) ;

901:
902: IF ( p_flow_schedule_pvt_rec.resource_account = FND_API.G_MISS_NUM) THEN
903: x_Flow_Schedule_Rec.resource_account := NULL;
904: ELSE
905: x_Flow_Schedule_Rec.resource_account := nvl(p_flow_schedule_pvt_rec.resource_account ,FND_API.G_MISS_NUM) ;
906: END IF;
907:
908: IF ( p_flow_schedule_pvt_rec.resource_variance_account = FND_API.G_MISS_NUM) THEN
909: x_Flow_Schedule_Rec.resource_variance_account := NULL;

Line 908: IF ( p_flow_schedule_pvt_rec.resource_variance_account = FND_API.G_MISS_NUM) THEN

904: ELSE
905: x_Flow_Schedule_Rec.resource_account := nvl(p_flow_schedule_pvt_rec.resource_account ,FND_API.G_MISS_NUM) ;
906: END IF;
907:
908: IF ( p_flow_schedule_pvt_rec.resource_variance_account = FND_API.G_MISS_NUM) THEN
909: x_Flow_Schedule_Rec.resource_variance_account := NULL;
910: ELSE
911: x_Flow_Schedule_Rec.resource_variance_account := nvl(p_flow_schedule_pvt_rec.resource_variance_account,FND_API.G_MISS_NUM) ;
912: END IF;

Line 911: x_Flow_Schedule_Rec.resource_variance_account := nvl(p_flow_schedule_pvt_rec.resource_variance_account,FND_API.G_MISS_NUM) ;

907:
908: IF ( p_flow_schedule_pvt_rec.resource_variance_account = FND_API.G_MISS_NUM) THEN
909: x_Flow_Schedule_Rec.resource_variance_account := NULL;
910: ELSE
911: x_Flow_Schedule_Rec.resource_variance_account := nvl(p_flow_schedule_pvt_rec.resource_variance_account,FND_API.G_MISS_NUM) ;
912: END IF;
913:
914: IF ( p_flow_schedule_pvt_rec.routing_revision = FND_API.G_MISS_CHAR ) THEN
915: x_Flow_Schedule_Rec.routing_revision := NULL;

Line 914: IF ( p_flow_schedule_pvt_rec.routing_revision = FND_API.G_MISS_CHAR ) THEN

910: ELSE
911: x_Flow_Schedule_Rec.resource_variance_account := nvl(p_flow_schedule_pvt_rec.resource_variance_account,FND_API.G_MISS_NUM) ;
912: END IF;
913:
914: IF ( p_flow_schedule_pvt_rec.routing_revision = FND_API.G_MISS_CHAR ) THEN
915: x_Flow_Schedule_Rec.routing_revision := NULL;
916: ELSE
917: x_Flow_Schedule_Rec.routing_revision := nvl(p_flow_schedule_pvt_rec.routing_revision ,FND_API.G_MISS_CHAR ) ;
918: END IF;

Line 917: x_Flow_Schedule_Rec.routing_revision := nvl(p_flow_schedule_pvt_rec.routing_revision ,FND_API.G_MISS_CHAR ) ;

913:
914: IF ( p_flow_schedule_pvt_rec.routing_revision = FND_API.G_MISS_CHAR ) THEN
915: x_Flow_Schedule_Rec.routing_revision := NULL;
916: ELSE
917: x_Flow_Schedule_Rec.routing_revision := nvl(p_flow_schedule_pvt_rec.routing_revision ,FND_API.G_MISS_CHAR ) ;
918: END IF;
919:
920: IF ( p_flow_schedule_pvt_rec.routing_revision_date= FND_API.G_MISS_DATE ) THEN
921: x_Flow_Schedule_Rec.routing_revision_date := NULL;

Line 920: IF ( p_flow_schedule_pvt_rec.routing_revision_date= FND_API.G_MISS_DATE ) THEN

916: ELSE
917: x_Flow_Schedule_Rec.routing_revision := nvl(p_flow_schedule_pvt_rec.routing_revision ,FND_API.G_MISS_CHAR ) ;
918: END IF;
919:
920: IF ( p_flow_schedule_pvt_rec.routing_revision_date= FND_API.G_MISS_DATE ) THEN
921: x_Flow_Schedule_Rec.routing_revision_date := NULL;
922: ELSE
923: x_Flow_Schedule_Rec.routing_revision_date := nvl(p_flow_schedule_pvt_rec.routing_revision_date ,FND_API.G_MISS_DATE);
924: END IF;

Line 923: x_Flow_Schedule_Rec.routing_revision_date := nvl(p_flow_schedule_pvt_rec.routing_revision_date ,FND_API.G_MISS_DATE);

919:
920: IF ( p_flow_schedule_pvt_rec.routing_revision_date= FND_API.G_MISS_DATE ) THEN
921: x_Flow_Schedule_Rec.routing_revision_date := NULL;
922: ELSE
923: x_Flow_Schedule_Rec.routing_revision_date := nvl(p_flow_schedule_pvt_rec.routing_revision_date ,FND_API.G_MISS_DATE);
924: END IF;
925:
926: IF ( p_flow_schedule_pvt_rec.scheduled_completion_date = FND_API.G_MISS_DATE ) THEN
927: x_Flow_Schedule_Rec.scheduled_completion_date:= NULL;

Line 926: IF ( p_flow_schedule_pvt_rec.scheduled_completion_date = FND_API.G_MISS_DATE ) THEN

922: ELSE
923: x_Flow_Schedule_Rec.routing_revision_date := nvl(p_flow_schedule_pvt_rec.routing_revision_date ,FND_API.G_MISS_DATE);
924: END IF;
925:
926: IF ( p_flow_schedule_pvt_rec.scheduled_completion_date = FND_API.G_MISS_DATE ) THEN
927: x_Flow_Schedule_Rec.scheduled_completion_date:= NULL;
928: ELSE
929: x_Flow_Schedule_Rec.scheduled_completion_date:= nvl(p_flow_schedule_pvt_rec.scheduled_completion_date,FND_API.G_MISS_DATE);
930: END IF;

Line 929: x_Flow_Schedule_Rec.scheduled_completion_date:= nvl(p_flow_schedule_pvt_rec.scheduled_completion_date,FND_API.G_MISS_DATE);

925:
926: IF ( p_flow_schedule_pvt_rec.scheduled_completion_date = FND_API.G_MISS_DATE ) THEN
927: x_Flow_Schedule_Rec.scheduled_completion_date:= NULL;
928: ELSE
929: x_Flow_Schedule_Rec.scheduled_completion_date:= nvl(p_flow_schedule_pvt_rec.scheduled_completion_date,FND_API.G_MISS_DATE);
930: END IF;
931:
932: IF ( p_flow_schedule_pvt_rec.scheduled_flag = FND_API.G_MISS_NUM ) THEN
933: x_Flow_Schedule_Rec.scheduled_flag := NULL;

Line 932: IF ( p_flow_schedule_pvt_rec.scheduled_flag = FND_API.G_MISS_NUM ) THEN

928: ELSE
929: x_Flow_Schedule_Rec.scheduled_completion_date:= nvl(p_flow_schedule_pvt_rec.scheduled_completion_date,FND_API.G_MISS_DATE);
930: END IF;
931:
932: IF ( p_flow_schedule_pvt_rec.scheduled_flag = FND_API.G_MISS_NUM ) THEN
933: x_Flow_Schedule_Rec.scheduled_flag := NULL;
934: ELSE
935: x_Flow_Schedule_Rec.scheduled_flag := nvl(p_flow_schedule_pvt_rec.scheduled_flag,FND_API.G_MISS_NUM );
936: END IF;

Line 935: x_Flow_Schedule_Rec.scheduled_flag := nvl(p_flow_schedule_pvt_rec.scheduled_flag,FND_API.G_MISS_NUM );

931:
932: IF ( p_flow_schedule_pvt_rec.scheduled_flag = FND_API.G_MISS_NUM ) THEN
933: x_Flow_Schedule_Rec.scheduled_flag := NULL;
934: ELSE
935: x_Flow_Schedule_Rec.scheduled_flag := nvl(p_flow_schedule_pvt_rec.scheduled_flag,FND_API.G_MISS_NUM );
936: END IF;
937:
938: IF ( p_flow_schedule_pvt_rec.scheduled_start_date = FND_API.G_MISS_DATE ) THEN
939: x_Flow_Schedule_Rec.scheduled_start_date := NULL;

Line 938: IF ( p_flow_schedule_pvt_rec.scheduled_start_date = FND_API.G_MISS_DATE ) THEN

934: ELSE
935: x_Flow_Schedule_Rec.scheduled_flag := nvl(p_flow_schedule_pvt_rec.scheduled_flag,FND_API.G_MISS_NUM );
936: END IF;
937:
938: IF ( p_flow_schedule_pvt_rec.scheduled_start_date = FND_API.G_MISS_DATE ) THEN
939: x_Flow_Schedule_Rec.scheduled_start_date := NULL;
940: ELSE
941: x_Flow_Schedule_Rec.scheduled_start_date := nvl(p_flow_schedule_pvt_rec.scheduled_start_date,FND_API.G_MISS_DATE) ;
942: END IF;

Line 941: x_Flow_Schedule_Rec.scheduled_start_date := nvl(p_flow_schedule_pvt_rec.scheduled_start_date,FND_API.G_MISS_DATE) ;

937:
938: IF ( p_flow_schedule_pvt_rec.scheduled_start_date = FND_API.G_MISS_DATE ) THEN
939: x_Flow_Schedule_Rec.scheduled_start_date := NULL;
940: ELSE
941: x_Flow_Schedule_Rec.scheduled_start_date := nvl(p_flow_schedule_pvt_rec.scheduled_start_date,FND_API.G_MISS_DATE) ;
942: END IF;
943:
944: IF ( p_flow_schedule_pvt_rec.schedule_group_id = FND_API.G_MISS_NUM ) THEN
945: x_Flow_Schedule_Rec.schedule_group_id := NULL;

Line 944: IF ( p_flow_schedule_pvt_rec.schedule_group_id = FND_API.G_MISS_NUM ) THEN

940: ELSE
941: x_Flow_Schedule_Rec.scheduled_start_date := nvl(p_flow_schedule_pvt_rec.scheduled_start_date,FND_API.G_MISS_DATE) ;
942: END IF;
943:
944: IF ( p_flow_schedule_pvt_rec.schedule_group_id = FND_API.G_MISS_NUM ) THEN
945: x_Flow_Schedule_Rec.schedule_group_id := NULL;
946: ELSE
947: x_Flow_Schedule_Rec.schedule_group_id := nvl(p_flow_schedule_pvt_rec.schedule_group_id ,FND_API.G_MISS_NUM) ;
948: END IF;

Line 947: x_Flow_Schedule_Rec.schedule_group_id := nvl(p_flow_schedule_pvt_rec.schedule_group_id ,FND_API.G_MISS_NUM) ;

943:
944: IF ( p_flow_schedule_pvt_rec.schedule_group_id = FND_API.G_MISS_NUM ) THEN
945: x_Flow_Schedule_Rec.schedule_group_id := NULL;
946: ELSE
947: x_Flow_Schedule_Rec.schedule_group_id := nvl(p_flow_schedule_pvt_rec.schedule_group_id ,FND_API.G_MISS_NUM) ;
948: END IF;
949:
950: IF ( p_flow_schedule_pvt_rec.schedule_number = FND_API.G_MISS_CHAR ) THEN
951: x_Flow_Schedule_Rec.schedule_number := NULL;

Line 950: IF ( p_flow_schedule_pvt_rec.schedule_number = FND_API.G_MISS_CHAR ) THEN

946: ELSE
947: x_Flow_Schedule_Rec.schedule_group_id := nvl(p_flow_schedule_pvt_rec.schedule_group_id ,FND_API.G_MISS_NUM) ;
948: END IF;
949:
950: IF ( p_flow_schedule_pvt_rec.schedule_number = FND_API.G_MISS_CHAR ) THEN
951: x_Flow_Schedule_Rec.schedule_number := NULL;
952: ELSE
953: x_Flow_Schedule_Rec.schedule_number := nvl(p_flow_schedule_pvt_rec.schedule_number ,FND_API.G_MISS_CHAR );
954: END IF;

Line 953: x_Flow_Schedule_Rec.schedule_number := nvl(p_flow_schedule_pvt_rec.schedule_number ,FND_API.G_MISS_CHAR );

949:
950: IF ( p_flow_schedule_pvt_rec.schedule_number = FND_API.G_MISS_CHAR ) THEN
951: x_Flow_Schedule_Rec.schedule_number := NULL;
952: ELSE
953: x_Flow_Schedule_Rec.schedule_number := nvl(p_flow_schedule_pvt_rec.schedule_number ,FND_API.G_MISS_CHAR );
954: END IF;
955:
956:
957: IF ( p_flow_schedule_pvt_rec.status = FND_API.G_MISS_NUM ) THEN

Line 957: IF ( p_flow_schedule_pvt_rec.status = FND_API.G_MISS_NUM ) THEN

953: x_Flow_Schedule_Rec.schedule_number := nvl(p_flow_schedule_pvt_rec.schedule_number ,FND_API.G_MISS_CHAR );
954: END IF;
955:
956:
957: IF ( p_flow_schedule_pvt_rec.status = FND_API.G_MISS_NUM ) THEN
958: x_Flow_Schedule_Rec.status := NULL;
959: ELSE
960: x_Flow_Schedule_Rec.status := nvl(p_flow_schedule_pvt_rec.status ,FND_API.G_MISS_NUM) ;
961: END IF;

Line 960: x_Flow_Schedule_Rec.status := nvl(p_flow_schedule_pvt_rec.status ,FND_API.G_MISS_NUM) ;

956:
957: IF ( p_flow_schedule_pvt_rec.status = FND_API.G_MISS_NUM ) THEN
958: x_Flow_Schedule_Rec.status := NULL;
959: ELSE
960: x_Flow_Schedule_Rec.status := nvl(p_flow_schedule_pvt_rec.status ,FND_API.G_MISS_NUM) ;
961: END IF;
962:
963: IF ( p_flow_schedule_pvt_rec.std_cost_adjustment_acct = FND_API.G_MISS_NUM) THEN
964: x_Flow_Schedule_Rec.std_cost_adjustment_acct := NULL;

Line 963: IF ( p_flow_schedule_pvt_rec.std_cost_adjustment_acct = FND_API.G_MISS_NUM) THEN

959: ELSE
960: x_Flow_Schedule_Rec.status := nvl(p_flow_schedule_pvt_rec.status ,FND_API.G_MISS_NUM) ;
961: END IF;
962:
963: IF ( p_flow_schedule_pvt_rec.std_cost_adjustment_acct = FND_API.G_MISS_NUM) THEN
964: x_Flow_Schedule_Rec.std_cost_adjustment_acct := NULL;
965: ELSE
966: x_Flow_Schedule_Rec.std_cost_adjustment_acct := nvl(p_flow_schedule_pvt_rec.std_cost_adjustment_acct ,FND_API.G_MISS_NUM) ;
967: END IF;

Line 966: x_Flow_Schedule_Rec.std_cost_adjustment_acct := nvl(p_flow_schedule_pvt_rec.std_cost_adjustment_acct ,FND_API.G_MISS_NUM) ;

962:
963: IF ( p_flow_schedule_pvt_rec.std_cost_adjustment_acct = FND_API.G_MISS_NUM) THEN
964: x_Flow_Schedule_Rec.std_cost_adjustment_acct := NULL;
965: ELSE
966: x_Flow_Schedule_Rec.std_cost_adjustment_acct := nvl(p_flow_schedule_pvt_rec.std_cost_adjustment_acct ,FND_API.G_MISS_NUM) ;
967: END IF;
968:
969: IF ( p_flow_schedule_pvt_rec.task_id = FND_API.G_MISS_NUM) THEN
970: x_Flow_Schedule_Rec.task_id := NULL;

Line 969: IF ( p_flow_schedule_pvt_rec.task_id = FND_API.G_MISS_NUM) THEN

965: ELSE
966: x_Flow_Schedule_Rec.std_cost_adjustment_acct := nvl(p_flow_schedule_pvt_rec.std_cost_adjustment_acct ,FND_API.G_MISS_NUM) ;
967: END IF;
968:
969: IF ( p_flow_schedule_pvt_rec.task_id = FND_API.G_MISS_NUM) THEN
970: x_Flow_Schedule_Rec.task_id := NULL;
971: ELSE
972: x_Flow_Schedule_Rec.task_id := nvl(p_flow_schedule_pvt_rec.task_id ,FND_API.G_MISS_NUM) ;
973: END IF;

Line 972: x_Flow_Schedule_Rec.task_id := nvl(p_flow_schedule_pvt_rec.task_id ,FND_API.G_MISS_NUM) ;

968:
969: IF ( p_flow_schedule_pvt_rec.task_id = FND_API.G_MISS_NUM) THEN
970: x_Flow_Schedule_Rec.task_id := NULL;
971: ELSE
972: x_Flow_Schedule_Rec.task_id := nvl(p_flow_schedule_pvt_rec.task_id ,FND_API.G_MISS_NUM) ;
973: END IF;
974:
975: IF ( p_flow_schedule_pvt_rec.wip_entity_id = FND_API.G_MISS_NUM) THEN
976: x_Flow_Schedule_Rec.wip_entity_id := NULL;

Line 975: IF ( p_flow_schedule_pvt_rec.wip_entity_id = FND_API.G_MISS_NUM) THEN

971: ELSE
972: x_Flow_Schedule_Rec.task_id := nvl(p_flow_schedule_pvt_rec.task_id ,FND_API.G_MISS_NUM) ;
973: END IF;
974:
975: IF ( p_flow_schedule_pvt_rec.wip_entity_id = FND_API.G_MISS_NUM) THEN
976: x_Flow_Schedule_Rec.wip_entity_id := NULL;
977: ELSE
978: x_Flow_Schedule_Rec.wip_entity_id := nvl(p_flow_schedule_pvt_rec.wip_entity_id ,FND_API.G_MISS_NUM) ;
979: END IF;

Line 978: x_Flow_Schedule_Rec.wip_entity_id := nvl(p_flow_schedule_pvt_rec.wip_entity_id ,FND_API.G_MISS_NUM) ;

974:
975: IF ( p_flow_schedule_pvt_rec.wip_entity_id = FND_API.G_MISS_NUM) THEN
976: x_Flow_Schedule_Rec.wip_entity_id := NULL;
977: ELSE
978: x_Flow_Schedule_Rec.wip_entity_id := nvl(p_flow_schedule_pvt_rec.wip_entity_id ,FND_API.G_MISS_NUM) ;
979: END IF;
980:
981: IF ( p_flow_schedule_pvt_rec.scheduled_by = FND_API.G_MISS_NUM) THEN
982: x_Flow_Schedule_Rec.scheduled_by := NULL;

Line 981: IF ( p_flow_schedule_pvt_rec.scheduled_by = FND_API.G_MISS_NUM) THEN

977: ELSE
978: x_Flow_Schedule_Rec.wip_entity_id := nvl(p_flow_schedule_pvt_rec.wip_entity_id ,FND_API.G_MISS_NUM) ;
979: END IF;
980:
981: IF ( p_flow_schedule_pvt_rec.scheduled_by = FND_API.G_MISS_NUM) THEN
982: x_Flow_Schedule_Rec.scheduled_by := NULL;
983: ELSE
984: x_Flow_Schedule_Rec.scheduled_by := nvl(p_flow_schedule_pvt_rec.scheduled_by,FND_API.G_MISS_NUM) ;
985: END IF;

Line 984: x_Flow_Schedule_Rec.scheduled_by := nvl(p_flow_schedule_pvt_rec.scheduled_by,FND_API.G_MISS_NUM) ;

980:
981: IF ( p_flow_schedule_pvt_rec.scheduled_by = FND_API.G_MISS_NUM) THEN
982: x_Flow_Schedule_Rec.scheduled_by := NULL;
983: ELSE
984: x_Flow_Schedule_Rec.scheduled_by := nvl(p_flow_schedule_pvt_rec.scheduled_by,FND_API.G_MISS_NUM) ;
985: END IF;
986:
987: IF ( p_flow_schedule_pvt_rec.return_status = FND_API.G_MISS_CHAR ) THEN
988: x_Flow_Schedule_Rec.return_status := NULL;

Line 987: IF ( p_flow_schedule_pvt_rec.return_status = FND_API.G_MISS_CHAR ) THEN

983: ELSE
984: x_Flow_Schedule_Rec.scheduled_by := nvl(p_flow_schedule_pvt_rec.scheduled_by,FND_API.G_MISS_NUM) ;
985: END IF;
986:
987: IF ( p_flow_schedule_pvt_rec.return_status = FND_API.G_MISS_CHAR ) THEN
988: x_Flow_Schedule_Rec.return_status := NULL;
989: ELSE
990: x_Flow_Schedule_Rec.return_status := nvl(p_flow_schedule_pvt_rec.return_status ,FND_API.G_MISS_CHAR) ;
991: END IF;

Line 990: x_Flow_Schedule_Rec.return_status := nvl(p_flow_schedule_pvt_rec.return_status ,FND_API.G_MISS_CHAR) ;

986:
987: IF ( p_flow_schedule_pvt_rec.return_status = FND_API.G_MISS_CHAR ) THEN
988: x_Flow_Schedule_Rec.return_status := NULL;
989: ELSE
990: x_Flow_Schedule_Rec.return_status := nvl(p_flow_schedule_pvt_rec.return_status ,FND_API.G_MISS_CHAR) ;
991: END IF;
992:
993: IF ( p_flow_schedule_pvt_rec.db_flag = FND_API.G_MISS_CHAR ) THEN
994: x_Flow_Schedule_Rec.db_flag := NULL;

Line 993: IF ( p_flow_schedule_pvt_rec.db_flag = FND_API.G_MISS_CHAR ) THEN

989: ELSE
990: x_Flow_Schedule_Rec.return_status := nvl(p_flow_schedule_pvt_rec.return_status ,FND_API.G_MISS_CHAR) ;
991: END IF;
992:
993: IF ( p_flow_schedule_pvt_rec.db_flag = FND_API.G_MISS_CHAR ) THEN
994: x_Flow_Schedule_Rec.db_flag := NULL;
995: ELSE
996: x_Flow_Schedule_Rec.db_flag := nvl(p_flow_schedule_pvt_rec.db_flag ,FND_API.G_MISS_CHAR ) ;
997: END IF;

Line 996: x_Flow_Schedule_Rec.db_flag := nvl(p_flow_schedule_pvt_rec.db_flag ,FND_API.G_MISS_CHAR ) ;

992:
993: IF ( p_flow_schedule_pvt_rec.db_flag = FND_API.G_MISS_CHAR ) THEN
994: x_Flow_Schedule_Rec.db_flag := NULL;
995: ELSE
996: x_Flow_Schedule_Rec.db_flag := nvl(p_flow_schedule_pvt_rec.db_flag ,FND_API.G_MISS_CHAR ) ;
997: END IF;
998:
999: IF ( p_flow_schedule_pvt_rec.operation = FND_API.G_MISS_CHAR ) THEN
1000: x_Flow_Schedule_Rec.operation := NULL;

Line 999: IF ( p_flow_schedule_pvt_rec.operation = FND_API.G_MISS_CHAR ) THEN

995: ELSE
996: x_Flow_Schedule_Rec.db_flag := nvl(p_flow_schedule_pvt_rec.db_flag ,FND_API.G_MISS_CHAR ) ;
997: END IF;
998:
999: IF ( p_flow_schedule_pvt_rec.operation = FND_API.G_MISS_CHAR ) THEN
1000: x_Flow_Schedule_Rec.operation := NULL;
1001: ELSE
1002: x_Flow_Schedule_Rec.operation := nvl(p_flow_schedule_pvt_rec.operation ,FND_API.G_MISS_CHAR ) ;
1003: END IF;

Line 1002: x_Flow_Schedule_Rec.operation := nvl(p_flow_schedule_pvt_rec.operation ,FND_API.G_MISS_CHAR ) ;

998:
999: IF ( p_flow_schedule_pvt_rec.operation = FND_API.G_MISS_CHAR ) THEN
1000: x_Flow_Schedule_Rec.operation := NULL;
1001: ELSE
1002: x_Flow_Schedule_Rec.operation := nvl(p_flow_schedule_pvt_rec.operation ,FND_API.G_MISS_CHAR ) ;
1003: END IF;
1004:
1005: IF ( p_flow_schedule_pvt_rec.end_item_unit_number = FND_API.G_MISS_CHAR ) THEN
1006: x_Flow_Schedule_Rec.end_item_unit_number := NULL;

Line 1005: IF ( p_flow_schedule_pvt_rec.end_item_unit_number = FND_API.G_MISS_CHAR ) THEN

1001: ELSE
1002: x_Flow_Schedule_Rec.operation := nvl(p_flow_schedule_pvt_rec.operation ,FND_API.G_MISS_CHAR ) ;
1003: END IF;
1004:
1005: IF ( p_flow_schedule_pvt_rec.end_item_unit_number = FND_API.G_MISS_CHAR ) THEN
1006: x_Flow_Schedule_Rec.end_item_unit_number := NULL;
1007: ELSE
1008: x_Flow_Schedule_Rec.end_item_unit_number := nvl(p_flow_schedule_pvt_rec.end_item_unit_number,FND_API.G_MISS_CHAR ) ;
1009: END IF;

Line 1008: x_Flow_Schedule_Rec.end_item_unit_number := nvl(p_flow_schedule_pvt_rec.end_item_unit_number,FND_API.G_MISS_CHAR ) ;

1004:
1005: IF ( p_flow_schedule_pvt_rec.end_item_unit_number = FND_API.G_MISS_CHAR ) THEN
1006: x_Flow_Schedule_Rec.end_item_unit_number := NULL;
1007: ELSE
1008: x_Flow_Schedule_Rec.end_item_unit_number := nvl(p_flow_schedule_pvt_rec.end_item_unit_number,FND_API.G_MISS_CHAR ) ;
1009: END IF;
1010:
1011: IF ( p_flow_schedule_pvt_rec.quantity_scrapped = FND_API.G_MISS_NUM ) THEN
1012: x_Flow_Schedule_Rec.quantity_scrapped := NULL;

Line 1011: IF ( p_flow_schedule_pvt_rec.quantity_scrapped = FND_API.G_MISS_NUM ) THEN

1007: ELSE
1008: x_Flow_Schedule_Rec.end_item_unit_number := nvl(p_flow_schedule_pvt_rec.end_item_unit_number,FND_API.G_MISS_CHAR ) ;
1009: END IF;
1010:
1011: IF ( p_flow_schedule_pvt_rec.quantity_scrapped = FND_API.G_MISS_NUM ) THEN
1012: x_Flow_Schedule_Rec.quantity_scrapped := NULL;
1013: ELSE
1014: x_Flow_Schedule_Rec.quantity_scrapped := nvl(p_flow_schedule_pvt_rec.quantity_scrapped ,FND_API.G_MISS_NUM) ;
1015: END IF;

Line 1014: x_Flow_Schedule_Rec.quantity_scrapped := nvl(p_flow_schedule_pvt_rec.quantity_scrapped ,FND_API.G_MISS_NUM) ;

1010:
1011: IF ( p_flow_schedule_pvt_rec.quantity_scrapped = FND_API.G_MISS_NUM ) THEN
1012: x_Flow_Schedule_Rec.quantity_scrapped := NULL;
1013: ELSE
1014: x_Flow_Schedule_Rec.quantity_scrapped := nvl(p_flow_schedule_pvt_rec.quantity_scrapped ,FND_API.G_MISS_NUM) ;
1015: END IF;
1016:
1017: IF ( p_flow_schedule_pvt_rec.kanban_card_id = FND_API.G_MISS_NUM) THEN
1018: x_Flow_Schedule_Rec.kanban_card_id := NULL;

Line 1017: IF ( p_flow_schedule_pvt_rec.kanban_card_id = FND_API.G_MISS_NUM) THEN

1013: ELSE
1014: x_Flow_Schedule_Rec.quantity_scrapped := nvl(p_flow_schedule_pvt_rec.quantity_scrapped ,FND_API.G_MISS_NUM) ;
1015: END IF;
1016:
1017: IF ( p_flow_schedule_pvt_rec.kanban_card_id = FND_API.G_MISS_NUM) THEN
1018: x_Flow_Schedule_Rec.kanban_card_id := NULL;
1019: ELSE
1020: x_Flow_Schedule_Rec.kanban_card_id := nvl(p_flow_schedule_pvt_rec.kanban_card_id ,FND_API.G_MISS_NUM) ;
1021: END IF;

Line 1020: x_Flow_Schedule_Rec.kanban_card_id := nvl(p_flow_schedule_pvt_rec.kanban_card_id ,FND_API.G_MISS_NUM) ;

1016:
1017: IF ( p_flow_schedule_pvt_rec.kanban_card_id = FND_API.G_MISS_NUM) THEN
1018: x_Flow_Schedule_Rec.kanban_card_id := NULL;
1019: ELSE
1020: x_Flow_Schedule_Rec.kanban_card_id := nvl(p_flow_schedule_pvt_rec.kanban_card_id ,FND_API.G_MISS_NUM) ;
1021: END IF;
1022:
1023: IF ( p_flow_schedule_pvt_rec.synch_schedule_num = FND_API.G_MISS_CHAR ) THEN
1024: x_Flow_Schedule_Rec.synch_schedule_num := NULL;

Line 1023: IF ( p_flow_schedule_pvt_rec.synch_schedule_num = FND_API.G_MISS_CHAR ) THEN

1019: ELSE
1020: x_Flow_Schedule_Rec.kanban_card_id := nvl(p_flow_schedule_pvt_rec.kanban_card_id ,FND_API.G_MISS_NUM) ;
1021: END IF;
1022:
1023: IF ( p_flow_schedule_pvt_rec.synch_schedule_num = FND_API.G_MISS_CHAR ) THEN
1024: x_Flow_Schedule_Rec.synch_schedule_num := NULL;
1025: ELSE
1026: x_Flow_Schedule_Rec.synch_schedule_num := nvl(p_flow_schedule_pvt_rec.synch_schedule_num ,FND_API.G_MISS_CHAR ) ;
1027: END IF;

Line 1026: x_Flow_Schedule_Rec.synch_schedule_num := nvl(p_flow_schedule_pvt_rec.synch_schedule_num ,FND_API.G_MISS_CHAR ) ;

1022:
1023: IF ( p_flow_schedule_pvt_rec.synch_schedule_num = FND_API.G_MISS_CHAR ) THEN
1024: x_Flow_Schedule_Rec.synch_schedule_num := NULL;
1025: ELSE
1026: x_Flow_Schedule_Rec.synch_schedule_num := nvl(p_flow_schedule_pvt_rec.synch_schedule_num ,FND_API.G_MISS_CHAR ) ;
1027: END IF;
1028:
1029: IF ( p_flow_schedule_pvt_rec.synch_operation_seq_num = FND_API.G_MISS_NUM) THEN
1030: x_Flow_Schedule_Rec.synch_operation_seq_num := NULL;

Line 1029: IF ( p_flow_schedule_pvt_rec.synch_operation_seq_num = FND_API.G_MISS_NUM) THEN

1025: ELSE
1026: x_Flow_Schedule_Rec.synch_schedule_num := nvl(p_flow_schedule_pvt_rec.synch_schedule_num ,FND_API.G_MISS_CHAR ) ;
1027: END IF;
1028:
1029: IF ( p_flow_schedule_pvt_rec.synch_operation_seq_num = FND_API.G_MISS_NUM) THEN
1030: x_Flow_Schedule_Rec.synch_operation_seq_num := NULL;
1031: ELSE
1032: x_Flow_Schedule_Rec.synch_operation_seq_num := nvl(p_flow_schedule_pvt_rec.synch_operation_seq_num ,FND_API.G_MISS_NUM) ;
1033: END IF;

Line 1032: x_Flow_Schedule_Rec.synch_operation_seq_num := nvl(p_flow_schedule_pvt_rec.synch_operation_seq_num ,FND_API.G_MISS_NUM) ;

1028:
1029: IF ( p_flow_schedule_pvt_rec.synch_operation_seq_num = FND_API.G_MISS_NUM) THEN
1030: x_Flow_Schedule_Rec.synch_operation_seq_num := NULL;
1031: ELSE
1032: x_Flow_Schedule_Rec.synch_operation_seq_num := nvl(p_flow_schedule_pvt_rec.synch_operation_seq_num ,FND_API.G_MISS_NUM) ;
1033: END IF;
1034:
1035: IF ( p_flow_schedule_pvt_rec.roll_forwarded_flag = FND_API.G_MISS_NUM ) THEN
1036: x_Flow_Schedule_Rec.roll_forwarded_flag := NULL;

Line 1035: IF ( p_flow_schedule_pvt_rec.roll_forwarded_flag = FND_API.G_MISS_NUM ) THEN

1031: ELSE
1032: x_Flow_Schedule_Rec.synch_operation_seq_num := nvl(p_flow_schedule_pvt_rec.synch_operation_seq_num ,FND_API.G_MISS_NUM) ;
1033: END IF;
1034:
1035: IF ( p_flow_schedule_pvt_rec.roll_forwarded_flag = FND_API.G_MISS_NUM ) THEN
1036: x_Flow_Schedule_Rec.roll_forwarded_flag := NULL;
1037: ELSE
1038: x_Flow_Schedule_Rec.roll_forwarded_flag := nvl(p_flow_schedule_pvt_rec.roll_forwarded_flag,FND_API.G_MISS_NUM);
1039: END IF;

Line 1038: x_Flow_Schedule_Rec.roll_forwarded_flag := nvl(p_flow_schedule_pvt_rec.roll_forwarded_flag,FND_API.G_MISS_NUM);

1034:
1035: IF ( p_flow_schedule_pvt_rec.roll_forwarded_flag = FND_API.G_MISS_NUM ) THEN
1036: x_Flow_Schedule_Rec.roll_forwarded_flag := NULL;
1037: ELSE
1038: x_Flow_Schedule_Rec.roll_forwarded_flag := nvl(p_flow_schedule_pvt_rec.roll_forwarded_flag,FND_API.G_MISS_NUM);
1039: END IF;
1040:
1041: IF ( p_flow_schedule_pvt_rec.current_line_operation = FND_API.G_MISS_NUM) THEN
1042: x_Flow_Schedule_Rec.current_line_operation := NULL;

Line 1041: IF ( p_flow_schedule_pvt_rec.current_line_operation = FND_API.G_MISS_NUM) THEN

1037: ELSE
1038: x_Flow_Schedule_Rec.roll_forwarded_flag := nvl(p_flow_schedule_pvt_rec.roll_forwarded_flag,FND_API.G_MISS_NUM);
1039: END IF;
1040:
1041: IF ( p_flow_schedule_pvt_rec.current_line_operation = FND_API.G_MISS_NUM) THEN
1042: x_Flow_Schedule_Rec.current_line_operation := NULL;
1043: ELSE
1044: x_Flow_Schedule_Rec.current_line_operation := nvl(p_flow_schedule_pvt_rec.current_line_operation ,FND_API.G_MISS_NUM);
1045: END IF;

Line 1044: x_Flow_Schedule_Rec.current_line_operation := nvl(p_flow_schedule_pvt_rec.current_line_operation ,FND_API.G_MISS_NUM);

1040:
1041: IF ( p_flow_schedule_pvt_rec.current_line_operation = FND_API.G_MISS_NUM) THEN
1042: x_Flow_Schedule_Rec.current_line_operation := NULL;
1043: ELSE
1044: x_Flow_Schedule_Rec.current_line_operation := nvl(p_flow_schedule_pvt_rec.current_line_operation ,FND_API.G_MISS_NUM);
1045: END IF;
1046: END;
1047:
1048:

Line 1072: l_flow_schedule_rec.return_status := FND_API.G_RET_STS_SUCCESS;

1068: );
1069:
1070: -- Set record return status.
1071:
1072: l_flow_schedule_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1073:
1074: -- Prepare record.
1075:
1076: IF l_flow_schedule_rec.operation = MRP_GLOBALS.G_OPR_CREATE THEN

Line 1078: l_flow_schedule_rec.db_flag := FND_API.G_FALSE;

1074: -- Prepare record.
1075:
1076: IF l_flow_schedule_rec.operation = MRP_GLOBALS.G_OPR_CREATE THEN
1077:
1078: l_flow_schedule_rec.db_flag := FND_API.G_FALSE;
1079:
1080: -- Set missing old record elements to NULL.
1081:
1082: l_old_flow_schedule_rec :=

Line 1089: l_flow_schedule_rec.db_flag := FND_API.G_TRUE;

1085:
1086: ELSIF l_flow_schedule_rec.operation = MRP_GLOBALS.G_OPR_UPDATE
1087: OR l_flow_schedule_rec.operation = MRP_GLOBALS.G_OPR_DELETE
1088: THEN
1089: l_flow_schedule_rec.db_flag := FND_API.G_TRUE;
1090:
1091: -- Query Old if missing
1092:
1093: IF l_old_flow_schedule_rec.organization_id IS NULL

Line 1124: IF p_validation_level > FND_API.G_VALID_LEVEL_NONE THEN

1120: IF l_control_rec.default_attributes
1121: OR l_control_rec.change_attributes
1122: THEN
1123:
1124: IF p_validation_level > FND_API.G_VALID_LEVEL_NONE THEN
1125:
1126: MRP_Validate_Flow_Schedule.Attributes
1127: ( x_return_status => l_return_status
1128: , p_flow_schedule_rec => l_flow_schedule_rec

Line 1132: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1128: , p_flow_schedule_rec => l_flow_schedule_rec
1129: , p_old_flow_schedule_rec => l_old_flow_schedule_rec
1130: );
1131:
1132: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1133: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1134: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1135: RAISE FND_API.G_EXC_ERROR;
1136: END IF;

Line 1133: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1129: , p_old_flow_schedule_rec => l_old_flow_schedule_rec
1130: );
1131:
1132: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1133: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1134: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1135: RAISE FND_API.G_EXC_ERROR;
1136: END IF;
1137:

Line 1134: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1130: );
1131:
1132: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1133: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1134: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1135: RAISE FND_API.G_EXC_ERROR;
1136: END IF;
1137:
1138: END IF;

Line 1135: RAISE FND_API.G_EXC_ERROR;

1131:
1132: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1133: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1134: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1135: RAISE FND_API.G_EXC_ERROR;
1136: END IF;
1137:
1138: END IF;
1139:

Line 1202: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1198: );
1199:
1200: END IF;
1201:
1202: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1203: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1204: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1205: RAISE FND_API.G_EXC_ERROR;
1206: END IF;

Line 1203: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1199:
1200: END IF;
1201:
1202: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1203: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1204: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1205: RAISE FND_API.G_EXC_ERROR;
1206: END IF;
1207:

Line 1204: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1200: END IF;
1201:
1202: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1203: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1204: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1205: RAISE FND_API.G_EXC_ERROR;
1206: END IF;
1207:
1208: END IF;

Line 1205: RAISE FND_API.G_EXC_ERROR;

1201:
1202: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1203: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1204: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1205: RAISE FND_API.G_EXC_ERROR;
1206: END IF;
1207:
1208: END IF;
1209:

Line 1253: WHEN FND_API.G_EXC_ERROR THEN

1249: x_old_flow_schedule_rec := l_old_flow_schedule_rec;
1250:
1251: EXCEPTION
1252:
1253: WHEN FND_API.G_EXC_ERROR THEN
1254:
1255: l_flow_schedule_rec.return_status := FND_API.G_RET_STS_ERROR;
1256: x_flow_schedule_rec := l_flow_schedule_rec;
1257: x_old_flow_schedule_rec := l_old_flow_schedule_rec;

Line 1255: l_flow_schedule_rec.return_status := FND_API.G_RET_STS_ERROR;

1251: EXCEPTION
1252:
1253: WHEN FND_API.G_EXC_ERROR THEN
1254:
1255: l_flow_schedule_rec.return_status := FND_API.G_RET_STS_ERROR;
1256: x_flow_schedule_rec := l_flow_schedule_rec;
1257: x_old_flow_schedule_rec := l_old_flow_schedule_rec;
1258: RAISE;
1259:

Line 1260: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1256: x_flow_schedule_rec := l_flow_schedule_rec;
1257: x_old_flow_schedule_rec := l_old_flow_schedule_rec;
1258: RAISE;
1259:
1260: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1261:
1262: l_flow_schedule_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1263: x_flow_schedule_rec := l_flow_schedule_rec;
1264: x_old_flow_schedule_rec := l_old_flow_schedule_rec;

Line 1262: l_flow_schedule_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1258: RAISE;
1259:
1260: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1261:
1262: l_flow_schedule_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1263: x_flow_schedule_rec := l_flow_schedule_rec;
1264: x_old_flow_schedule_rec := l_old_flow_schedule_rec;
1265:
1266: RAISE;

Line 1278: l_flow_schedule_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1274: , 'Flow_Schedule'
1275: );
1276: END IF;
1277:
1278: l_flow_schedule_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1279: x_flow_schedule_rec := l_flow_schedule_rec;
1280: x_old_flow_schedule_rec := l_old_flow_schedule_rec;
1281:
1282: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1282: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1278: l_flow_schedule_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1279: x_flow_schedule_rec := l_flow_schedule_rec;
1280: x_old_flow_schedule_rec := l_old_flow_schedule_rec;
1281:
1282: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1283:
1284: END Flow_Schedule;
1285:
1286: -- Start of Comments

Line 1331: IF NOT FND_API.Compatible_API_Call

1327:
1328:
1329: -- Standard call to check for call compatibility
1330:
1331: IF NOT FND_API.Compatible_API_Call
1332: ( l_api_version_number
1333: , p_api_version_number
1334: , l_api_name
1335: , G_PKG_NAME

Line 1338: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1334: , l_api_name
1335: , G_PKG_NAME
1336: )
1337: THEN
1338: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1339: END IF;
1340:
1341: -- Initialize message list.
1342:

Line 1343: IF FND_API.to_Boolean(NVL(p_init_msg_list,FND_API.G_FALSE)) THEN

1339: END IF;
1340:
1341: -- Initialize message list.
1342:
1343: IF FND_API.to_Boolean(NVL(p_init_msg_list,FND_API.G_FALSE)) THEN
1344: FND_MSG_PUB.initialize;
1345: END IF;
1346:
1347: -- Flow_Schedule

Line 1349: ( p_validation_level => nvl(p_validation_level,FND_API.G_VALID_LEVEL_FULL)

1345: END IF;
1346:
1347: -- Flow_Schedule
1348: Flow_Schedule
1349: ( p_validation_level => nvl(p_validation_level,FND_API.G_VALID_LEVEL_FULL)
1350: , p_control_rec => p_control_rec
1351: , x_flow_schedule_rec => l_flow_schedule_rec
1352: , x_old_flow_schedule_rec => l_old_flow_schedule_rec
1353: );

Line 1415: x_return_status := FND_API.G_RET_STS_SUCCESS;

1411: END IF;
1412:
1413: -- Derive return status.
1414:
1415: x_return_status := FND_API.G_RET_STS_SUCCESS;
1416:
1417: IF l_flow_schedule_rec.return_status = FND_API.G_RET_STS_ERROR THEN
1418: x_return_status := FND_API.G_RET_STS_ERROR;
1419: END IF;

Line 1417: IF l_flow_schedule_rec.return_status = FND_API.G_RET_STS_ERROR THEN

1413: -- Derive return status.
1414:
1415: x_return_status := FND_API.G_RET_STS_SUCCESS;
1416:
1417: IF l_flow_schedule_rec.return_status = FND_API.G_RET_STS_ERROR THEN
1418: x_return_status := FND_API.G_RET_STS_ERROR;
1419: END IF;
1420:
1421: -- Get message count and data

Line 1418: x_return_status := FND_API.G_RET_STS_ERROR;

1414:
1415: x_return_status := FND_API.G_RET_STS_SUCCESS;
1416:
1417: IF l_flow_schedule_rec.return_status = FND_API.G_RET_STS_ERROR THEN
1418: x_return_status := FND_API.G_RET_STS_ERROR;
1419: END IF;
1420:
1421: -- Get message count and data
1422:

Line 1431: WHEN FND_API.G_EXC_ERROR THEN

1427:
1428:
1429: EXCEPTION
1430:
1431: WHEN FND_API.G_EXC_ERROR THEN
1432:
1433: x_return_status := FND_API.G_RET_STS_ERROR;
1434:
1435: -- Get message count and data

Line 1433: x_return_status := FND_API.G_RET_STS_ERROR;

1429: EXCEPTION
1430:
1431: WHEN FND_API.G_EXC_ERROR THEN
1432:
1433: x_return_status := FND_API.G_RET_STS_ERROR;
1434:
1435: -- Get message count and data
1436:
1437: FND_MSG_PUB.Count_And_Get

Line 1442: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1438: ( p_count => x_msg_count
1439: , p_data => x_msg_data
1440: );
1441:
1442: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1443:
1444: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1445:
1446: -- Get message count and data

Line 1444: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1440: );
1441:
1442: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1443:
1444: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1445:
1446: -- Get message count and data
1447:
1448: FND_MSG_PUB.Count_And_Get

Line 1455: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1451: );
1452:
1453: WHEN OTHERS THEN
1454:
1455: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1456:
1457: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1458: THEN
1459: FND_MSG_PUB.Add_Exc_Msg

Line 1503: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

1499: )
1500: IS
1501: l_api_version_number CONSTANT NUMBER := 1.0;
1502: l_api_name CONSTANT VARCHAR2(30):= 'Lock_Flow_Schedule';
1503: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1504: BEGIN
1505:
1506: -- Standard call to check for call compatibility
1507:

Line 1508: IF NOT FND_API.Compatible_API_Call

1504: BEGIN
1505:
1506: -- Standard call to check for call compatibility
1507:
1508: IF NOT FND_API.Compatible_API_Call
1509: ( l_api_version_number
1510: , p_api_version_number
1511: , l_api_name
1512: , G_PKG_NAME

Line 1515: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1511: , l_api_name
1512: , G_PKG_NAME
1513: )
1514: THEN
1515: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1516: END IF;
1517:
1518: -- Initialize message list.
1519:

Line 1520: IF FND_API.to_Boolean(NVL(p_init_msg_list,FND_API.G_FALSE)) THEN

1516: END IF;
1517:
1518: -- Initialize message list.
1519:
1520: IF FND_API.to_Boolean(NVL(p_init_msg_list,FND_API.G_FALSE)) THEN
1521: FND_MSG_PUB.initialize;
1522: END IF;
1523:
1524: -- Set Savepoint

Line 1538: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1534: , x_flow_schedule_rec => x_flow_schedule_rec
1535: , x_return_status => l_return_status
1536: );
1537:
1538: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1539: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1540: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1541: RAISE FND_API.G_EXC_ERROR;
1542: END IF;

Line 1539: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1535: , x_return_status => l_return_status
1536: );
1537:
1538: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1539: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1540: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1541: RAISE FND_API.G_EXC_ERROR;
1542: END IF;
1543:

Line 1540: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1536: );
1537:
1538: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1539: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1540: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1541: RAISE FND_API.G_EXC_ERROR;
1542: END IF;
1543:
1544:

Line 1541: RAISE FND_API.G_EXC_ERROR;

1537:
1538: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1539: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1540: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1541: RAISE FND_API.G_EXC_ERROR;
1542: END IF;
1543:
1544:
1545: END IF;

Line 1549: x_return_status := FND_API.G_RET_STS_SUCCESS;

1545: END IF;
1546:
1547: -- Set return status
1548:
1549: x_return_status := FND_API.G_RET_STS_SUCCESS;
1550:
1551: -- Get message count and data
1552:
1553: FND_MSG_PUB.Count_And_Get

Line 1561: WHEN FND_API.G_EXC_ERROR THEN

1557:
1558:
1559: EXCEPTION
1560:
1561: WHEN FND_API.G_EXC_ERROR THEN
1562:
1563: x_return_status := FND_API.G_RET_STS_ERROR;
1564:
1565: -- Get message count and data

Line 1563: x_return_status := FND_API.G_RET_STS_ERROR;

1559: EXCEPTION
1560:
1561: WHEN FND_API.G_EXC_ERROR THEN
1562:
1563: x_return_status := FND_API.G_RET_STS_ERROR;
1564:
1565: -- Get message count and data
1566:
1567: FND_MSG_PUB.Count_And_Get

Line 1576: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1572: -- Rollback
1573:
1574: ROLLBACK TO Lock_Flow_Schedule_PVT;
1575:
1576: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1577:
1578: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1579:
1580: -- Get message count and data

Line 1578: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1574: ROLLBACK TO Lock_Flow_Schedule_PVT;
1575:
1576: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1577:
1578: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1579:
1580: -- Get message count and data
1581:
1582: FND_MSG_PUB.Count_And_Get

Line 1593: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1589: ROLLBACK TO Lock_Flow_Schedule_PVT;
1590:
1591: WHEN OTHERS THEN
1592:
1593: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1594:
1595: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1596: THEN
1597: FND_MSG_PUB.Add_Exc_Msg

Line 1655: IF NOT FND_API.Compatible_API_Call

1651: BEGIN
1652:
1653: -- Standard call to check for call compatibility
1654:
1655: IF NOT FND_API.Compatible_API_Call
1656: ( l_api_version_number
1657: , p_api_version_number
1658: , l_api_name
1659: , G_PKG_NAME

Line 1662: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1658: , l_api_name
1659: , G_PKG_NAME
1660: )
1661: THEN
1662: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1663: END IF;
1664:
1665: -- Initialize message list.
1666:

Line 1667: IF FND_API.to_Boolean(NVL(p_init_msg_list,FND_API.G_FALSE)) THEN

1663: END IF;
1664:
1665: -- Initialize message list.
1666:
1667: IF FND_API.to_Boolean(NVL(p_init_msg_list,FND_API.G_FALSE)) THEN
1668: FND_MSG_PUB.initialize;
1669: END IF;
1670:
1671: -- Get flow_schedule ( parent = flow_schedule )

Line 1683: x_return_status := FND_API.G_RET_STS_SUCCESS;

1679: x_flow_schedule_rec := l_flow_schedule_rec;
1680:
1681: -- Set return status
1682:
1683: x_return_status := FND_API.G_RET_STS_SUCCESS;
1684:
1685: -- Get message count and data
1686:
1687: FND_MSG_PUB.Count_And_Get

Line 1695: WHEN FND_API.G_EXC_ERROR THEN

1691:
1692:
1693: EXCEPTION
1694:
1695: WHEN FND_API.G_EXC_ERROR THEN
1696:
1697: x_return_status := FND_API.G_RET_STS_ERROR;
1698:
1699: -- Get message count and data

Line 1697: x_return_status := FND_API.G_RET_STS_ERROR;

1693: EXCEPTION
1694:
1695: WHEN FND_API.G_EXC_ERROR THEN
1696:
1697: x_return_status := FND_API.G_RET_STS_ERROR;
1698:
1699: -- Get message count and data
1700:
1701: FND_MSG_PUB.Count_And_Get

Line 1706: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1702: ( p_count => x_msg_count
1703: , p_data => x_msg_data
1704: );
1705:
1706: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1707:
1708: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1709:
1710: -- Get message count and data

Line 1708: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1704: );
1705:
1706: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1707:
1708: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1709:
1710: -- Get message count and data
1711:
1712: FND_MSG_PUB.Count_And_Get

Line 1719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1715: );
1716:
1717: WHEN OTHERS THEN
1718:
1719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1720:
1721: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1722: THEN
1723: FND_MSG_PUB.Add_Exc_Msg