eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_XPRT_IMPORT_TEMPLATE_PVT dependencies on CZ_IMP_DEVL_PROJECT

Line 89: l_cz_imp_devl_project_rec CZ_IMP_DEVL_PROJECT%ROWTYPE;

85: x_msg_data OUT NOCOPY VARCHAR2,
86: x_msg_count OUT NOCOPY NUMBER
87: ) IS
88:
89: l_cz_imp_devl_project_rec CZ_IMP_DEVL_PROJECT%ROWTYPE;
90: l_api_name CONSTANT VARCHAR2(30) := 'create_template_model';
91:
92:
93: BEGIN

Line 106: -- populate the l_cz_imp_devl_project_rec

102: x_return_status := G_RET_STS_SUCCESS;
103:
104:
105:
106: -- populate the l_cz_imp_devl_project_rec
107: l_cz_imp_devl_project_rec.DEVL_PROJECT_ID:= NULL;
108: l_cz_imp_devl_project_rec.INTL_TEXT_ID:= NULL;
109: l_cz_imp_devl_project_rec.ORGANIZATION_ID:= p_org_id;
110: l_cz_imp_devl_project_rec.NAME:= G_TEMPLATE_MODEL_OSR||

Line 107: l_cz_imp_devl_project_rec.DEVL_PROJECT_ID:= NULL;

103:
104:
105:
106: -- populate the l_cz_imp_devl_project_rec
107: l_cz_imp_devl_project_rec.DEVL_PROJECT_ID:= NULL;
108: l_cz_imp_devl_project_rec.INTL_TEXT_ID:= NULL;
109: l_cz_imp_devl_project_rec.ORGANIZATION_ID:= p_org_id;
110: l_cz_imp_devl_project_rec.NAME:= G_TEMPLATE_MODEL_OSR||
111: p_org_id||':'||

Line 108: l_cz_imp_devl_project_rec.INTL_TEXT_ID:= NULL;

104:
105:
106: -- populate the l_cz_imp_devl_project_rec
107: l_cz_imp_devl_project_rec.DEVL_PROJECT_ID:= NULL;
108: l_cz_imp_devl_project_rec.INTL_TEXT_ID:= NULL;
109: l_cz_imp_devl_project_rec.ORGANIZATION_ID:= p_org_id;
110: l_cz_imp_devl_project_rec.NAME:= G_TEMPLATE_MODEL_OSR||
111: p_org_id||':'||
112: p_intent||':'||

Line 109: l_cz_imp_devl_project_rec.ORGANIZATION_ID:= p_org_id;

105:
106: -- populate the l_cz_imp_devl_project_rec
107: l_cz_imp_devl_project_rec.DEVL_PROJECT_ID:= NULL;
108: l_cz_imp_devl_project_rec.INTL_TEXT_ID:= NULL;
109: l_cz_imp_devl_project_rec.ORGANIZATION_ID:= p_org_id;
110: l_cz_imp_devl_project_rec.NAME:= G_TEMPLATE_MODEL_OSR||
111: p_org_id||':'||
112: p_intent||':'||
113: p_template_id;

Line 110: l_cz_imp_devl_project_rec.NAME:= G_TEMPLATE_MODEL_OSR||

106: -- populate the l_cz_imp_devl_project_rec
107: l_cz_imp_devl_project_rec.DEVL_PROJECT_ID:= NULL;
108: l_cz_imp_devl_project_rec.INTL_TEXT_ID:= NULL;
109: l_cz_imp_devl_project_rec.ORGANIZATION_ID:= p_org_id;
110: l_cz_imp_devl_project_rec.NAME:= G_TEMPLATE_MODEL_OSR||
111: p_org_id||':'||
112: p_intent||':'||
113: p_template_id;
114: l_cz_imp_devl_project_rec.GSL_FILENAME:= NULL;

Line 114: l_cz_imp_devl_project_rec.GSL_FILENAME:= NULL;

110: l_cz_imp_devl_project_rec.NAME:= G_TEMPLATE_MODEL_OSR||
111: p_org_id||':'||
112: p_intent||':'||
113: p_template_id;
114: l_cz_imp_devl_project_rec.GSL_FILENAME:= NULL;
115: l_cz_imp_devl_project_rec.TOP_ITEM_ID:= 1;
116: l_cz_imp_devl_project_rec.VERSION:= NULL;
117: l_cz_imp_devl_project_rec.EXPLOSION_TYPE:= NULL;
118: l_cz_imp_devl_project_rec.DESC_TEXT:= p_template_name;

Line 115: l_cz_imp_devl_project_rec.TOP_ITEM_ID:= 1;

111: p_org_id||':'||
112: p_intent||':'||
113: p_template_id;
114: l_cz_imp_devl_project_rec.GSL_FILENAME:= NULL;
115: l_cz_imp_devl_project_rec.TOP_ITEM_ID:= 1;
116: l_cz_imp_devl_project_rec.VERSION:= NULL;
117: l_cz_imp_devl_project_rec.EXPLOSION_TYPE:= NULL;
118: l_cz_imp_devl_project_rec.DESC_TEXT:= p_template_name;
119: l_cz_imp_devl_project_rec.ORIG_SYS_REF:= G_TEMPLATE_MODEL_OSR||

Line 116: l_cz_imp_devl_project_rec.VERSION:= NULL;

112: p_intent||':'||
113: p_template_id;
114: l_cz_imp_devl_project_rec.GSL_FILENAME:= NULL;
115: l_cz_imp_devl_project_rec.TOP_ITEM_ID:= 1;
116: l_cz_imp_devl_project_rec.VERSION:= NULL;
117: l_cz_imp_devl_project_rec.EXPLOSION_TYPE:= NULL;
118: l_cz_imp_devl_project_rec.DESC_TEXT:= p_template_name;
119: l_cz_imp_devl_project_rec.ORIG_SYS_REF:= G_TEMPLATE_MODEL_OSR||
120: p_org_id||':'||

Line 117: l_cz_imp_devl_project_rec.EXPLOSION_TYPE:= NULL;

113: p_template_id;
114: l_cz_imp_devl_project_rec.GSL_FILENAME:= NULL;
115: l_cz_imp_devl_project_rec.TOP_ITEM_ID:= 1;
116: l_cz_imp_devl_project_rec.VERSION:= NULL;
117: l_cz_imp_devl_project_rec.EXPLOSION_TYPE:= NULL;
118: l_cz_imp_devl_project_rec.DESC_TEXT:= p_template_name;
119: l_cz_imp_devl_project_rec.ORIG_SYS_REF:= G_TEMPLATE_MODEL_OSR||
120: p_org_id||':'||
121: p_intent||':'||

Line 118: l_cz_imp_devl_project_rec.DESC_TEXT:= p_template_name;

114: l_cz_imp_devl_project_rec.GSL_FILENAME:= NULL;
115: l_cz_imp_devl_project_rec.TOP_ITEM_ID:= 1;
116: l_cz_imp_devl_project_rec.VERSION:= NULL;
117: l_cz_imp_devl_project_rec.EXPLOSION_TYPE:= NULL;
118: l_cz_imp_devl_project_rec.DESC_TEXT:= p_template_name;
119: l_cz_imp_devl_project_rec.ORIG_SYS_REF:= G_TEMPLATE_MODEL_OSR||
120: p_org_id||':'||
121: p_intent||':'||
122: p_template_id;

Line 119: l_cz_imp_devl_project_rec.ORIG_SYS_REF:= G_TEMPLATE_MODEL_OSR||

115: l_cz_imp_devl_project_rec.TOP_ITEM_ID:= 1;
116: l_cz_imp_devl_project_rec.VERSION:= NULL;
117: l_cz_imp_devl_project_rec.EXPLOSION_TYPE:= NULL;
118: l_cz_imp_devl_project_rec.DESC_TEXT:= p_template_name;
119: l_cz_imp_devl_project_rec.ORIG_SYS_REF:= G_TEMPLATE_MODEL_OSR||
120: p_org_id||':'||
121: p_intent||':'||
122: p_template_id;
123: l_cz_imp_devl_project_rec.CREATION_DATE:= SYSDATE;

Line 123: l_cz_imp_devl_project_rec.CREATION_DATE:= SYSDATE;

119: l_cz_imp_devl_project_rec.ORIG_SYS_REF:= G_TEMPLATE_MODEL_OSR||
120: p_org_id||':'||
121: p_intent||':'||
122: p_template_id;
123: l_cz_imp_devl_project_rec.CREATION_DATE:= SYSDATE;
124: l_cz_imp_devl_project_rec.LAST_UPDATE_DATE:= SYSDATE;
125: l_cz_imp_devl_project_rec.DELETED_FLAG:= '0'; -- '0' Not deleted
126: l_cz_imp_devl_project_rec.EFF_FROM:= NULL;
127: l_cz_imp_devl_project_rec.EFF_TO:= NULL;

Line 124: l_cz_imp_devl_project_rec.LAST_UPDATE_DATE:= SYSDATE;

120: p_org_id||':'||
121: p_intent||':'||
122: p_template_id;
123: l_cz_imp_devl_project_rec.CREATION_DATE:= SYSDATE;
124: l_cz_imp_devl_project_rec.LAST_UPDATE_DATE:= SYSDATE;
125: l_cz_imp_devl_project_rec.DELETED_FLAG:= '0'; -- '0' Not deleted
126: l_cz_imp_devl_project_rec.EFF_FROM:= NULL;
127: l_cz_imp_devl_project_rec.EFF_TO:= NULL;
128: l_cz_imp_devl_project_rec.CREATED_BY:= FND_GLOBAL.USER_ID;

Line 125: l_cz_imp_devl_project_rec.DELETED_FLAG:= '0'; -- '0' Not deleted

121: p_intent||':'||
122: p_template_id;
123: l_cz_imp_devl_project_rec.CREATION_DATE:= SYSDATE;
124: l_cz_imp_devl_project_rec.LAST_UPDATE_DATE:= SYSDATE;
125: l_cz_imp_devl_project_rec.DELETED_FLAG:= '0'; -- '0' Not deleted
126: l_cz_imp_devl_project_rec.EFF_FROM:= NULL;
127: l_cz_imp_devl_project_rec.EFF_TO:= NULL;
128: l_cz_imp_devl_project_rec.CREATED_BY:= FND_GLOBAL.USER_ID;
129: l_cz_imp_devl_project_rec.LAST_UPDATED_BY:= FND_GLOBAL.USER_ID;

Line 126: l_cz_imp_devl_project_rec.EFF_FROM:= NULL;

122: p_template_id;
123: l_cz_imp_devl_project_rec.CREATION_DATE:= SYSDATE;
124: l_cz_imp_devl_project_rec.LAST_UPDATE_DATE:= SYSDATE;
125: l_cz_imp_devl_project_rec.DELETED_FLAG:= '0'; -- '0' Not deleted
126: l_cz_imp_devl_project_rec.EFF_FROM:= NULL;
127: l_cz_imp_devl_project_rec.EFF_TO:= NULL;
128: l_cz_imp_devl_project_rec.CREATED_BY:= FND_GLOBAL.USER_ID;
129: l_cz_imp_devl_project_rec.LAST_UPDATED_BY:= FND_GLOBAL.USER_ID;
130: l_cz_imp_devl_project_rec.SECURITY_MASK:= NULL;

Line 127: l_cz_imp_devl_project_rec.EFF_TO:= NULL;

123: l_cz_imp_devl_project_rec.CREATION_DATE:= SYSDATE;
124: l_cz_imp_devl_project_rec.LAST_UPDATE_DATE:= SYSDATE;
125: l_cz_imp_devl_project_rec.DELETED_FLAG:= '0'; -- '0' Not deleted
126: l_cz_imp_devl_project_rec.EFF_FROM:= NULL;
127: l_cz_imp_devl_project_rec.EFF_TO:= NULL;
128: l_cz_imp_devl_project_rec.CREATED_BY:= FND_GLOBAL.USER_ID;
129: l_cz_imp_devl_project_rec.LAST_UPDATED_BY:= FND_GLOBAL.USER_ID;
130: l_cz_imp_devl_project_rec.SECURITY_MASK:= NULL;
131: l_cz_imp_devl_project_rec.EFF_MASK:= NULL;

Line 128: l_cz_imp_devl_project_rec.CREATED_BY:= FND_GLOBAL.USER_ID;

124: l_cz_imp_devl_project_rec.LAST_UPDATE_DATE:= SYSDATE;
125: l_cz_imp_devl_project_rec.DELETED_FLAG:= '0'; -- '0' Not deleted
126: l_cz_imp_devl_project_rec.EFF_FROM:= NULL;
127: l_cz_imp_devl_project_rec.EFF_TO:= NULL;
128: l_cz_imp_devl_project_rec.CREATED_BY:= FND_GLOBAL.USER_ID;
129: l_cz_imp_devl_project_rec.LAST_UPDATED_BY:= FND_GLOBAL.USER_ID;
130: l_cz_imp_devl_project_rec.SECURITY_MASK:= NULL;
131: l_cz_imp_devl_project_rec.EFF_MASK:= NULL;
132: l_cz_imp_devl_project_rec.CHECKOUT_USER:= NULL;

Line 129: l_cz_imp_devl_project_rec.LAST_UPDATED_BY:= FND_GLOBAL.USER_ID;

125: l_cz_imp_devl_project_rec.DELETED_FLAG:= '0'; -- '0' Not deleted
126: l_cz_imp_devl_project_rec.EFF_FROM:= NULL;
127: l_cz_imp_devl_project_rec.EFF_TO:= NULL;
128: l_cz_imp_devl_project_rec.CREATED_BY:= FND_GLOBAL.USER_ID;
129: l_cz_imp_devl_project_rec.LAST_UPDATED_BY:= FND_GLOBAL.USER_ID;
130: l_cz_imp_devl_project_rec.SECURITY_MASK:= NULL;
131: l_cz_imp_devl_project_rec.EFF_MASK:= NULL;
132: l_cz_imp_devl_project_rec.CHECKOUT_USER:= NULL;
133: l_cz_imp_devl_project_rec.RUN_ID:= G_RUN_ID;

Line 130: l_cz_imp_devl_project_rec.SECURITY_MASK:= NULL;

126: l_cz_imp_devl_project_rec.EFF_FROM:= NULL;
127: l_cz_imp_devl_project_rec.EFF_TO:= NULL;
128: l_cz_imp_devl_project_rec.CREATED_BY:= FND_GLOBAL.USER_ID;
129: l_cz_imp_devl_project_rec.LAST_UPDATED_BY:= FND_GLOBAL.USER_ID;
130: l_cz_imp_devl_project_rec.SECURITY_MASK:= NULL;
131: l_cz_imp_devl_project_rec.EFF_MASK:= NULL;
132: l_cz_imp_devl_project_rec.CHECKOUT_USER:= NULL;
133: l_cz_imp_devl_project_rec.RUN_ID:= G_RUN_ID;
134: l_cz_imp_devl_project_rec.REC_STATUS:= NULL;

Line 131: l_cz_imp_devl_project_rec.EFF_MASK:= NULL;

127: l_cz_imp_devl_project_rec.EFF_TO:= NULL;
128: l_cz_imp_devl_project_rec.CREATED_BY:= FND_GLOBAL.USER_ID;
129: l_cz_imp_devl_project_rec.LAST_UPDATED_BY:= FND_GLOBAL.USER_ID;
130: l_cz_imp_devl_project_rec.SECURITY_MASK:= NULL;
131: l_cz_imp_devl_project_rec.EFF_MASK:= NULL;
132: l_cz_imp_devl_project_rec.CHECKOUT_USER:= NULL;
133: l_cz_imp_devl_project_rec.RUN_ID:= G_RUN_ID;
134: l_cz_imp_devl_project_rec.REC_STATUS:= NULL;
135: l_cz_imp_devl_project_rec.DISPOSITION:= NULL;

Line 132: l_cz_imp_devl_project_rec.CHECKOUT_USER:= NULL;

128: l_cz_imp_devl_project_rec.CREATED_BY:= FND_GLOBAL.USER_ID;
129: l_cz_imp_devl_project_rec.LAST_UPDATED_BY:= FND_GLOBAL.USER_ID;
130: l_cz_imp_devl_project_rec.SECURITY_MASK:= NULL;
131: l_cz_imp_devl_project_rec.EFF_MASK:= NULL;
132: l_cz_imp_devl_project_rec.CHECKOUT_USER:= NULL;
133: l_cz_imp_devl_project_rec.RUN_ID:= G_RUN_ID;
134: l_cz_imp_devl_project_rec.REC_STATUS:= NULL;
135: l_cz_imp_devl_project_rec.DISPOSITION:= NULL;
136: l_cz_imp_devl_project_rec.FSK_INTLTEXT_1_1:= NULL;

Line 133: l_cz_imp_devl_project_rec.RUN_ID:= G_RUN_ID;

129: l_cz_imp_devl_project_rec.LAST_UPDATED_BY:= FND_GLOBAL.USER_ID;
130: l_cz_imp_devl_project_rec.SECURITY_MASK:= NULL;
131: l_cz_imp_devl_project_rec.EFF_MASK:= NULL;
132: l_cz_imp_devl_project_rec.CHECKOUT_USER:= NULL;
133: l_cz_imp_devl_project_rec.RUN_ID:= G_RUN_ID;
134: l_cz_imp_devl_project_rec.REC_STATUS:= NULL;
135: l_cz_imp_devl_project_rec.DISPOSITION:= NULL;
136: l_cz_imp_devl_project_rec.FSK_INTLTEXT_1_1:= NULL;
137: l_cz_imp_devl_project_rec.MODEL_ID:= p_model_id;

Line 134: l_cz_imp_devl_project_rec.REC_STATUS:= NULL;

130: l_cz_imp_devl_project_rec.SECURITY_MASK:= NULL;
131: l_cz_imp_devl_project_rec.EFF_MASK:= NULL;
132: l_cz_imp_devl_project_rec.CHECKOUT_USER:= NULL;
133: l_cz_imp_devl_project_rec.RUN_ID:= G_RUN_ID;
134: l_cz_imp_devl_project_rec.REC_STATUS:= NULL;
135: l_cz_imp_devl_project_rec.DISPOSITION:= NULL;
136: l_cz_imp_devl_project_rec.FSK_INTLTEXT_1_1:= NULL;
137: l_cz_imp_devl_project_rec.MODEL_ID:= p_model_id;
138: l_cz_imp_devl_project_rec.PLAN_LEVEL:= 0;

Line 135: l_cz_imp_devl_project_rec.DISPOSITION:= NULL;

131: l_cz_imp_devl_project_rec.EFF_MASK:= NULL;
132: l_cz_imp_devl_project_rec.CHECKOUT_USER:= NULL;
133: l_cz_imp_devl_project_rec.RUN_ID:= G_RUN_ID;
134: l_cz_imp_devl_project_rec.REC_STATUS:= NULL;
135: l_cz_imp_devl_project_rec.DISPOSITION:= NULL;
136: l_cz_imp_devl_project_rec.FSK_INTLTEXT_1_1:= NULL;
137: l_cz_imp_devl_project_rec.MODEL_ID:= p_model_id;
138: l_cz_imp_devl_project_rec.PLAN_LEVEL:= 0;
139: l_cz_imp_devl_project_rec.PERSISTENT_PROJECT_ID:= NULL;

Line 136: l_cz_imp_devl_project_rec.FSK_INTLTEXT_1_1:= NULL;

132: l_cz_imp_devl_project_rec.CHECKOUT_USER:= NULL;
133: l_cz_imp_devl_project_rec.RUN_ID:= G_RUN_ID;
134: l_cz_imp_devl_project_rec.REC_STATUS:= NULL;
135: l_cz_imp_devl_project_rec.DISPOSITION:= NULL;
136: l_cz_imp_devl_project_rec.FSK_INTLTEXT_1_1:= NULL;
137: l_cz_imp_devl_project_rec.MODEL_ID:= p_model_id;
138: l_cz_imp_devl_project_rec.PLAN_LEVEL:= 0;
139: l_cz_imp_devl_project_rec.PERSISTENT_PROJECT_ID:= NULL;
140: l_cz_imp_devl_project_rec.MODEL_TYPE:= 'C'; -- non BOM Model

Line 137: l_cz_imp_devl_project_rec.MODEL_ID:= p_model_id;

133: l_cz_imp_devl_project_rec.RUN_ID:= G_RUN_ID;
134: l_cz_imp_devl_project_rec.REC_STATUS:= NULL;
135: l_cz_imp_devl_project_rec.DISPOSITION:= NULL;
136: l_cz_imp_devl_project_rec.FSK_INTLTEXT_1_1:= NULL;
137: l_cz_imp_devl_project_rec.MODEL_ID:= p_model_id;
138: l_cz_imp_devl_project_rec.PLAN_LEVEL:= 0;
139: l_cz_imp_devl_project_rec.PERSISTENT_PROJECT_ID:= NULL;
140: l_cz_imp_devl_project_rec.MODEL_TYPE:= 'C'; -- non BOM Model
141: l_cz_imp_devl_project_rec.INVENTORY_ITEM_ID:= NULL;

Line 138: l_cz_imp_devl_project_rec.PLAN_LEVEL:= 0;

134: l_cz_imp_devl_project_rec.REC_STATUS:= NULL;
135: l_cz_imp_devl_project_rec.DISPOSITION:= NULL;
136: l_cz_imp_devl_project_rec.FSK_INTLTEXT_1_1:= NULL;
137: l_cz_imp_devl_project_rec.MODEL_ID:= p_model_id;
138: l_cz_imp_devl_project_rec.PLAN_LEVEL:= 0;
139: l_cz_imp_devl_project_rec.PERSISTENT_PROJECT_ID:= NULL;
140: l_cz_imp_devl_project_rec.MODEL_TYPE:= 'C'; -- non BOM Model
141: l_cz_imp_devl_project_rec.INVENTORY_ITEM_ID:= NULL;
142: l_cz_imp_devl_project_rec.PRODUCT_KEY:= G_TEMPLATE_MODEL_OSR||

Line 139: l_cz_imp_devl_project_rec.PERSISTENT_PROJECT_ID:= NULL;

135: l_cz_imp_devl_project_rec.DISPOSITION:= NULL;
136: l_cz_imp_devl_project_rec.FSK_INTLTEXT_1_1:= NULL;
137: l_cz_imp_devl_project_rec.MODEL_ID:= p_model_id;
138: l_cz_imp_devl_project_rec.PLAN_LEVEL:= 0;
139: l_cz_imp_devl_project_rec.PERSISTENT_PROJECT_ID:= NULL;
140: l_cz_imp_devl_project_rec.MODEL_TYPE:= 'C'; -- non BOM Model
141: l_cz_imp_devl_project_rec.INVENTORY_ITEM_ID:= NULL;
142: l_cz_imp_devl_project_rec.PRODUCT_KEY:= G_TEMPLATE_MODEL_OSR||
143: p_org_id||':'||

Line 140: l_cz_imp_devl_project_rec.MODEL_TYPE:= 'C'; -- non BOM Model

136: l_cz_imp_devl_project_rec.FSK_INTLTEXT_1_1:= NULL;
137: l_cz_imp_devl_project_rec.MODEL_ID:= p_model_id;
138: l_cz_imp_devl_project_rec.PLAN_LEVEL:= 0;
139: l_cz_imp_devl_project_rec.PERSISTENT_PROJECT_ID:= NULL;
140: l_cz_imp_devl_project_rec.MODEL_TYPE:= 'C'; -- non BOM Model
141: l_cz_imp_devl_project_rec.INVENTORY_ITEM_ID:= NULL;
142: l_cz_imp_devl_project_rec.PRODUCT_KEY:= G_TEMPLATE_MODEL_OSR||
143: p_org_id||':'||
144: p_intent||':'||

Line 141: l_cz_imp_devl_project_rec.INVENTORY_ITEM_ID:= NULL;

137: l_cz_imp_devl_project_rec.MODEL_ID:= p_model_id;
138: l_cz_imp_devl_project_rec.PLAN_LEVEL:= 0;
139: l_cz_imp_devl_project_rec.PERSISTENT_PROJECT_ID:= NULL;
140: l_cz_imp_devl_project_rec.MODEL_TYPE:= 'C'; -- non BOM Model
141: l_cz_imp_devl_project_rec.INVENTORY_ITEM_ID:= NULL;
142: l_cz_imp_devl_project_rec.PRODUCT_KEY:= G_TEMPLATE_MODEL_OSR||
143: p_org_id||':'||
144: p_intent||':'||
145: p_template_id;

Line 142: l_cz_imp_devl_project_rec.PRODUCT_KEY:= G_TEMPLATE_MODEL_OSR||

138: l_cz_imp_devl_project_rec.PLAN_LEVEL:= 0;
139: l_cz_imp_devl_project_rec.PERSISTENT_PROJECT_ID:= NULL;
140: l_cz_imp_devl_project_rec.MODEL_TYPE:= 'C'; -- non BOM Model
141: l_cz_imp_devl_project_rec.INVENTORY_ITEM_ID:= NULL;
142: l_cz_imp_devl_project_rec.PRODUCT_KEY:= G_TEMPLATE_MODEL_OSR||
143: p_org_id||':'||
144: p_intent||':'||
145: p_template_id;
146: l_cz_imp_devl_project_rec.LAST_UPDATE_LOGIN:= FND_GLOBAL.LOGIN_ID;

Line 146: l_cz_imp_devl_project_rec.LAST_UPDATE_LOGIN:= FND_GLOBAL.LOGIN_ID;

142: l_cz_imp_devl_project_rec.PRODUCT_KEY:= G_TEMPLATE_MODEL_OSR||
143: p_org_id||':'||
144: p_intent||':'||
145: p_template_id;
146: l_cz_imp_devl_project_rec.LAST_UPDATE_LOGIN:= FND_GLOBAL.LOGIN_ID;
147: l_cz_imp_devl_project_rec.BOM_CAPTION_RULE_ID:= NULL;
148: l_cz_imp_devl_project_rec.NONBOM_CAPTION_RULE_ID:= OKC_XPRT_CZ_INT_PVT.G_CAPTION_RULE_DESC; -- display desc in runtime UIs
149: l_cz_imp_devl_project_rec.SEEDED_FLAG:= '1'; -- '0' unseeded , '1' seeded
150:

Line 147: l_cz_imp_devl_project_rec.BOM_CAPTION_RULE_ID:= NULL;

143: p_org_id||':'||
144: p_intent||':'||
145: p_template_id;
146: l_cz_imp_devl_project_rec.LAST_UPDATE_LOGIN:= FND_GLOBAL.LOGIN_ID;
147: l_cz_imp_devl_project_rec.BOM_CAPTION_RULE_ID:= NULL;
148: l_cz_imp_devl_project_rec.NONBOM_CAPTION_RULE_ID:= OKC_XPRT_CZ_INT_PVT.G_CAPTION_RULE_DESC; -- display desc in runtime UIs
149: l_cz_imp_devl_project_rec.SEEDED_FLAG:= '1'; -- '0' unseeded , '1' seeded
150:
151: --

Line 148: l_cz_imp_devl_project_rec.NONBOM_CAPTION_RULE_ID:= OKC_XPRT_CZ_INT_PVT.G_CAPTION_RULE_DESC; -- display desc in runtime UIs

144: p_intent||':'||
145: p_template_id;
146: l_cz_imp_devl_project_rec.LAST_UPDATE_LOGIN:= FND_GLOBAL.LOGIN_ID;
147: l_cz_imp_devl_project_rec.BOM_CAPTION_RULE_ID:= NULL;
148: l_cz_imp_devl_project_rec.NONBOM_CAPTION_RULE_ID:= OKC_XPRT_CZ_INT_PVT.G_CAPTION_RULE_DESC; -- display desc in runtime UIs
149: l_cz_imp_devl_project_rec.SEEDED_FLAG:= '1'; -- '0' unseeded , '1' seeded
150:
151: --
152:

Line 149: l_cz_imp_devl_project_rec.SEEDED_FLAG:= '1'; -- '0' unseeded , '1' seeded

145: p_template_id;
146: l_cz_imp_devl_project_rec.LAST_UPDATE_LOGIN:= FND_GLOBAL.LOGIN_ID;
147: l_cz_imp_devl_project_rec.BOM_CAPTION_RULE_ID:= NULL;
148: l_cz_imp_devl_project_rec.NONBOM_CAPTION_RULE_ID:= OKC_XPRT_CZ_INT_PVT.G_CAPTION_RULE_DESC; -- display desc in runtime UIs
149: l_cz_imp_devl_project_rec.SEEDED_FLAG:= '1'; -- '0' unseeded , '1' seeded
150:
151: --
152:
153: -- insert the Variable Model Record into cz_devl_project

Line 154: INSERT INTO cz_imp_devl_project

150:
151: --
152:
153: -- insert the Variable Model Record into cz_devl_project
154: INSERT INTO cz_imp_devl_project
155: (
156: DEVL_PROJECT_ID,
157: INTL_TEXT_ID,
158: ORGANIZATION_ID,

Line 193: l_cz_imp_devl_project_rec.DEVL_PROJECT_ID,

189: SEEDED_FLAG
190: )
191: VALUES
192: (
193: l_cz_imp_devl_project_rec.DEVL_PROJECT_ID,
194: l_cz_imp_devl_project_rec.INTL_TEXT_ID,
195: l_cz_imp_devl_project_rec.ORGANIZATION_ID,
196: l_cz_imp_devl_project_rec.NAME,
197: l_cz_imp_devl_project_rec.GSL_FILENAME,

Line 194: l_cz_imp_devl_project_rec.INTL_TEXT_ID,

190: )
191: VALUES
192: (
193: l_cz_imp_devl_project_rec.DEVL_PROJECT_ID,
194: l_cz_imp_devl_project_rec.INTL_TEXT_ID,
195: l_cz_imp_devl_project_rec.ORGANIZATION_ID,
196: l_cz_imp_devl_project_rec.NAME,
197: l_cz_imp_devl_project_rec.GSL_FILENAME,
198: l_cz_imp_devl_project_rec.TOP_ITEM_ID,

Line 195: l_cz_imp_devl_project_rec.ORGANIZATION_ID,

191: VALUES
192: (
193: l_cz_imp_devl_project_rec.DEVL_PROJECT_ID,
194: l_cz_imp_devl_project_rec.INTL_TEXT_ID,
195: l_cz_imp_devl_project_rec.ORGANIZATION_ID,
196: l_cz_imp_devl_project_rec.NAME,
197: l_cz_imp_devl_project_rec.GSL_FILENAME,
198: l_cz_imp_devl_project_rec.TOP_ITEM_ID,
199: l_cz_imp_devl_project_rec.VERSION,

Line 196: l_cz_imp_devl_project_rec.NAME,

192: (
193: l_cz_imp_devl_project_rec.DEVL_PROJECT_ID,
194: l_cz_imp_devl_project_rec.INTL_TEXT_ID,
195: l_cz_imp_devl_project_rec.ORGANIZATION_ID,
196: l_cz_imp_devl_project_rec.NAME,
197: l_cz_imp_devl_project_rec.GSL_FILENAME,
198: l_cz_imp_devl_project_rec.TOP_ITEM_ID,
199: l_cz_imp_devl_project_rec.VERSION,
200: l_cz_imp_devl_project_rec.EXPLOSION_TYPE,

Line 197: l_cz_imp_devl_project_rec.GSL_FILENAME,

193: l_cz_imp_devl_project_rec.DEVL_PROJECT_ID,
194: l_cz_imp_devl_project_rec.INTL_TEXT_ID,
195: l_cz_imp_devl_project_rec.ORGANIZATION_ID,
196: l_cz_imp_devl_project_rec.NAME,
197: l_cz_imp_devl_project_rec.GSL_FILENAME,
198: l_cz_imp_devl_project_rec.TOP_ITEM_ID,
199: l_cz_imp_devl_project_rec.VERSION,
200: l_cz_imp_devl_project_rec.EXPLOSION_TYPE,
201: l_cz_imp_devl_project_rec.DESC_TEXT,

Line 198: l_cz_imp_devl_project_rec.TOP_ITEM_ID,

194: l_cz_imp_devl_project_rec.INTL_TEXT_ID,
195: l_cz_imp_devl_project_rec.ORGANIZATION_ID,
196: l_cz_imp_devl_project_rec.NAME,
197: l_cz_imp_devl_project_rec.GSL_FILENAME,
198: l_cz_imp_devl_project_rec.TOP_ITEM_ID,
199: l_cz_imp_devl_project_rec.VERSION,
200: l_cz_imp_devl_project_rec.EXPLOSION_TYPE,
201: l_cz_imp_devl_project_rec.DESC_TEXT,
202: l_cz_imp_devl_project_rec.ORIG_SYS_REF,

Line 199: l_cz_imp_devl_project_rec.VERSION,

195: l_cz_imp_devl_project_rec.ORGANIZATION_ID,
196: l_cz_imp_devl_project_rec.NAME,
197: l_cz_imp_devl_project_rec.GSL_FILENAME,
198: l_cz_imp_devl_project_rec.TOP_ITEM_ID,
199: l_cz_imp_devl_project_rec.VERSION,
200: l_cz_imp_devl_project_rec.EXPLOSION_TYPE,
201: l_cz_imp_devl_project_rec.DESC_TEXT,
202: l_cz_imp_devl_project_rec.ORIG_SYS_REF,
203: l_cz_imp_devl_project_rec.CREATION_DATE,

Line 200: l_cz_imp_devl_project_rec.EXPLOSION_TYPE,

196: l_cz_imp_devl_project_rec.NAME,
197: l_cz_imp_devl_project_rec.GSL_FILENAME,
198: l_cz_imp_devl_project_rec.TOP_ITEM_ID,
199: l_cz_imp_devl_project_rec.VERSION,
200: l_cz_imp_devl_project_rec.EXPLOSION_TYPE,
201: l_cz_imp_devl_project_rec.DESC_TEXT,
202: l_cz_imp_devl_project_rec.ORIG_SYS_REF,
203: l_cz_imp_devl_project_rec.CREATION_DATE,
204: l_cz_imp_devl_project_rec.LAST_UPDATE_DATE,

Line 201: l_cz_imp_devl_project_rec.DESC_TEXT,

197: l_cz_imp_devl_project_rec.GSL_FILENAME,
198: l_cz_imp_devl_project_rec.TOP_ITEM_ID,
199: l_cz_imp_devl_project_rec.VERSION,
200: l_cz_imp_devl_project_rec.EXPLOSION_TYPE,
201: l_cz_imp_devl_project_rec.DESC_TEXT,
202: l_cz_imp_devl_project_rec.ORIG_SYS_REF,
203: l_cz_imp_devl_project_rec.CREATION_DATE,
204: l_cz_imp_devl_project_rec.LAST_UPDATE_DATE,
205: l_cz_imp_devl_project_rec.DELETED_FLAG,

Line 202: l_cz_imp_devl_project_rec.ORIG_SYS_REF,

198: l_cz_imp_devl_project_rec.TOP_ITEM_ID,
199: l_cz_imp_devl_project_rec.VERSION,
200: l_cz_imp_devl_project_rec.EXPLOSION_TYPE,
201: l_cz_imp_devl_project_rec.DESC_TEXT,
202: l_cz_imp_devl_project_rec.ORIG_SYS_REF,
203: l_cz_imp_devl_project_rec.CREATION_DATE,
204: l_cz_imp_devl_project_rec.LAST_UPDATE_DATE,
205: l_cz_imp_devl_project_rec.DELETED_FLAG,
206: l_cz_imp_devl_project_rec.EFF_FROM,

Line 203: l_cz_imp_devl_project_rec.CREATION_DATE,

199: l_cz_imp_devl_project_rec.VERSION,
200: l_cz_imp_devl_project_rec.EXPLOSION_TYPE,
201: l_cz_imp_devl_project_rec.DESC_TEXT,
202: l_cz_imp_devl_project_rec.ORIG_SYS_REF,
203: l_cz_imp_devl_project_rec.CREATION_DATE,
204: l_cz_imp_devl_project_rec.LAST_UPDATE_DATE,
205: l_cz_imp_devl_project_rec.DELETED_FLAG,
206: l_cz_imp_devl_project_rec.EFF_FROM,
207: l_cz_imp_devl_project_rec.EFF_TO,

Line 204: l_cz_imp_devl_project_rec.LAST_UPDATE_DATE,

200: l_cz_imp_devl_project_rec.EXPLOSION_TYPE,
201: l_cz_imp_devl_project_rec.DESC_TEXT,
202: l_cz_imp_devl_project_rec.ORIG_SYS_REF,
203: l_cz_imp_devl_project_rec.CREATION_DATE,
204: l_cz_imp_devl_project_rec.LAST_UPDATE_DATE,
205: l_cz_imp_devl_project_rec.DELETED_FLAG,
206: l_cz_imp_devl_project_rec.EFF_FROM,
207: l_cz_imp_devl_project_rec.EFF_TO,
208: l_cz_imp_devl_project_rec.CREATED_BY,

Line 205: l_cz_imp_devl_project_rec.DELETED_FLAG,

201: l_cz_imp_devl_project_rec.DESC_TEXT,
202: l_cz_imp_devl_project_rec.ORIG_SYS_REF,
203: l_cz_imp_devl_project_rec.CREATION_DATE,
204: l_cz_imp_devl_project_rec.LAST_UPDATE_DATE,
205: l_cz_imp_devl_project_rec.DELETED_FLAG,
206: l_cz_imp_devl_project_rec.EFF_FROM,
207: l_cz_imp_devl_project_rec.EFF_TO,
208: l_cz_imp_devl_project_rec.CREATED_BY,
209: l_cz_imp_devl_project_rec.LAST_UPDATED_BY,

Line 206: l_cz_imp_devl_project_rec.EFF_FROM,

202: l_cz_imp_devl_project_rec.ORIG_SYS_REF,
203: l_cz_imp_devl_project_rec.CREATION_DATE,
204: l_cz_imp_devl_project_rec.LAST_UPDATE_DATE,
205: l_cz_imp_devl_project_rec.DELETED_FLAG,
206: l_cz_imp_devl_project_rec.EFF_FROM,
207: l_cz_imp_devl_project_rec.EFF_TO,
208: l_cz_imp_devl_project_rec.CREATED_BY,
209: l_cz_imp_devl_project_rec.LAST_UPDATED_BY,
210: l_cz_imp_devl_project_rec.SECURITY_MASK,

Line 207: l_cz_imp_devl_project_rec.EFF_TO,

203: l_cz_imp_devl_project_rec.CREATION_DATE,
204: l_cz_imp_devl_project_rec.LAST_UPDATE_DATE,
205: l_cz_imp_devl_project_rec.DELETED_FLAG,
206: l_cz_imp_devl_project_rec.EFF_FROM,
207: l_cz_imp_devl_project_rec.EFF_TO,
208: l_cz_imp_devl_project_rec.CREATED_BY,
209: l_cz_imp_devl_project_rec.LAST_UPDATED_BY,
210: l_cz_imp_devl_project_rec.SECURITY_MASK,
211: l_cz_imp_devl_project_rec.EFF_MASK,

Line 208: l_cz_imp_devl_project_rec.CREATED_BY,

204: l_cz_imp_devl_project_rec.LAST_UPDATE_DATE,
205: l_cz_imp_devl_project_rec.DELETED_FLAG,
206: l_cz_imp_devl_project_rec.EFF_FROM,
207: l_cz_imp_devl_project_rec.EFF_TO,
208: l_cz_imp_devl_project_rec.CREATED_BY,
209: l_cz_imp_devl_project_rec.LAST_UPDATED_BY,
210: l_cz_imp_devl_project_rec.SECURITY_MASK,
211: l_cz_imp_devl_project_rec.EFF_MASK,
212: l_cz_imp_devl_project_rec.CHECKOUT_USER,

Line 209: l_cz_imp_devl_project_rec.LAST_UPDATED_BY,

205: l_cz_imp_devl_project_rec.DELETED_FLAG,
206: l_cz_imp_devl_project_rec.EFF_FROM,
207: l_cz_imp_devl_project_rec.EFF_TO,
208: l_cz_imp_devl_project_rec.CREATED_BY,
209: l_cz_imp_devl_project_rec.LAST_UPDATED_BY,
210: l_cz_imp_devl_project_rec.SECURITY_MASK,
211: l_cz_imp_devl_project_rec.EFF_MASK,
212: l_cz_imp_devl_project_rec.CHECKOUT_USER,
213: l_cz_imp_devl_project_rec.RUN_ID,

Line 210: l_cz_imp_devl_project_rec.SECURITY_MASK,

206: l_cz_imp_devl_project_rec.EFF_FROM,
207: l_cz_imp_devl_project_rec.EFF_TO,
208: l_cz_imp_devl_project_rec.CREATED_BY,
209: l_cz_imp_devl_project_rec.LAST_UPDATED_BY,
210: l_cz_imp_devl_project_rec.SECURITY_MASK,
211: l_cz_imp_devl_project_rec.EFF_MASK,
212: l_cz_imp_devl_project_rec.CHECKOUT_USER,
213: l_cz_imp_devl_project_rec.RUN_ID,
214: l_cz_imp_devl_project_rec.REC_STATUS,

Line 211: l_cz_imp_devl_project_rec.EFF_MASK,

207: l_cz_imp_devl_project_rec.EFF_TO,
208: l_cz_imp_devl_project_rec.CREATED_BY,
209: l_cz_imp_devl_project_rec.LAST_UPDATED_BY,
210: l_cz_imp_devl_project_rec.SECURITY_MASK,
211: l_cz_imp_devl_project_rec.EFF_MASK,
212: l_cz_imp_devl_project_rec.CHECKOUT_USER,
213: l_cz_imp_devl_project_rec.RUN_ID,
214: l_cz_imp_devl_project_rec.REC_STATUS,
215: l_cz_imp_devl_project_rec.DISPOSITION,

Line 212: l_cz_imp_devl_project_rec.CHECKOUT_USER,

208: l_cz_imp_devl_project_rec.CREATED_BY,
209: l_cz_imp_devl_project_rec.LAST_UPDATED_BY,
210: l_cz_imp_devl_project_rec.SECURITY_MASK,
211: l_cz_imp_devl_project_rec.EFF_MASK,
212: l_cz_imp_devl_project_rec.CHECKOUT_USER,
213: l_cz_imp_devl_project_rec.RUN_ID,
214: l_cz_imp_devl_project_rec.REC_STATUS,
215: l_cz_imp_devl_project_rec.DISPOSITION,
216: l_cz_imp_devl_project_rec.FSK_INTLTEXT_1_1,

Line 213: l_cz_imp_devl_project_rec.RUN_ID,

209: l_cz_imp_devl_project_rec.LAST_UPDATED_BY,
210: l_cz_imp_devl_project_rec.SECURITY_MASK,
211: l_cz_imp_devl_project_rec.EFF_MASK,
212: l_cz_imp_devl_project_rec.CHECKOUT_USER,
213: l_cz_imp_devl_project_rec.RUN_ID,
214: l_cz_imp_devl_project_rec.REC_STATUS,
215: l_cz_imp_devl_project_rec.DISPOSITION,
216: l_cz_imp_devl_project_rec.FSK_INTLTEXT_1_1,
217: l_cz_imp_devl_project_rec.MODEL_ID,

Line 214: l_cz_imp_devl_project_rec.REC_STATUS,

210: l_cz_imp_devl_project_rec.SECURITY_MASK,
211: l_cz_imp_devl_project_rec.EFF_MASK,
212: l_cz_imp_devl_project_rec.CHECKOUT_USER,
213: l_cz_imp_devl_project_rec.RUN_ID,
214: l_cz_imp_devl_project_rec.REC_STATUS,
215: l_cz_imp_devl_project_rec.DISPOSITION,
216: l_cz_imp_devl_project_rec.FSK_INTLTEXT_1_1,
217: l_cz_imp_devl_project_rec.MODEL_ID,
218: l_cz_imp_devl_project_rec.PLAN_LEVEL,

Line 215: l_cz_imp_devl_project_rec.DISPOSITION,

211: l_cz_imp_devl_project_rec.EFF_MASK,
212: l_cz_imp_devl_project_rec.CHECKOUT_USER,
213: l_cz_imp_devl_project_rec.RUN_ID,
214: l_cz_imp_devl_project_rec.REC_STATUS,
215: l_cz_imp_devl_project_rec.DISPOSITION,
216: l_cz_imp_devl_project_rec.FSK_INTLTEXT_1_1,
217: l_cz_imp_devl_project_rec.MODEL_ID,
218: l_cz_imp_devl_project_rec.PLAN_LEVEL,
219: l_cz_imp_devl_project_rec.PERSISTENT_PROJECT_ID,

Line 216: l_cz_imp_devl_project_rec.FSK_INTLTEXT_1_1,

212: l_cz_imp_devl_project_rec.CHECKOUT_USER,
213: l_cz_imp_devl_project_rec.RUN_ID,
214: l_cz_imp_devl_project_rec.REC_STATUS,
215: l_cz_imp_devl_project_rec.DISPOSITION,
216: l_cz_imp_devl_project_rec.FSK_INTLTEXT_1_1,
217: l_cz_imp_devl_project_rec.MODEL_ID,
218: l_cz_imp_devl_project_rec.PLAN_LEVEL,
219: l_cz_imp_devl_project_rec.PERSISTENT_PROJECT_ID,
220: l_cz_imp_devl_project_rec.MODEL_TYPE,

Line 217: l_cz_imp_devl_project_rec.MODEL_ID,

213: l_cz_imp_devl_project_rec.RUN_ID,
214: l_cz_imp_devl_project_rec.REC_STATUS,
215: l_cz_imp_devl_project_rec.DISPOSITION,
216: l_cz_imp_devl_project_rec.FSK_INTLTEXT_1_1,
217: l_cz_imp_devl_project_rec.MODEL_ID,
218: l_cz_imp_devl_project_rec.PLAN_LEVEL,
219: l_cz_imp_devl_project_rec.PERSISTENT_PROJECT_ID,
220: l_cz_imp_devl_project_rec.MODEL_TYPE,
221: l_cz_imp_devl_project_rec.INVENTORY_ITEM_ID,

Line 218: l_cz_imp_devl_project_rec.PLAN_LEVEL,

214: l_cz_imp_devl_project_rec.REC_STATUS,
215: l_cz_imp_devl_project_rec.DISPOSITION,
216: l_cz_imp_devl_project_rec.FSK_INTLTEXT_1_1,
217: l_cz_imp_devl_project_rec.MODEL_ID,
218: l_cz_imp_devl_project_rec.PLAN_LEVEL,
219: l_cz_imp_devl_project_rec.PERSISTENT_PROJECT_ID,
220: l_cz_imp_devl_project_rec.MODEL_TYPE,
221: l_cz_imp_devl_project_rec.INVENTORY_ITEM_ID,
222: l_cz_imp_devl_project_rec.PRODUCT_KEY,

Line 219: l_cz_imp_devl_project_rec.PERSISTENT_PROJECT_ID,

215: l_cz_imp_devl_project_rec.DISPOSITION,
216: l_cz_imp_devl_project_rec.FSK_INTLTEXT_1_1,
217: l_cz_imp_devl_project_rec.MODEL_ID,
218: l_cz_imp_devl_project_rec.PLAN_LEVEL,
219: l_cz_imp_devl_project_rec.PERSISTENT_PROJECT_ID,
220: l_cz_imp_devl_project_rec.MODEL_TYPE,
221: l_cz_imp_devl_project_rec.INVENTORY_ITEM_ID,
222: l_cz_imp_devl_project_rec.PRODUCT_KEY,
223: l_cz_imp_devl_project_rec.LAST_UPDATE_LOGIN,

Line 220: l_cz_imp_devl_project_rec.MODEL_TYPE,

216: l_cz_imp_devl_project_rec.FSK_INTLTEXT_1_1,
217: l_cz_imp_devl_project_rec.MODEL_ID,
218: l_cz_imp_devl_project_rec.PLAN_LEVEL,
219: l_cz_imp_devl_project_rec.PERSISTENT_PROJECT_ID,
220: l_cz_imp_devl_project_rec.MODEL_TYPE,
221: l_cz_imp_devl_project_rec.INVENTORY_ITEM_ID,
222: l_cz_imp_devl_project_rec.PRODUCT_KEY,
223: l_cz_imp_devl_project_rec.LAST_UPDATE_LOGIN,
224: l_cz_imp_devl_project_rec.BOM_CAPTION_RULE_ID,

Line 221: l_cz_imp_devl_project_rec.INVENTORY_ITEM_ID,

217: l_cz_imp_devl_project_rec.MODEL_ID,
218: l_cz_imp_devl_project_rec.PLAN_LEVEL,
219: l_cz_imp_devl_project_rec.PERSISTENT_PROJECT_ID,
220: l_cz_imp_devl_project_rec.MODEL_TYPE,
221: l_cz_imp_devl_project_rec.INVENTORY_ITEM_ID,
222: l_cz_imp_devl_project_rec.PRODUCT_KEY,
223: l_cz_imp_devl_project_rec.LAST_UPDATE_LOGIN,
224: l_cz_imp_devl_project_rec.BOM_CAPTION_RULE_ID,
225: l_cz_imp_devl_project_rec.NONBOM_CAPTION_RULE_ID,

Line 222: l_cz_imp_devl_project_rec.PRODUCT_KEY,

218: l_cz_imp_devl_project_rec.PLAN_LEVEL,
219: l_cz_imp_devl_project_rec.PERSISTENT_PROJECT_ID,
220: l_cz_imp_devl_project_rec.MODEL_TYPE,
221: l_cz_imp_devl_project_rec.INVENTORY_ITEM_ID,
222: l_cz_imp_devl_project_rec.PRODUCT_KEY,
223: l_cz_imp_devl_project_rec.LAST_UPDATE_LOGIN,
224: l_cz_imp_devl_project_rec.BOM_CAPTION_RULE_ID,
225: l_cz_imp_devl_project_rec.NONBOM_CAPTION_RULE_ID,
226: l_cz_imp_devl_project_rec.SEEDED_FLAG

Line 223: l_cz_imp_devl_project_rec.LAST_UPDATE_LOGIN,

219: l_cz_imp_devl_project_rec.PERSISTENT_PROJECT_ID,
220: l_cz_imp_devl_project_rec.MODEL_TYPE,
221: l_cz_imp_devl_project_rec.INVENTORY_ITEM_ID,
222: l_cz_imp_devl_project_rec.PRODUCT_KEY,
223: l_cz_imp_devl_project_rec.LAST_UPDATE_LOGIN,
224: l_cz_imp_devl_project_rec.BOM_CAPTION_RULE_ID,
225: l_cz_imp_devl_project_rec.NONBOM_CAPTION_RULE_ID,
226: l_cz_imp_devl_project_rec.SEEDED_FLAG
227: );

Line 224: l_cz_imp_devl_project_rec.BOM_CAPTION_RULE_ID,

220: l_cz_imp_devl_project_rec.MODEL_TYPE,
221: l_cz_imp_devl_project_rec.INVENTORY_ITEM_ID,
222: l_cz_imp_devl_project_rec.PRODUCT_KEY,
223: l_cz_imp_devl_project_rec.LAST_UPDATE_LOGIN,
224: l_cz_imp_devl_project_rec.BOM_CAPTION_RULE_ID,
225: l_cz_imp_devl_project_rec.NONBOM_CAPTION_RULE_ID,
226: l_cz_imp_devl_project_rec.SEEDED_FLAG
227: );
228:

Line 225: l_cz_imp_devl_project_rec.NONBOM_CAPTION_RULE_ID,

221: l_cz_imp_devl_project_rec.INVENTORY_ITEM_ID,
222: l_cz_imp_devl_project_rec.PRODUCT_KEY,
223: l_cz_imp_devl_project_rec.LAST_UPDATE_LOGIN,
224: l_cz_imp_devl_project_rec.BOM_CAPTION_RULE_ID,
225: l_cz_imp_devl_project_rec.NONBOM_CAPTION_RULE_ID,
226: l_cz_imp_devl_project_rec.SEEDED_FLAG
227: );
228:
229:

Line 226: l_cz_imp_devl_project_rec.SEEDED_FLAG

222: l_cz_imp_devl_project_rec.PRODUCT_KEY,
223: l_cz_imp_devl_project_rec.LAST_UPDATE_LOGIN,
224: l_cz_imp_devl_project_rec.BOM_CAPTION_RULE_ID,
225: l_cz_imp_devl_project_rec.NONBOM_CAPTION_RULE_ID,
226: l_cz_imp_devl_project_rec.SEEDED_FLAG
227: );
228:
229:
230: -- Standard call to get message count and if count is 1, get message info.

Line 394: l_cz_imp_ps_nodes_rec.TOP_ITEM_ID:= 1; -- same value as in cz_imp_devl_projects

390: p_org_id||':'||
391: p_intent||':'||
392: p_template_id;
393: l_cz_imp_ps_nodes_rec.RESOURCE_FLAG:= NULL;
394: l_cz_imp_ps_nodes_rec.TOP_ITEM_ID:= 1; -- same value as in cz_imp_devl_projects
395: l_cz_imp_ps_nodes_rec.INITIAL_VALUE:= NULL;
396: l_cz_imp_ps_nodes_rec.PARENT_ID:= NULL;
397: l_cz_imp_ps_nodes_rec.MINIMUM:= 1;
398: l_cz_imp_ps_nodes_rec.MAXIMUM:= 1;

Line 954: l_cz_imp_ps_nodes_rec.TOP_ITEM_ID:= 1; -- same value as in cz_imp_devl_projects

950: p_intent||':'||
951: p_derived_template_id||':'||
952: l_question_id;
953: l_cz_imp_ps_nodes_rec.RESOURCE_FLAG:= NULL;
954: l_cz_imp_ps_nodes_rec.TOP_ITEM_ID:= 1; -- same value as in cz_imp_devl_projects
955: l_cz_imp_ps_nodes_rec.INITIAL_VALUE:= NULL;
956: l_cz_imp_ps_nodes_rec.PARENT_ID:= NULL;
957: l_cz_imp_ps_nodes_rec.MINIMUM:= l_feature_min_val ; --0 for dependent and 1 for mandatory Questions
958: l_cz_imp_ps_nodes_rec.MAXIMUM:= l_feature_max_val ;

Line 1804: 1, --TOP_ITEM_ID -- same value as in cz_imp_devl_projects

1800: p_derived_template_id||':'||
1801: p_question_id||':'||
1802: IdList_tbl(i), --ORIG_SYS_REF
1803: NULL, --RESOURCE_FLAG
1804: 1, --TOP_ITEM_ID -- same value as in cz_imp_devl_projects
1805: NULL, --INITIAL_VALUE
1806: NULL, --PARENT_ID
1807: 1, --MINIMUM
1808: 1, --MAXIMUM

Line 2087: l_cz_imp_ps_nodes_rec.TOP_ITEM_ID:= 1; -- same value as in cz_imp_devl_projects

2083: p_org_id||':'||
2084: p_intent||':'||
2085: p_template_id;
2086: l_cz_imp_ps_nodes_rec.RESOURCE_FLAG:= NULL;
2087: l_cz_imp_ps_nodes_rec.TOP_ITEM_ID:= 1; -- same value as in cz_imp_devl_projects
2088: l_cz_imp_ps_nodes_rec.INITIAL_VALUE:= NULL;
2089: l_cz_imp_ps_nodes_rec.PARENT_ID:= NULL;
2090: l_cz_imp_ps_nodes_rec.MINIMUM:= 1;
2091: l_cz_imp_ps_nodes_rec.MAXIMUM:= 1;