APPS.CSP_MSTRSTCK_LISTS_ITMS_PKG dependencies on FND_API

Line 49: If (px_MSL_ID IS NULL) OR (px_MSL_ID = FND_API.G_MISS_NUM) then

45:
46: IS
47: CURSOR C2 IS SELECT CSP_MSTRSTCK_LISTS_ITMS_S1.nextval FROM sys.dual;
48: BEGIN
49: If (px_MSL_ID IS NULL) OR (px_MSL_ID = FND_API.G_MISS_NUM) then
50: OPEN C2;
51: FETCH C2 INTO px_MSL_ID;
52: CLOSE C2;
53: End If;

Line 87: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),

83: ATTRIBUTE14,
84: ATTRIBUTE15
85: ) VALUES (
86: px_MSL_ID,
87: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
88: decode(p_CREATION_DATE, fnd_api.g_miss_date,to_date(null),p_creation_date),
89: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
90: decode(p_LAST_UPDATE_DATE, fnd_api.g_miss_date,to_date(null),p_last_update_date),
91: decode( p_LAST_UPDATED_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_LOGIN),

Line 88: decode(p_CREATION_DATE, fnd_api.g_miss_date,to_date(null),p_creation_date),

84: ATTRIBUTE15
85: ) VALUES (
86: px_MSL_ID,
87: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
88: decode(p_CREATION_DATE, fnd_api.g_miss_date,to_date(null),p_creation_date),
89: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
90: decode(p_LAST_UPDATE_DATE, fnd_api.g_miss_date,to_date(null),p_last_update_date),
91: decode( p_LAST_UPDATED_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_LOGIN),
92: decode( p_PARTS_LOOPS_ID, FND_API.G_MISS_NUM, NULL, p_PARTS_LOOPS_ID),

Line 89: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),

85: ) VALUES (
86: px_MSL_ID,
87: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
88: decode(p_CREATION_DATE, fnd_api.g_miss_date,to_date(null),p_creation_date),
89: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
90: decode(p_LAST_UPDATE_DATE, fnd_api.g_miss_date,to_date(null),p_last_update_date),
91: decode( p_LAST_UPDATED_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_LOGIN),
92: decode( p_PARTS_LOOPS_ID, FND_API.G_MISS_NUM, NULL, p_PARTS_LOOPS_ID),
93: decode( p_PLANNER_CODE, FND_API.G_MISS_CHAR, NULL, p_PLANNER_CODE),

Line 90: decode(p_LAST_UPDATE_DATE, fnd_api.g_miss_date,to_date(null),p_last_update_date),

86: px_MSL_ID,
87: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
88: decode(p_CREATION_DATE, fnd_api.g_miss_date,to_date(null),p_creation_date),
89: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
90: decode(p_LAST_UPDATE_DATE, fnd_api.g_miss_date,to_date(null),p_last_update_date),
91: decode( p_LAST_UPDATED_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_LOGIN),
92: decode( p_PARTS_LOOPS_ID, FND_API.G_MISS_NUM, NULL, p_PARTS_LOOPS_ID),
93: decode( p_PLANNER_CODE, FND_API.G_MISS_CHAR, NULL, p_PLANNER_CODE),
94: decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID),

Line 91: decode( p_LAST_UPDATED_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_LOGIN),

87: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
88: decode(p_CREATION_DATE, fnd_api.g_miss_date,to_date(null),p_creation_date),
89: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
90: decode(p_LAST_UPDATE_DATE, fnd_api.g_miss_date,to_date(null),p_last_update_date),
91: decode( p_LAST_UPDATED_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_LOGIN),
92: decode( p_PARTS_LOOPS_ID, FND_API.G_MISS_NUM, NULL, p_PARTS_LOOPS_ID),
93: decode( p_PLANNER_CODE, FND_API.G_MISS_CHAR, NULL, p_PLANNER_CODE),
94: decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID),
95: decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_ORGANIZATION_ID),

Line 92: decode( p_PARTS_LOOPS_ID, FND_API.G_MISS_NUM, NULL, p_PARTS_LOOPS_ID),

88: decode(p_CREATION_DATE, fnd_api.g_miss_date,to_date(null),p_creation_date),
89: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
90: decode(p_LAST_UPDATE_DATE, fnd_api.g_miss_date,to_date(null),p_last_update_date),
91: decode( p_LAST_UPDATED_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_LOGIN),
92: decode( p_PARTS_LOOPS_ID, FND_API.G_MISS_NUM, NULL, p_PARTS_LOOPS_ID),
93: decode( p_PLANNER_CODE, FND_API.G_MISS_CHAR, NULL, p_PLANNER_CODE),
94: decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID),
95: decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_ORGANIZATION_ID),
96: decode( p_TOTAL_LOOP_QUANTITY, FND_API.G_MISS_NUM, NULL, p_TOTAL_LOOP_QUANTITY),

Line 93: decode( p_PLANNER_CODE, FND_API.G_MISS_CHAR, NULL, p_PLANNER_CODE),

89: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
90: decode(p_LAST_UPDATE_DATE, fnd_api.g_miss_date,to_date(null),p_last_update_date),
91: decode( p_LAST_UPDATED_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_LOGIN),
92: decode( p_PARTS_LOOPS_ID, FND_API.G_MISS_NUM, NULL, p_PARTS_LOOPS_ID),
93: decode( p_PLANNER_CODE, FND_API.G_MISS_CHAR, NULL, p_PLANNER_CODE),
94: decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID),
95: decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_ORGANIZATION_ID),
96: decode( p_TOTAL_LOOP_QUANTITY, FND_API.G_MISS_NUM, NULL, p_TOTAL_LOOP_QUANTITY),
97: decode( p_TOTAL_LOOP_MIN_GOOD_QUANTITY, FND_API.G_MISS_NUM, NULL, p_TOTAL_LOOP_MIN_GOOD_QUANTITY),

Line 94: decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID),

90: decode(p_LAST_UPDATE_DATE, fnd_api.g_miss_date,to_date(null),p_last_update_date),
91: decode( p_LAST_UPDATED_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_LOGIN),
92: decode( p_PARTS_LOOPS_ID, FND_API.G_MISS_NUM, NULL, p_PARTS_LOOPS_ID),
93: decode( p_PLANNER_CODE, FND_API.G_MISS_CHAR, NULL, p_PLANNER_CODE),
94: decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID),
95: decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_ORGANIZATION_ID),
96: decode( p_TOTAL_LOOP_QUANTITY, FND_API.G_MISS_NUM, NULL, p_TOTAL_LOOP_QUANTITY),
97: decode( p_TOTAL_LOOP_MIN_GOOD_QUANTITY, FND_API.G_MISS_NUM, NULL, p_TOTAL_LOOP_MIN_GOOD_QUANTITY),
98: decode( p_PLANNING_TYPE_CODE, FND_API.G_MISS_NUM, NULL, p_PLANNING_TYPE_CODE),

Line 95: decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_ORGANIZATION_ID),

91: decode( p_LAST_UPDATED_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_LOGIN),
92: decode( p_PARTS_LOOPS_ID, FND_API.G_MISS_NUM, NULL, p_PARTS_LOOPS_ID),
93: decode( p_PLANNER_CODE, FND_API.G_MISS_CHAR, NULL, p_PLANNER_CODE),
94: decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID),
95: decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_ORGANIZATION_ID),
96: decode( p_TOTAL_LOOP_QUANTITY, FND_API.G_MISS_NUM, NULL, p_TOTAL_LOOP_QUANTITY),
97: decode( p_TOTAL_LOOP_MIN_GOOD_QUANTITY, FND_API.G_MISS_NUM, NULL, p_TOTAL_LOOP_MIN_GOOD_QUANTITY),
98: decode( p_PLANNING_TYPE_CODE, FND_API.G_MISS_NUM, NULL, p_PLANNING_TYPE_CODE),
99: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),

Line 96: decode( p_TOTAL_LOOP_QUANTITY, FND_API.G_MISS_NUM, NULL, p_TOTAL_LOOP_QUANTITY),

92: decode( p_PARTS_LOOPS_ID, FND_API.G_MISS_NUM, NULL, p_PARTS_LOOPS_ID),
93: decode( p_PLANNER_CODE, FND_API.G_MISS_CHAR, NULL, p_PLANNER_CODE),
94: decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID),
95: decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_ORGANIZATION_ID),
96: decode( p_TOTAL_LOOP_QUANTITY, FND_API.G_MISS_NUM, NULL, p_TOTAL_LOOP_QUANTITY),
97: decode( p_TOTAL_LOOP_MIN_GOOD_QUANTITY, FND_API.G_MISS_NUM, NULL, p_TOTAL_LOOP_MIN_GOOD_QUANTITY),
98: decode( p_PLANNING_TYPE_CODE, FND_API.G_MISS_NUM, NULL, p_PLANNING_TYPE_CODE),
99: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
100: decode( p_REVISION, FND_API.G_MISS_CHAR, NULL, p_REVISION),

Line 97: decode( p_TOTAL_LOOP_MIN_GOOD_QUANTITY, FND_API.G_MISS_NUM, NULL, p_TOTAL_LOOP_MIN_GOOD_QUANTITY),

93: decode( p_PLANNER_CODE, FND_API.G_MISS_CHAR, NULL, p_PLANNER_CODE),
94: decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID),
95: decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_ORGANIZATION_ID),
96: decode( p_TOTAL_LOOP_QUANTITY, FND_API.G_MISS_NUM, NULL, p_TOTAL_LOOP_QUANTITY),
97: decode( p_TOTAL_LOOP_MIN_GOOD_QUANTITY, FND_API.G_MISS_NUM, NULL, p_TOTAL_LOOP_MIN_GOOD_QUANTITY),
98: decode( p_PLANNING_TYPE_CODE, FND_API.G_MISS_NUM, NULL, p_PLANNING_TYPE_CODE),
99: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
100: decode( p_REVISION, FND_API.G_MISS_CHAR, NULL, p_REVISION),
101: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),

Line 98: decode( p_PLANNING_TYPE_CODE, FND_API.G_MISS_NUM, NULL, p_PLANNING_TYPE_CODE),

94: decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID),
95: decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_ORGANIZATION_ID),
96: decode( p_TOTAL_LOOP_QUANTITY, FND_API.G_MISS_NUM, NULL, p_TOTAL_LOOP_QUANTITY),
97: decode( p_TOTAL_LOOP_MIN_GOOD_QUANTITY, FND_API.G_MISS_NUM, NULL, p_TOTAL_LOOP_MIN_GOOD_QUANTITY),
98: decode( p_PLANNING_TYPE_CODE, FND_API.G_MISS_NUM, NULL, p_PLANNING_TYPE_CODE),
99: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
100: decode( p_REVISION, FND_API.G_MISS_CHAR, NULL, p_REVISION),
101: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
102: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),

Line 99: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),

95: decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_ORGANIZATION_ID),
96: decode( p_TOTAL_LOOP_QUANTITY, FND_API.G_MISS_NUM, NULL, p_TOTAL_LOOP_QUANTITY),
97: decode( p_TOTAL_LOOP_MIN_GOOD_QUANTITY, FND_API.G_MISS_NUM, NULL, p_TOTAL_LOOP_MIN_GOOD_QUANTITY),
98: decode( p_PLANNING_TYPE_CODE, FND_API.G_MISS_NUM, NULL, p_PLANNING_TYPE_CODE),
99: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
100: decode( p_REVISION, FND_API.G_MISS_CHAR, NULL, p_REVISION),
101: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
102: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
103: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),

Line 100: decode( p_REVISION, FND_API.G_MISS_CHAR, NULL, p_REVISION),

96: decode( p_TOTAL_LOOP_QUANTITY, FND_API.G_MISS_NUM, NULL, p_TOTAL_LOOP_QUANTITY),
97: decode( p_TOTAL_LOOP_MIN_GOOD_QUANTITY, FND_API.G_MISS_NUM, NULL, p_TOTAL_LOOP_MIN_GOOD_QUANTITY),
98: decode( p_PLANNING_TYPE_CODE, FND_API.G_MISS_NUM, NULL, p_PLANNING_TYPE_CODE),
99: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
100: decode( p_REVISION, FND_API.G_MISS_CHAR, NULL, p_REVISION),
101: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
102: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
103: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
104: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),

Line 101: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),

97: decode( p_TOTAL_LOOP_MIN_GOOD_QUANTITY, FND_API.G_MISS_NUM, NULL, p_TOTAL_LOOP_MIN_GOOD_QUANTITY),
98: decode( p_PLANNING_TYPE_CODE, FND_API.G_MISS_NUM, NULL, p_PLANNING_TYPE_CODE),
99: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
100: decode( p_REVISION, FND_API.G_MISS_CHAR, NULL, p_REVISION),
101: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
102: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
103: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
104: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
105: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),

Line 102: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),

98: decode( p_PLANNING_TYPE_CODE, FND_API.G_MISS_NUM, NULL, p_PLANNING_TYPE_CODE),
99: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
100: decode( p_REVISION, FND_API.G_MISS_CHAR, NULL, p_REVISION),
101: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
102: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
103: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
104: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
105: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
106: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),

Line 103: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),

99: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
100: decode( p_REVISION, FND_API.G_MISS_CHAR, NULL, p_REVISION),
101: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
102: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
103: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
104: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
105: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
106: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
107: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),

Line 104: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),

100: decode( p_REVISION, FND_API.G_MISS_CHAR, NULL, p_REVISION),
101: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
102: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
103: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
104: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
105: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
106: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
107: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
108: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),

Line 105: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),

101: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
102: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
103: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
104: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
105: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
106: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
107: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
108: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
109: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),

Line 106: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),

102: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
103: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
104: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
105: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
106: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
107: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
108: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
109: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
110: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),

Line 107: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),

103: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
104: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
105: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
106: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
107: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
108: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
109: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
110: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
111: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),

Line 108: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),

104: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
105: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
106: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
107: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
108: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
109: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
110: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
111: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
112: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),

Line 109: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),

105: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
106: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
107: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
108: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
109: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
110: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
111: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
112: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
113: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),

Line 110: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),

106: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
107: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
108: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
109: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
110: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
111: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
112: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
113: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
114: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),

Line 111: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),

107: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
108: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
109: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
110: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
111: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
112: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
113: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
114: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
115: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15));

Line 112: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),

108: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
109: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
110: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
111: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
112: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
113: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
114: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
115: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15));
116: End Insert_Row;

Line 113: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),

109: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
110: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
111: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
112: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
113: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
114: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
115: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15));
116: End Insert_Row;
117:

Line 114: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),

110: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
111: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
112: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
113: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
114: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
115: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15));
116: End Insert_Row;
117:
118: PROCEDURE Update_Row(

Line 115: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15));

111: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
112: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
113: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
114: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
115: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15));
116: End Insert_Row;
117:
118: PROCEDURE Update_Row(
119: p_MSL_ID NUMBER,

Line 154: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),

150: IS
151: BEGIN
152: Update CSP_MSTRSTCK_LISTS_ITMS
153: SET
154: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
155: CREATION_DATE = decode(p_CREATION_DATE, fnd_api.g_miss_date,creation_date,p_creation_date),
156: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
157: LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE,fnd_api.g_miss_date,last_update_date,p_last_update_date),
158: LAST_UPDATED_LOGIN = decode( p_LAST_UPDATED_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATED_LOGIN, p_LAST_UPDATED_LOGIN),

Line 155: CREATION_DATE = decode(p_CREATION_DATE, fnd_api.g_miss_date,creation_date,p_creation_date),

151: BEGIN
152: Update CSP_MSTRSTCK_LISTS_ITMS
153: SET
154: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
155: CREATION_DATE = decode(p_CREATION_DATE, fnd_api.g_miss_date,creation_date,p_creation_date),
156: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
157: LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE,fnd_api.g_miss_date,last_update_date,p_last_update_date),
158: LAST_UPDATED_LOGIN = decode( p_LAST_UPDATED_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATED_LOGIN, p_LAST_UPDATED_LOGIN),
159: PARTS_LOOPS_ID = decode( p_PARTS_LOOPS_ID, FND_API.G_MISS_NUM, PARTS_LOOPS_ID, p_PARTS_LOOPS_ID),

Line 156: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),

152: Update CSP_MSTRSTCK_LISTS_ITMS
153: SET
154: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
155: CREATION_DATE = decode(p_CREATION_DATE, fnd_api.g_miss_date,creation_date,p_creation_date),
156: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
157: LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE,fnd_api.g_miss_date,last_update_date,p_last_update_date),
158: LAST_UPDATED_LOGIN = decode( p_LAST_UPDATED_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATED_LOGIN, p_LAST_UPDATED_LOGIN),
159: PARTS_LOOPS_ID = decode( p_PARTS_LOOPS_ID, FND_API.G_MISS_NUM, PARTS_LOOPS_ID, p_PARTS_LOOPS_ID),
160: PLANNER_CODE = decode( p_PLANNER_CODE, FND_API.G_MISS_CHAR, PLANNER_CODE, p_PLANNER_CODE),

Line 157: LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE,fnd_api.g_miss_date,last_update_date,p_last_update_date),

153: SET
154: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
155: CREATION_DATE = decode(p_CREATION_DATE, fnd_api.g_miss_date,creation_date,p_creation_date),
156: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
157: LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE,fnd_api.g_miss_date,last_update_date,p_last_update_date),
158: LAST_UPDATED_LOGIN = decode( p_LAST_UPDATED_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATED_LOGIN, p_LAST_UPDATED_LOGIN),
159: PARTS_LOOPS_ID = decode( p_PARTS_LOOPS_ID, FND_API.G_MISS_NUM, PARTS_LOOPS_ID, p_PARTS_LOOPS_ID),
160: PLANNER_CODE = decode( p_PLANNER_CODE, FND_API.G_MISS_CHAR, PLANNER_CODE, p_PLANNER_CODE),
161: INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID),

Line 158: LAST_UPDATED_LOGIN = decode( p_LAST_UPDATED_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATED_LOGIN, p_LAST_UPDATED_LOGIN),

154: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
155: CREATION_DATE = decode(p_CREATION_DATE, fnd_api.g_miss_date,creation_date,p_creation_date),
156: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
157: LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE,fnd_api.g_miss_date,last_update_date,p_last_update_date),
158: LAST_UPDATED_LOGIN = decode( p_LAST_UPDATED_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATED_LOGIN, p_LAST_UPDATED_LOGIN),
159: PARTS_LOOPS_ID = decode( p_PARTS_LOOPS_ID, FND_API.G_MISS_NUM, PARTS_LOOPS_ID, p_PARTS_LOOPS_ID),
160: PLANNER_CODE = decode( p_PLANNER_CODE, FND_API.G_MISS_CHAR, PLANNER_CODE, p_PLANNER_CODE),
161: INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID),
162: ORGANIZATION_ID = decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, ORGANIZATION_ID, p_ORGANIZATION_ID),

Line 159: PARTS_LOOPS_ID = decode( p_PARTS_LOOPS_ID, FND_API.G_MISS_NUM, PARTS_LOOPS_ID, p_PARTS_LOOPS_ID),

155: CREATION_DATE = decode(p_CREATION_DATE, fnd_api.g_miss_date,creation_date,p_creation_date),
156: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
157: LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE,fnd_api.g_miss_date,last_update_date,p_last_update_date),
158: LAST_UPDATED_LOGIN = decode( p_LAST_UPDATED_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATED_LOGIN, p_LAST_UPDATED_LOGIN),
159: PARTS_LOOPS_ID = decode( p_PARTS_LOOPS_ID, FND_API.G_MISS_NUM, PARTS_LOOPS_ID, p_PARTS_LOOPS_ID),
160: PLANNER_CODE = decode( p_PLANNER_CODE, FND_API.G_MISS_CHAR, PLANNER_CODE, p_PLANNER_CODE),
161: INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID),
162: ORGANIZATION_ID = decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, ORGANIZATION_ID, p_ORGANIZATION_ID),
163: TOTAL_LOOP_QUANTITY = decode( p_TOTAL_LOOP_QUANTITY, FND_API.G_MISS_NUM, TOTAL_LOOP_QUANTITY, p_TOTAL_LOOP_QUANTITY),

Line 160: PLANNER_CODE = decode( p_PLANNER_CODE, FND_API.G_MISS_CHAR, PLANNER_CODE, p_PLANNER_CODE),

156: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
157: LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE,fnd_api.g_miss_date,last_update_date,p_last_update_date),
158: LAST_UPDATED_LOGIN = decode( p_LAST_UPDATED_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATED_LOGIN, p_LAST_UPDATED_LOGIN),
159: PARTS_LOOPS_ID = decode( p_PARTS_LOOPS_ID, FND_API.G_MISS_NUM, PARTS_LOOPS_ID, p_PARTS_LOOPS_ID),
160: PLANNER_CODE = decode( p_PLANNER_CODE, FND_API.G_MISS_CHAR, PLANNER_CODE, p_PLANNER_CODE),
161: INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID),
162: ORGANIZATION_ID = decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, ORGANIZATION_ID, p_ORGANIZATION_ID),
163: TOTAL_LOOP_QUANTITY = decode( p_TOTAL_LOOP_QUANTITY, FND_API.G_MISS_NUM, TOTAL_LOOP_QUANTITY, p_TOTAL_LOOP_QUANTITY),
164: TOTAL_LOOP_MIN_GOOD_QUANTITY = decode( p_TOTAL_LOOP_MIN_GOOD_QUANTITY, FND_API.G_MISS_NUM, TOTAL_LOOP_MIN_GOOD_QUANTITY, p_TOTAL_LOOP_MIN_GOOD_QUANTITY),

Line 161: INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID),

157: LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE,fnd_api.g_miss_date,last_update_date,p_last_update_date),
158: LAST_UPDATED_LOGIN = decode( p_LAST_UPDATED_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATED_LOGIN, p_LAST_UPDATED_LOGIN),
159: PARTS_LOOPS_ID = decode( p_PARTS_LOOPS_ID, FND_API.G_MISS_NUM, PARTS_LOOPS_ID, p_PARTS_LOOPS_ID),
160: PLANNER_CODE = decode( p_PLANNER_CODE, FND_API.G_MISS_CHAR, PLANNER_CODE, p_PLANNER_CODE),
161: INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID),
162: ORGANIZATION_ID = decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, ORGANIZATION_ID, p_ORGANIZATION_ID),
163: TOTAL_LOOP_QUANTITY = decode( p_TOTAL_LOOP_QUANTITY, FND_API.G_MISS_NUM, TOTAL_LOOP_QUANTITY, p_TOTAL_LOOP_QUANTITY),
164: TOTAL_LOOP_MIN_GOOD_QUANTITY = decode( p_TOTAL_LOOP_MIN_GOOD_QUANTITY, FND_API.G_MISS_NUM, TOTAL_LOOP_MIN_GOOD_QUANTITY, p_TOTAL_LOOP_MIN_GOOD_QUANTITY),
165: PLANNING_TYPE_CODE = decode( p_PLANNING_TYPE_CODE, FND_API.G_MISS_NUM, PLANNING_TYPE_CODE, p_PLANNING_TYPE_CODE),

Line 162: ORGANIZATION_ID = decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, ORGANIZATION_ID, p_ORGANIZATION_ID),

158: LAST_UPDATED_LOGIN = decode( p_LAST_UPDATED_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATED_LOGIN, p_LAST_UPDATED_LOGIN),
159: PARTS_LOOPS_ID = decode( p_PARTS_LOOPS_ID, FND_API.G_MISS_NUM, PARTS_LOOPS_ID, p_PARTS_LOOPS_ID),
160: PLANNER_CODE = decode( p_PLANNER_CODE, FND_API.G_MISS_CHAR, PLANNER_CODE, p_PLANNER_CODE),
161: INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID),
162: ORGANIZATION_ID = decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, ORGANIZATION_ID, p_ORGANIZATION_ID),
163: TOTAL_LOOP_QUANTITY = decode( p_TOTAL_LOOP_QUANTITY, FND_API.G_MISS_NUM, TOTAL_LOOP_QUANTITY, p_TOTAL_LOOP_QUANTITY),
164: TOTAL_LOOP_MIN_GOOD_QUANTITY = decode( p_TOTAL_LOOP_MIN_GOOD_QUANTITY, FND_API.G_MISS_NUM, TOTAL_LOOP_MIN_GOOD_QUANTITY, p_TOTAL_LOOP_MIN_GOOD_QUANTITY),
165: PLANNING_TYPE_CODE = decode( p_PLANNING_TYPE_CODE, FND_API.G_MISS_NUM, PLANNING_TYPE_CODE, p_PLANNING_TYPE_CODE),
166: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),

Line 163: TOTAL_LOOP_QUANTITY = decode( p_TOTAL_LOOP_QUANTITY, FND_API.G_MISS_NUM, TOTAL_LOOP_QUANTITY, p_TOTAL_LOOP_QUANTITY),

159: PARTS_LOOPS_ID = decode( p_PARTS_LOOPS_ID, FND_API.G_MISS_NUM, PARTS_LOOPS_ID, p_PARTS_LOOPS_ID),
160: PLANNER_CODE = decode( p_PLANNER_CODE, FND_API.G_MISS_CHAR, PLANNER_CODE, p_PLANNER_CODE),
161: INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID),
162: ORGANIZATION_ID = decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, ORGANIZATION_ID, p_ORGANIZATION_ID),
163: TOTAL_LOOP_QUANTITY = decode( p_TOTAL_LOOP_QUANTITY, FND_API.G_MISS_NUM, TOTAL_LOOP_QUANTITY, p_TOTAL_LOOP_QUANTITY),
164: TOTAL_LOOP_MIN_GOOD_QUANTITY = decode( p_TOTAL_LOOP_MIN_GOOD_QUANTITY, FND_API.G_MISS_NUM, TOTAL_LOOP_MIN_GOOD_QUANTITY, p_TOTAL_LOOP_MIN_GOOD_QUANTITY),
165: PLANNING_TYPE_CODE = decode( p_PLANNING_TYPE_CODE, FND_API.G_MISS_NUM, PLANNING_TYPE_CODE, p_PLANNING_TYPE_CODE),
166: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
167: REVISION = decode( p_REVISION, FND_API.G_MISS_CHAR, REVISION, p_REVISION),

Line 164: TOTAL_LOOP_MIN_GOOD_QUANTITY = decode( p_TOTAL_LOOP_MIN_GOOD_QUANTITY, FND_API.G_MISS_NUM, TOTAL_LOOP_MIN_GOOD_QUANTITY, p_TOTAL_LOOP_MIN_GOOD_QUANTITY),

160: PLANNER_CODE = decode( p_PLANNER_CODE, FND_API.G_MISS_CHAR, PLANNER_CODE, p_PLANNER_CODE),
161: INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID),
162: ORGANIZATION_ID = decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, ORGANIZATION_ID, p_ORGANIZATION_ID),
163: TOTAL_LOOP_QUANTITY = decode( p_TOTAL_LOOP_QUANTITY, FND_API.G_MISS_NUM, TOTAL_LOOP_QUANTITY, p_TOTAL_LOOP_QUANTITY),
164: TOTAL_LOOP_MIN_GOOD_QUANTITY = decode( p_TOTAL_LOOP_MIN_GOOD_QUANTITY, FND_API.G_MISS_NUM, TOTAL_LOOP_MIN_GOOD_QUANTITY, p_TOTAL_LOOP_MIN_GOOD_QUANTITY),
165: PLANNING_TYPE_CODE = decode( p_PLANNING_TYPE_CODE, FND_API.G_MISS_NUM, PLANNING_TYPE_CODE, p_PLANNING_TYPE_CODE),
166: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
167: REVISION = decode( p_REVISION, FND_API.G_MISS_CHAR, REVISION, p_REVISION),
168: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),

Line 165: PLANNING_TYPE_CODE = decode( p_PLANNING_TYPE_CODE, FND_API.G_MISS_NUM, PLANNING_TYPE_CODE, p_PLANNING_TYPE_CODE),

161: INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID),
162: ORGANIZATION_ID = decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, ORGANIZATION_ID, p_ORGANIZATION_ID),
163: TOTAL_LOOP_QUANTITY = decode( p_TOTAL_LOOP_QUANTITY, FND_API.G_MISS_NUM, TOTAL_LOOP_QUANTITY, p_TOTAL_LOOP_QUANTITY),
164: TOTAL_LOOP_MIN_GOOD_QUANTITY = decode( p_TOTAL_LOOP_MIN_GOOD_QUANTITY, FND_API.G_MISS_NUM, TOTAL_LOOP_MIN_GOOD_QUANTITY, p_TOTAL_LOOP_MIN_GOOD_QUANTITY),
165: PLANNING_TYPE_CODE = decode( p_PLANNING_TYPE_CODE, FND_API.G_MISS_NUM, PLANNING_TYPE_CODE, p_PLANNING_TYPE_CODE),
166: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
167: REVISION = decode( p_REVISION, FND_API.G_MISS_CHAR, REVISION, p_REVISION),
168: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
169: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),

Line 166: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),

162: ORGANIZATION_ID = decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, ORGANIZATION_ID, p_ORGANIZATION_ID),
163: TOTAL_LOOP_QUANTITY = decode( p_TOTAL_LOOP_QUANTITY, FND_API.G_MISS_NUM, TOTAL_LOOP_QUANTITY, p_TOTAL_LOOP_QUANTITY),
164: TOTAL_LOOP_MIN_GOOD_QUANTITY = decode( p_TOTAL_LOOP_MIN_GOOD_QUANTITY, FND_API.G_MISS_NUM, TOTAL_LOOP_MIN_GOOD_QUANTITY, p_TOTAL_LOOP_MIN_GOOD_QUANTITY),
165: PLANNING_TYPE_CODE = decode( p_PLANNING_TYPE_CODE, FND_API.G_MISS_NUM, PLANNING_TYPE_CODE, p_PLANNING_TYPE_CODE),
166: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
167: REVISION = decode( p_REVISION, FND_API.G_MISS_CHAR, REVISION, p_REVISION),
168: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
169: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
170: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),

Line 167: REVISION = decode( p_REVISION, FND_API.G_MISS_CHAR, REVISION, p_REVISION),

163: TOTAL_LOOP_QUANTITY = decode( p_TOTAL_LOOP_QUANTITY, FND_API.G_MISS_NUM, TOTAL_LOOP_QUANTITY, p_TOTAL_LOOP_QUANTITY),
164: TOTAL_LOOP_MIN_GOOD_QUANTITY = decode( p_TOTAL_LOOP_MIN_GOOD_QUANTITY, FND_API.G_MISS_NUM, TOTAL_LOOP_MIN_GOOD_QUANTITY, p_TOTAL_LOOP_MIN_GOOD_QUANTITY),
165: PLANNING_TYPE_CODE = decode( p_PLANNING_TYPE_CODE, FND_API.G_MISS_NUM, PLANNING_TYPE_CODE, p_PLANNING_TYPE_CODE),
166: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
167: REVISION = decode( p_REVISION, FND_API.G_MISS_CHAR, REVISION, p_REVISION),
168: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
169: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
170: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
171: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),

Line 168: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),

164: TOTAL_LOOP_MIN_GOOD_QUANTITY = decode( p_TOTAL_LOOP_MIN_GOOD_QUANTITY, FND_API.G_MISS_NUM, TOTAL_LOOP_MIN_GOOD_QUANTITY, p_TOTAL_LOOP_MIN_GOOD_QUANTITY),
165: PLANNING_TYPE_CODE = decode( p_PLANNING_TYPE_CODE, FND_API.G_MISS_NUM, PLANNING_TYPE_CODE, p_PLANNING_TYPE_CODE),
166: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
167: REVISION = decode( p_REVISION, FND_API.G_MISS_CHAR, REVISION, p_REVISION),
168: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
169: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
170: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
171: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
172: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),

Line 169: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),

165: PLANNING_TYPE_CODE = decode( p_PLANNING_TYPE_CODE, FND_API.G_MISS_NUM, PLANNING_TYPE_CODE, p_PLANNING_TYPE_CODE),
166: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
167: REVISION = decode( p_REVISION, FND_API.G_MISS_CHAR, REVISION, p_REVISION),
168: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
169: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
170: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
171: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
172: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
173: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),

Line 170: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),

166: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
167: REVISION = decode( p_REVISION, FND_API.G_MISS_CHAR, REVISION, p_REVISION),
168: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
169: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
170: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
171: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
172: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
173: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
174: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),

Line 171: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),

167: REVISION = decode( p_REVISION, FND_API.G_MISS_CHAR, REVISION, p_REVISION),
168: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
169: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
170: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
171: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
172: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
173: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
174: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
175: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),

Line 172: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),

168: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
169: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
170: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
171: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
172: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
173: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
174: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
175: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
176: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),

Line 173: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),

169: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
170: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
171: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
172: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
173: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
174: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
175: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
176: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
177: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),

Line 174: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),

170: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
171: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
172: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
173: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
174: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
175: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
176: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
177: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
178: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),

Line 175: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),

171: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
172: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
173: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
174: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
175: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
176: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
177: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
178: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
179: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),

Line 176: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),

172: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
173: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
174: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
175: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
176: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
177: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
178: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
179: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
180: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),

Line 177: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),

173: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
174: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
175: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
176: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
177: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
178: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
179: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
180: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
181: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),

Line 178: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),

174: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
175: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
176: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
177: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
178: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
179: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
180: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
181: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
182: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15)

Line 179: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),

175: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
176: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
177: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
178: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
179: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
180: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
181: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
182: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15)
183: where MSL_ID = p_MSL_ID;

Line 180: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),

176: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
177: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
178: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
179: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
180: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
181: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
182: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15)
183: where MSL_ID = p_MSL_ID;
184:

Line 181: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),

177: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
178: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
179: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
180: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
181: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
182: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15)
183: where MSL_ID = p_MSL_ID;
184:
185: If (SQL%NOTFOUND) then

Line 182: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15)

178: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
179: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
180: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
181: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
182: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15)
183: where MSL_ID = p_MSL_ID;
184:
185: If (SQL%NOTFOUND) then
186: RAISE NO_DATA_FOUND;