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_VARIABLES_PVT dependencies on CZ_IMP_DEVL_PROJECT

Line 68: l_cz_imp_devl_project_rec CZ_IMP_DEVL_PROJECT%ROWTYPE;

64: x_msg_data OUT NOCOPY VARCHAR2,
65: x_msg_count OUT NOCOPY NUMBER
66: ) IS
67:
68: l_cz_imp_devl_project_rec CZ_IMP_DEVL_PROJECT%ROWTYPE;
69: l_api_name CONSTANT VARCHAR2(30) := 'create_variable_model';
70: l_model_desc CZ_IMP_DEVL_PROJECT.DESC_TEXT%TYPE;
71:
72: BEGIN

Line 70: l_model_desc CZ_IMP_DEVL_PROJECT.DESC_TEXT%TYPE;

66: ) IS
67:
68: l_cz_imp_devl_project_rec CZ_IMP_DEVL_PROJECT%ROWTYPE;
69: l_api_name CONSTANT VARCHAR2(30) := 'create_variable_model';
70: l_model_desc CZ_IMP_DEVL_PROJECT.DESC_TEXT%TYPE;
71:
72: BEGIN
73:
74: -- start debug log

Line 88: -- populate the l_cz_imp_devl_project_rec

84: FND_MESSAGE.set_name('OKC','OKC_EXPRT_VAR_MODEL_TITLE');
85: FND_MESSAGE.set_token('INTENT_MEANING',okc_util.decode_lookup('OKC_ARTICLE_INTENT',p_intent));
86: l_model_desc := FND_MESSAGE.get;
87:
88: -- populate the l_cz_imp_devl_project_rec
89: l_cz_imp_devl_project_rec.DEVL_PROJECT_ID:= NULL;
90: l_cz_imp_devl_project_rec.INTL_TEXT_ID:= NULL;
91: l_cz_imp_devl_project_rec.ORGANIZATION_ID:= -99;
92: l_cz_imp_devl_project_rec.NAME:= G_VARIABLE_MODEL_OSR||p_intent ;

Line 89: l_cz_imp_devl_project_rec.DEVL_PROJECT_ID:= NULL;

85: FND_MESSAGE.set_token('INTENT_MEANING',okc_util.decode_lookup('OKC_ARTICLE_INTENT',p_intent));
86: l_model_desc := FND_MESSAGE.get;
87:
88: -- populate the l_cz_imp_devl_project_rec
89: l_cz_imp_devl_project_rec.DEVL_PROJECT_ID:= NULL;
90: l_cz_imp_devl_project_rec.INTL_TEXT_ID:= NULL;
91: l_cz_imp_devl_project_rec.ORGANIZATION_ID:= -99;
92: l_cz_imp_devl_project_rec.NAME:= G_VARIABLE_MODEL_OSR||p_intent ;
93: l_cz_imp_devl_project_rec.GSL_FILENAME:= NULL;

Line 90: l_cz_imp_devl_project_rec.INTL_TEXT_ID:= NULL;

86: l_model_desc := FND_MESSAGE.get;
87:
88: -- populate the l_cz_imp_devl_project_rec
89: l_cz_imp_devl_project_rec.DEVL_PROJECT_ID:= NULL;
90: l_cz_imp_devl_project_rec.INTL_TEXT_ID:= NULL;
91: l_cz_imp_devl_project_rec.ORGANIZATION_ID:= -99;
92: l_cz_imp_devl_project_rec.NAME:= G_VARIABLE_MODEL_OSR||p_intent ;
93: l_cz_imp_devl_project_rec.GSL_FILENAME:= NULL;
94: l_cz_imp_devl_project_rec.TOP_ITEM_ID:= 1;

Line 91: l_cz_imp_devl_project_rec.ORGANIZATION_ID:= -99;

87:
88: -- populate the l_cz_imp_devl_project_rec
89: l_cz_imp_devl_project_rec.DEVL_PROJECT_ID:= NULL;
90: l_cz_imp_devl_project_rec.INTL_TEXT_ID:= NULL;
91: l_cz_imp_devl_project_rec.ORGANIZATION_ID:= -99;
92: l_cz_imp_devl_project_rec.NAME:= G_VARIABLE_MODEL_OSR||p_intent ;
93: l_cz_imp_devl_project_rec.GSL_FILENAME:= NULL;
94: l_cz_imp_devl_project_rec.TOP_ITEM_ID:= 1;
95: l_cz_imp_devl_project_rec.VERSION:= NULL;

Line 92: l_cz_imp_devl_project_rec.NAME:= G_VARIABLE_MODEL_OSR||p_intent ;

88: -- populate the l_cz_imp_devl_project_rec
89: l_cz_imp_devl_project_rec.DEVL_PROJECT_ID:= NULL;
90: l_cz_imp_devl_project_rec.INTL_TEXT_ID:= NULL;
91: l_cz_imp_devl_project_rec.ORGANIZATION_ID:= -99;
92: l_cz_imp_devl_project_rec.NAME:= G_VARIABLE_MODEL_OSR||p_intent ;
93: l_cz_imp_devl_project_rec.GSL_FILENAME:= NULL;
94: l_cz_imp_devl_project_rec.TOP_ITEM_ID:= 1;
95: l_cz_imp_devl_project_rec.VERSION:= NULL;
96: l_cz_imp_devl_project_rec.EXPLOSION_TYPE:= NULL;

Line 93: l_cz_imp_devl_project_rec.GSL_FILENAME:= NULL;

89: l_cz_imp_devl_project_rec.DEVL_PROJECT_ID:= NULL;
90: l_cz_imp_devl_project_rec.INTL_TEXT_ID:= NULL;
91: l_cz_imp_devl_project_rec.ORGANIZATION_ID:= -99;
92: l_cz_imp_devl_project_rec.NAME:= G_VARIABLE_MODEL_OSR||p_intent ;
93: l_cz_imp_devl_project_rec.GSL_FILENAME:= NULL;
94: l_cz_imp_devl_project_rec.TOP_ITEM_ID:= 1;
95: l_cz_imp_devl_project_rec.VERSION:= NULL;
96: l_cz_imp_devl_project_rec.EXPLOSION_TYPE:= NULL;
97: l_cz_imp_devl_project_rec.DESC_TEXT:= l_model_desc;

Line 94: l_cz_imp_devl_project_rec.TOP_ITEM_ID:= 1;

90: l_cz_imp_devl_project_rec.INTL_TEXT_ID:= NULL;
91: l_cz_imp_devl_project_rec.ORGANIZATION_ID:= -99;
92: l_cz_imp_devl_project_rec.NAME:= G_VARIABLE_MODEL_OSR||p_intent ;
93: l_cz_imp_devl_project_rec.GSL_FILENAME:= NULL;
94: l_cz_imp_devl_project_rec.TOP_ITEM_ID:= 1;
95: l_cz_imp_devl_project_rec.VERSION:= NULL;
96: l_cz_imp_devl_project_rec.EXPLOSION_TYPE:= NULL;
97: l_cz_imp_devl_project_rec.DESC_TEXT:= l_model_desc;
98: l_cz_imp_devl_project_rec.ORIG_SYS_REF:= G_VARIABLE_MODEL_OSR||p_intent ;

Line 95: l_cz_imp_devl_project_rec.VERSION:= NULL;

91: l_cz_imp_devl_project_rec.ORGANIZATION_ID:= -99;
92: l_cz_imp_devl_project_rec.NAME:= G_VARIABLE_MODEL_OSR||p_intent ;
93: l_cz_imp_devl_project_rec.GSL_FILENAME:= NULL;
94: l_cz_imp_devl_project_rec.TOP_ITEM_ID:= 1;
95: l_cz_imp_devl_project_rec.VERSION:= NULL;
96: l_cz_imp_devl_project_rec.EXPLOSION_TYPE:= NULL;
97: l_cz_imp_devl_project_rec.DESC_TEXT:= l_model_desc;
98: l_cz_imp_devl_project_rec.ORIG_SYS_REF:= G_VARIABLE_MODEL_OSR||p_intent ;
99: l_cz_imp_devl_project_rec.CREATION_DATE:= SYSDATE;

Line 96: l_cz_imp_devl_project_rec.EXPLOSION_TYPE:= NULL;

92: l_cz_imp_devl_project_rec.NAME:= G_VARIABLE_MODEL_OSR||p_intent ;
93: l_cz_imp_devl_project_rec.GSL_FILENAME:= NULL;
94: l_cz_imp_devl_project_rec.TOP_ITEM_ID:= 1;
95: l_cz_imp_devl_project_rec.VERSION:= NULL;
96: l_cz_imp_devl_project_rec.EXPLOSION_TYPE:= NULL;
97: l_cz_imp_devl_project_rec.DESC_TEXT:= l_model_desc;
98: l_cz_imp_devl_project_rec.ORIG_SYS_REF:= G_VARIABLE_MODEL_OSR||p_intent ;
99: l_cz_imp_devl_project_rec.CREATION_DATE:= SYSDATE;
100: l_cz_imp_devl_project_rec.LAST_UPDATE_DATE:= SYSDATE;

Line 97: l_cz_imp_devl_project_rec.DESC_TEXT:= l_model_desc;

93: l_cz_imp_devl_project_rec.GSL_FILENAME:= NULL;
94: l_cz_imp_devl_project_rec.TOP_ITEM_ID:= 1;
95: l_cz_imp_devl_project_rec.VERSION:= NULL;
96: l_cz_imp_devl_project_rec.EXPLOSION_TYPE:= NULL;
97: l_cz_imp_devl_project_rec.DESC_TEXT:= l_model_desc;
98: l_cz_imp_devl_project_rec.ORIG_SYS_REF:= G_VARIABLE_MODEL_OSR||p_intent ;
99: l_cz_imp_devl_project_rec.CREATION_DATE:= SYSDATE;
100: l_cz_imp_devl_project_rec.LAST_UPDATE_DATE:= SYSDATE;
101: l_cz_imp_devl_project_rec.DELETED_FLAG:= '0'; -- '0' Not deleted

Line 98: l_cz_imp_devl_project_rec.ORIG_SYS_REF:= G_VARIABLE_MODEL_OSR||p_intent ;

94: l_cz_imp_devl_project_rec.TOP_ITEM_ID:= 1;
95: l_cz_imp_devl_project_rec.VERSION:= NULL;
96: l_cz_imp_devl_project_rec.EXPLOSION_TYPE:= NULL;
97: l_cz_imp_devl_project_rec.DESC_TEXT:= l_model_desc;
98: l_cz_imp_devl_project_rec.ORIG_SYS_REF:= G_VARIABLE_MODEL_OSR||p_intent ;
99: l_cz_imp_devl_project_rec.CREATION_DATE:= SYSDATE;
100: l_cz_imp_devl_project_rec.LAST_UPDATE_DATE:= SYSDATE;
101: l_cz_imp_devl_project_rec.DELETED_FLAG:= '0'; -- '0' Not deleted
102: l_cz_imp_devl_project_rec.EFF_FROM:= NULL;

Line 99: l_cz_imp_devl_project_rec.CREATION_DATE:= SYSDATE;

95: l_cz_imp_devl_project_rec.VERSION:= NULL;
96: l_cz_imp_devl_project_rec.EXPLOSION_TYPE:= NULL;
97: l_cz_imp_devl_project_rec.DESC_TEXT:= l_model_desc;
98: l_cz_imp_devl_project_rec.ORIG_SYS_REF:= G_VARIABLE_MODEL_OSR||p_intent ;
99: l_cz_imp_devl_project_rec.CREATION_DATE:= SYSDATE;
100: l_cz_imp_devl_project_rec.LAST_UPDATE_DATE:= SYSDATE;
101: l_cz_imp_devl_project_rec.DELETED_FLAG:= '0'; -- '0' Not deleted
102: l_cz_imp_devl_project_rec.EFF_FROM:= NULL;
103: l_cz_imp_devl_project_rec.EFF_TO:= NULL;

Line 100: l_cz_imp_devl_project_rec.LAST_UPDATE_DATE:= SYSDATE;

96: l_cz_imp_devl_project_rec.EXPLOSION_TYPE:= NULL;
97: l_cz_imp_devl_project_rec.DESC_TEXT:= l_model_desc;
98: l_cz_imp_devl_project_rec.ORIG_SYS_REF:= G_VARIABLE_MODEL_OSR||p_intent ;
99: l_cz_imp_devl_project_rec.CREATION_DATE:= SYSDATE;
100: l_cz_imp_devl_project_rec.LAST_UPDATE_DATE:= SYSDATE;
101: l_cz_imp_devl_project_rec.DELETED_FLAG:= '0'; -- '0' Not deleted
102: l_cz_imp_devl_project_rec.EFF_FROM:= NULL;
103: l_cz_imp_devl_project_rec.EFF_TO:= NULL;
104: l_cz_imp_devl_project_rec.CREATED_BY:= FND_GLOBAL.USER_ID;

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

97: l_cz_imp_devl_project_rec.DESC_TEXT:= l_model_desc;
98: l_cz_imp_devl_project_rec.ORIG_SYS_REF:= G_VARIABLE_MODEL_OSR||p_intent ;
99: l_cz_imp_devl_project_rec.CREATION_DATE:= SYSDATE;
100: l_cz_imp_devl_project_rec.LAST_UPDATE_DATE:= SYSDATE;
101: l_cz_imp_devl_project_rec.DELETED_FLAG:= '0'; -- '0' Not deleted
102: l_cz_imp_devl_project_rec.EFF_FROM:= NULL;
103: l_cz_imp_devl_project_rec.EFF_TO:= NULL;
104: l_cz_imp_devl_project_rec.CREATED_BY:= FND_GLOBAL.USER_ID;
105: l_cz_imp_devl_project_rec.LAST_UPDATED_BY:= FND_GLOBAL.USER_ID;

Line 102: l_cz_imp_devl_project_rec.EFF_FROM:= NULL;

98: l_cz_imp_devl_project_rec.ORIG_SYS_REF:= G_VARIABLE_MODEL_OSR||p_intent ;
99: l_cz_imp_devl_project_rec.CREATION_DATE:= SYSDATE;
100: l_cz_imp_devl_project_rec.LAST_UPDATE_DATE:= SYSDATE;
101: l_cz_imp_devl_project_rec.DELETED_FLAG:= '0'; -- '0' Not deleted
102: l_cz_imp_devl_project_rec.EFF_FROM:= NULL;
103: l_cz_imp_devl_project_rec.EFF_TO:= NULL;
104: l_cz_imp_devl_project_rec.CREATED_BY:= FND_GLOBAL.USER_ID;
105: l_cz_imp_devl_project_rec.LAST_UPDATED_BY:= FND_GLOBAL.USER_ID;
106: l_cz_imp_devl_project_rec.SECURITY_MASK:= NULL;

Line 103: l_cz_imp_devl_project_rec.EFF_TO:= NULL;

99: l_cz_imp_devl_project_rec.CREATION_DATE:= SYSDATE;
100: l_cz_imp_devl_project_rec.LAST_UPDATE_DATE:= SYSDATE;
101: l_cz_imp_devl_project_rec.DELETED_FLAG:= '0'; -- '0' Not deleted
102: l_cz_imp_devl_project_rec.EFF_FROM:= NULL;
103: l_cz_imp_devl_project_rec.EFF_TO:= NULL;
104: l_cz_imp_devl_project_rec.CREATED_BY:= FND_GLOBAL.USER_ID;
105: l_cz_imp_devl_project_rec.LAST_UPDATED_BY:= FND_GLOBAL.USER_ID;
106: l_cz_imp_devl_project_rec.SECURITY_MASK:= NULL;
107: l_cz_imp_devl_project_rec.EFF_MASK:= NULL;

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

100: l_cz_imp_devl_project_rec.LAST_UPDATE_DATE:= SYSDATE;
101: l_cz_imp_devl_project_rec.DELETED_FLAG:= '0'; -- '0' Not deleted
102: l_cz_imp_devl_project_rec.EFF_FROM:= NULL;
103: l_cz_imp_devl_project_rec.EFF_TO:= NULL;
104: l_cz_imp_devl_project_rec.CREATED_BY:= FND_GLOBAL.USER_ID;
105: l_cz_imp_devl_project_rec.LAST_UPDATED_BY:= FND_GLOBAL.USER_ID;
106: l_cz_imp_devl_project_rec.SECURITY_MASK:= NULL;
107: l_cz_imp_devl_project_rec.EFF_MASK:= NULL;
108: l_cz_imp_devl_project_rec.CHECKOUT_USER:= NULL;

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

101: l_cz_imp_devl_project_rec.DELETED_FLAG:= '0'; -- '0' Not deleted
102: l_cz_imp_devl_project_rec.EFF_FROM:= NULL;
103: l_cz_imp_devl_project_rec.EFF_TO:= NULL;
104: l_cz_imp_devl_project_rec.CREATED_BY:= FND_GLOBAL.USER_ID;
105: l_cz_imp_devl_project_rec.LAST_UPDATED_BY:= FND_GLOBAL.USER_ID;
106: l_cz_imp_devl_project_rec.SECURITY_MASK:= NULL;
107: l_cz_imp_devl_project_rec.EFF_MASK:= NULL;
108: l_cz_imp_devl_project_rec.CHECKOUT_USER:= NULL;
109: l_cz_imp_devl_project_rec.RUN_ID:= G_RUN_ID;

Line 106: l_cz_imp_devl_project_rec.SECURITY_MASK:= NULL;

102: l_cz_imp_devl_project_rec.EFF_FROM:= NULL;
103: l_cz_imp_devl_project_rec.EFF_TO:= NULL;
104: l_cz_imp_devl_project_rec.CREATED_BY:= FND_GLOBAL.USER_ID;
105: l_cz_imp_devl_project_rec.LAST_UPDATED_BY:= FND_GLOBAL.USER_ID;
106: l_cz_imp_devl_project_rec.SECURITY_MASK:= NULL;
107: l_cz_imp_devl_project_rec.EFF_MASK:= NULL;
108: l_cz_imp_devl_project_rec.CHECKOUT_USER:= NULL;
109: l_cz_imp_devl_project_rec.RUN_ID:= G_RUN_ID;
110: l_cz_imp_devl_project_rec.REC_STATUS:= NULL;

Line 107: l_cz_imp_devl_project_rec.EFF_MASK:= NULL;

103: l_cz_imp_devl_project_rec.EFF_TO:= NULL;
104: l_cz_imp_devl_project_rec.CREATED_BY:= FND_GLOBAL.USER_ID;
105: l_cz_imp_devl_project_rec.LAST_UPDATED_BY:= FND_GLOBAL.USER_ID;
106: l_cz_imp_devl_project_rec.SECURITY_MASK:= NULL;
107: l_cz_imp_devl_project_rec.EFF_MASK:= NULL;
108: l_cz_imp_devl_project_rec.CHECKOUT_USER:= NULL;
109: l_cz_imp_devl_project_rec.RUN_ID:= G_RUN_ID;
110: l_cz_imp_devl_project_rec.REC_STATUS:= NULL;
111: l_cz_imp_devl_project_rec.DISPOSITION:= NULL;

Line 108: l_cz_imp_devl_project_rec.CHECKOUT_USER:= NULL;

104: l_cz_imp_devl_project_rec.CREATED_BY:= FND_GLOBAL.USER_ID;
105: l_cz_imp_devl_project_rec.LAST_UPDATED_BY:= FND_GLOBAL.USER_ID;
106: l_cz_imp_devl_project_rec.SECURITY_MASK:= NULL;
107: l_cz_imp_devl_project_rec.EFF_MASK:= NULL;
108: l_cz_imp_devl_project_rec.CHECKOUT_USER:= NULL;
109: l_cz_imp_devl_project_rec.RUN_ID:= G_RUN_ID;
110: l_cz_imp_devl_project_rec.REC_STATUS:= NULL;
111: l_cz_imp_devl_project_rec.DISPOSITION:= NULL;
112: l_cz_imp_devl_project_rec.FSK_INTLTEXT_1_1:= NULL;

Line 109: l_cz_imp_devl_project_rec.RUN_ID:= G_RUN_ID;

105: l_cz_imp_devl_project_rec.LAST_UPDATED_BY:= FND_GLOBAL.USER_ID;
106: l_cz_imp_devl_project_rec.SECURITY_MASK:= NULL;
107: l_cz_imp_devl_project_rec.EFF_MASK:= NULL;
108: l_cz_imp_devl_project_rec.CHECKOUT_USER:= NULL;
109: l_cz_imp_devl_project_rec.RUN_ID:= G_RUN_ID;
110: l_cz_imp_devl_project_rec.REC_STATUS:= NULL;
111: l_cz_imp_devl_project_rec.DISPOSITION:= NULL;
112: l_cz_imp_devl_project_rec.FSK_INTLTEXT_1_1:= NULL;
113: l_cz_imp_devl_project_rec.MODEL_ID:= p_model_id;

Line 110: l_cz_imp_devl_project_rec.REC_STATUS:= NULL;

106: l_cz_imp_devl_project_rec.SECURITY_MASK:= NULL;
107: l_cz_imp_devl_project_rec.EFF_MASK:= NULL;
108: l_cz_imp_devl_project_rec.CHECKOUT_USER:= NULL;
109: l_cz_imp_devl_project_rec.RUN_ID:= G_RUN_ID;
110: l_cz_imp_devl_project_rec.REC_STATUS:= NULL;
111: l_cz_imp_devl_project_rec.DISPOSITION:= NULL;
112: l_cz_imp_devl_project_rec.FSK_INTLTEXT_1_1:= NULL;
113: l_cz_imp_devl_project_rec.MODEL_ID:= p_model_id;
114: l_cz_imp_devl_project_rec.PLAN_LEVEL:= 0;

Line 111: l_cz_imp_devl_project_rec.DISPOSITION:= NULL;

107: l_cz_imp_devl_project_rec.EFF_MASK:= NULL;
108: l_cz_imp_devl_project_rec.CHECKOUT_USER:= NULL;
109: l_cz_imp_devl_project_rec.RUN_ID:= G_RUN_ID;
110: l_cz_imp_devl_project_rec.REC_STATUS:= NULL;
111: l_cz_imp_devl_project_rec.DISPOSITION:= NULL;
112: l_cz_imp_devl_project_rec.FSK_INTLTEXT_1_1:= NULL;
113: l_cz_imp_devl_project_rec.MODEL_ID:= p_model_id;
114: l_cz_imp_devl_project_rec.PLAN_LEVEL:= 0;
115: l_cz_imp_devl_project_rec.PERSISTENT_PROJECT_ID:= NULL;

Line 112: l_cz_imp_devl_project_rec.FSK_INTLTEXT_1_1:= NULL;

108: l_cz_imp_devl_project_rec.CHECKOUT_USER:= NULL;
109: l_cz_imp_devl_project_rec.RUN_ID:= G_RUN_ID;
110: l_cz_imp_devl_project_rec.REC_STATUS:= NULL;
111: l_cz_imp_devl_project_rec.DISPOSITION:= NULL;
112: l_cz_imp_devl_project_rec.FSK_INTLTEXT_1_1:= NULL;
113: l_cz_imp_devl_project_rec.MODEL_ID:= p_model_id;
114: l_cz_imp_devl_project_rec.PLAN_LEVEL:= 0;
115: l_cz_imp_devl_project_rec.PERSISTENT_PROJECT_ID:= NULL;
116: l_cz_imp_devl_project_rec.MODEL_TYPE:= 'C'; -- non BOM Model

Line 113: l_cz_imp_devl_project_rec.MODEL_ID:= p_model_id;

109: l_cz_imp_devl_project_rec.RUN_ID:= G_RUN_ID;
110: l_cz_imp_devl_project_rec.REC_STATUS:= NULL;
111: l_cz_imp_devl_project_rec.DISPOSITION:= NULL;
112: l_cz_imp_devl_project_rec.FSK_INTLTEXT_1_1:= NULL;
113: l_cz_imp_devl_project_rec.MODEL_ID:= p_model_id;
114: l_cz_imp_devl_project_rec.PLAN_LEVEL:= 0;
115: l_cz_imp_devl_project_rec.PERSISTENT_PROJECT_ID:= NULL;
116: l_cz_imp_devl_project_rec.MODEL_TYPE:= 'C'; -- non BOM Model
117: l_cz_imp_devl_project_rec.INVENTORY_ITEM_ID:= NULL;

Line 114: l_cz_imp_devl_project_rec.PLAN_LEVEL:= 0;

110: l_cz_imp_devl_project_rec.REC_STATUS:= NULL;
111: l_cz_imp_devl_project_rec.DISPOSITION:= NULL;
112: l_cz_imp_devl_project_rec.FSK_INTLTEXT_1_1:= NULL;
113: l_cz_imp_devl_project_rec.MODEL_ID:= p_model_id;
114: l_cz_imp_devl_project_rec.PLAN_LEVEL:= 0;
115: l_cz_imp_devl_project_rec.PERSISTENT_PROJECT_ID:= NULL;
116: l_cz_imp_devl_project_rec.MODEL_TYPE:= 'C'; -- non BOM Model
117: l_cz_imp_devl_project_rec.INVENTORY_ITEM_ID:= NULL;
118: l_cz_imp_devl_project_rec.PRODUCT_KEY:= NULL;

Line 115: l_cz_imp_devl_project_rec.PERSISTENT_PROJECT_ID:= NULL;

111: l_cz_imp_devl_project_rec.DISPOSITION:= NULL;
112: l_cz_imp_devl_project_rec.FSK_INTLTEXT_1_1:= NULL;
113: l_cz_imp_devl_project_rec.MODEL_ID:= p_model_id;
114: l_cz_imp_devl_project_rec.PLAN_LEVEL:= 0;
115: l_cz_imp_devl_project_rec.PERSISTENT_PROJECT_ID:= NULL;
116: l_cz_imp_devl_project_rec.MODEL_TYPE:= 'C'; -- non BOM Model
117: l_cz_imp_devl_project_rec.INVENTORY_ITEM_ID:= NULL;
118: l_cz_imp_devl_project_rec.PRODUCT_KEY:= NULL;
119: l_cz_imp_devl_project_rec.LAST_UPDATE_LOGIN:= FND_GLOBAL.LOGIN_ID;

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

112: l_cz_imp_devl_project_rec.FSK_INTLTEXT_1_1:= NULL;
113: l_cz_imp_devl_project_rec.MODEL_ID:= p_model_id;
114: l_cz_imp_devl_project_rec.PLAN_LEVEL:= 0;
115: l_cz_imp_devl_project_rec.PERSISTENT_PROJECT_ID:= NULL;
116: l_cz_imp_devl_project_rec.MODEL_TYPE:= 'C'; -- non BOM Model
117: l_cz_imp_devl_project_rec.INVENTORY_ITEM_ID:= NULL;
118: l_cz_imp_devl_project_rec.PRODUCT_KEY:= NULL;
119: l_cz_imp_devl_project_rec.LAST_UPDATE_LOGIN:= FND_GLOBAL.LOGIN_ID;
120: l_cz_imp_devl_project_rec.BOM_CAPTION_RULE_ID:= NULL;

Line 117: l_cz_imp_devl_project_rec.INVENTORY_ITEM_ID:= NULL;

113: l_cz_imp_devl_project_rec.MODEL_ID:= p_model_id;
114: l_cz_imp_devl_project_rec.PLAN_LEVEL:= 0;
115: l_cz_imp_devl_project_rec.PERSISTENT_PROJECT_ID:= NULL;
116: l_cz_imp_devl_project_rec.MODEL_TYPE:= 'C'; -- non BOM Model
117: l_cz_imp_devl_project_rec.INVENTORY_ITEM_ID:= NULL;
118: l_cz_imp_devl_project_rec.PRODUCT_KEY:= NULL;
119: l_cz_imp_devl_project_rec.LAST_UPDATE_LOGIN:= FND_GLOBAL.LOGIN_ID;
120: l_cz_imp_devl_project_rec.BOM_CAPTION_RULE_ID:= NULL;
121: l_cz_imp_devl_project_rec.NONBOM_CAPTION_RULE_ID:= OKC_XPRT_CZ_INT_PVT.G_CAPTION_RULE_DESC; -- display desc in runtime UIs

Line 118: l_cz_imp_devl_project_rec.PRODUCT_KEY:= NULL;

114: l_cz_imp_devl_project_rec.PLAN_LEVEL:= 0;
115: l_cz_imp_devl_project_rec.PERSISTENT_PROJECT_ID:= NULL;
116: l_cz_imp_devl_project_rec.MODEL_TYPE:= 'C'; -- non BOM Model
117: l_cz_imp_devl_project_rec.INVENTORY_ITEM_ID:= NULL;
118: l_cz_imp_devl_project_rec.PRODUCT_KEY:= NULL;
119: l_cz_imp_devl_project_rec.LAST_UPDATE_LOGIN:= FND_GLOBAL.LOGIN_ID;
120: l_cz_imp_devl_project_rec.BOM_CAPTION_RULE_ID:= NULL;
121: l_cz_imp_devl_project_rec.NONBOM_CAPTION_RULE_ID:= OKC_XPRT_CZ_INT_PVT.G_CAPTION_RULE_DESC; -- display desc in runtime UIs
122: l_cz_imp_devl_project_rec.SEEDED_FLAG:= '1'; -- '0' unseeded , '1' seeded

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

115: l_cz_imp_devl_project_rec.PERSISTENT_PROJECT_ID:= NULL;
116: l_cz_imp_devl_project_rec.MODEL_TYPE:= 'C'; -- non BOM Model
117: l_cz_imp_devl_project_rec.INVENTORY_ITEM_ID:= NULL;
118: l_cz_imp_devl_project_rec.PRODUCT_KEY:= NULL;
119: l_cz_imp_devl_project_rec.LAST_UPDATE_LOGIN:= FND_GLOBAL.LOGIN_ID;
120: l_cz_imp_devl_project_rec.BOM_CAPTION_RULE_ID:= NULL;
121: l_cz_imp_devl_project_rec.NONBOM_CAPTION_RULE_ID:= OKC_XPRT_CZ_INT_PVT.G_CAPTION_RULE_DESC; -- display desc in runtime UIs
122: l_cz_imp_devl_project_rec.SEEDED_FLAG:= '1'; -- '0' unseeded , '1' seeded
123:

Line 120: l_cz_imp_devl_project_rec.BOM_CAPTION_RULE_ID:= NULL;

116: l_cz_imp_devl_project_rec.MODEL_TYPE:= 'C'; -- non BOM Model
117: l_cz_imp_devl_project_rec.INVENTORY_ITEM_ID:= NULL;
118: l_cz_imp_devl_project_rec.PRODUCT_KEY:= NULL;
119: l_cz_imp_devl_project_rec.LAST_UPDATE_LOGIN:= FND_GLOBAL.LOGIN_ID;
120: l_cz_imp_devl_project_rec.BOM_CAPTION_RULE_ID:= NULL;
121: l_cz_imp_devl_project_rec.NONBOM_CAPTION_RULE_ID:= OKC_XPRT_CZ_INT_PVT.G_CAPTION_RULE_DESC; -- display desc in runtime UIs
122: l_cz_imp_devl_project_rec.SEEDED_FLAG:= '1'; -- '0' unseeded , '1' seeded
123:
124: --

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

117: l_cz_imp_devl_project_rec.INVENTORY_ITEM_ID:= NULL;
118: l_cz_imp_devl_project_rec.PRODUCT_KEY:= NULL;
119: l_cz_imp_devl_project_rec.LAST_UPDATE_LOGIN:= FND_GLOBAL.LOGIN_ID;
120: l_cz_imp_devl_project_rec.BOM_CAPTION_RULE_ID:= NULL;
121: l_cz_imp_devl_project_rec.NONBOM_CAPTION_RULE_ID:= OKC_XPRT_CZ_INT_PVT.G_CAPTION_RULE_DESC; -- display desc in runtime UIs
122: l_cz_imp_devl_project_rec.SEEDED_FLAG:= '1'; -- '0' unseeded , '1' seeded
123:
124: --
125:

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

118: l_cz_imp_devl_project_rec.PRODUCT_KEY:= NULL;
119: l_cz_imp_devl_project_rec.LAST_UPDATE_LOGIN:= FND_GLOBAL.LOGIN_ID;
120: l_cz_imp_devl_project_rec.BOM_CAPTION_RULE_ID:= NULL;
121: l_cz_imp_devl_project_rec.NONBOM_CAPTION_RULE_ID:= OKC_XPRT_CZ_INT_PVT.G_CAPTION_RULE_DESC; -- display desc in runtime UIs
122: l_cz_imp_devl_project_rec.SEEDED_FLAG:= '1'; -- '0' unseeded , '1' seeded
123:
124: --
125:
126: -- insert the Variable Model Record into cz_devl_project

Line 127: INSERT INTO cz_imp_devl_project

123:
124: --
125:
126: -- insert the Variable Model Record into cz_devl_project
127: INSERT INTO cz_imp_devl_project
128: (
129: DEVL_PROJECT_ID,
130: INTL_TEXT_ID,
131: ORGANIZATION_ID,

Line 166: l_cz_imp_devl_project_rec.DEVL_PROJECT_ID,

162: SEEDED_FLAG
163: )
164: VALUES
165: (
166: l_cz_imp_devl_project_rec.DEVL_PROJECT_ID,
167: l_cz_imp_devl_project_rec.INTL_TEXT_ID,
168: l_cz_imp_devl_project_rec.ORGANIZATION_ID,
169: l_cz_imp_devl_project_rec.NAME,
170: l_cz_imp_devl_project_rec.GSL_FILENAME,

Line 167: l_cz_imp_devl_project_rec.INTL_TEXT_ID,

163: )
164: VALUES
165: (
166: l_cz_imp_devl_project_rec.DEVL_PROJECT_ID,
167: l_cz_imp_devl_project_rec.INTL_TEXT_ID,
168: l_cz_imp_devl_project_rec.ORGANIZATION_ID,
169: l_cz_imp_devl_project_rec.NAME,
170: l_cz_imp_devl_project_rec.GSL_FILENAME,
171: l_cz_imp_devl_project_rec.TOP_ITEM_ID,

Line 168: l_cz_imp_devl_project_rec.ORGANIZATION_ID,

164: VALUES
165: (
166: l_cz_imp_devl_project_rec.DEVL_PROJECT_ID,
167: l_cz_imp_devl_project_rec.INTL_TEXT_ID,
168: l_cz_imp_devl_project_rec.ORGANIZATION_ID,
169: l_cz_imp_devl_project_rec.NAME,
170: l_cz_imp_devl_project_rec.GSL_FILENAME,
171: l_cz_imp_devl_project_rec.TOP_ITEM_ID,
172: l_cz_imp_devl_project_rec.VERSION,

Line 169: l_cz_imp_devl_project_rec.NAME,

165: (
166: l_cz_imp_devl_project_rec.DEVL_PROJECT_ID,
167: l_cz_imp_devl_project_rec.INTL_TEXT_ID,
168: l_cz_imp_devl_project_rec.ORGANIZATION_ID,
169: l_cz_imp_devl_project_rec.NAME,
170: l_cz_imp_devl_project_rec.GSL_FILENAME,
171: l_cz_imp_devl_project_rec.TOP_ITEM_ID,
172: l_cz_imp_devl_project_rec.VERSION,
173: l_cz_imp_devl_project_rec.EXPLOSION_TYPE,

Line 170: l_cz_imp_devl_project_rec.GSL_FILENAME,

166: l_cz_imp_devl_project_rec.DEVL_PROJECT_ID,
167: l_cz_imp_devl_project_rec.INTL_TEXT_ID,
168: l_cz_imp_devl_project_rec.ORGANIZATION_ID,
169: l_cz_imp_devl_project_rec.NAME,
170: l_cz_imp_devl_project_rec.GSL_FILENAME,
171: l_cz_imp_devl_project_rec.TOP_ITEM_ID,
172: l_cz_imp_devl_project_rec.VERSION,
173: l_cz_imp_devl_project_rec.EXPLOSION_TYPE,
174: l_cz_imp_devl_project_rec.DESC_TEXT,

Line 171: l_cz_imp_devl_project_rec.TOP_ITEM_ID,

167: l_cz_imp_devl_project_rec.INTL_TEXT_ID,
168: l_cz_imp_devl_project_rec.ORGANIZATION_ID,
169: l_cz_imp_devl_project_rec.NAME,
170: l_cz_imp_devl_project_rec.GSL_FILENAME,
171: l_cz_imp_devl_project_rec.TOP_ITEM_ID,
172: l_cz_imp_devl_project_rec.VERSION,
173: l_cz_imp_devl_project_rec.EXPLOSION_TYPE,
174: l_cz_imp_devl_project_rec.DESC_TEXT,
175: l_cz_imp_devl_project_rec.ORIG_SYS_REF,

Line 172: l_cz_imp_devl_project_rec.VERSION,

168: l_cz_imp_devl_project_rec.ORGANIZATION_ID,
169: l_cz_imp_devl_project_rec.NAME,
170: l_cz_imp_devl_project_rec.GSL_FILENAME,
171: l_cz_imp_devl_project_rec.TOP_ITEM_ID,
172: l_cz_imp_devl_project_rec.VERSION,
173: l_cz_imp_devl_project_rec.EXPLOSION_TYPE,
174: l_cz_imp_devl_project_rec.DESC_TEXT,
175: l_cz_imp_devl_project_rec.ORIG_SYS_REF,
176: l_cz_imp_devl_project_rec.CREATION_DATE,

Line 173: l_cz_imp_devl_project_rec.EXPLOSION_TYPE,

169: l_cz_imp_devl_project_rec.NAME,
170: l_cz_imp_devl_project_rec.GSL_FILENAME,
171: l_cz_imp_devl_project_rec.TOP_ITEM_ID,
172: l_cz_imp_devl_project_rec.VERSION,
173: l_cz_imp_devl_project_rec.EXPLOSION_TYPE,
174: l_cz_imp_devl_project_rec.DESC_TEXT,
175: l_cz_imp_devl_project_rec.ORIG_SYS_REF,
176: l_cz_imp_devl_project_rec.CREATION_DATE,
177: l_cz_imp_devl_project_rec.LAST_UPDATE_DATE,

Line 174: l_cz_imp_devl_project_rec.DESC_TEXT,

170: l_cz_imp_devl_project_rec.GSL_FILENAME,
171: l_cz_imp_devl_project_rec.TOP_ITEM_ID,
172: l_cz_imp_devl_project_rec.VERSION,
173: l_cz_imp_devl_project_rec.EXPLOSION_TYPE,
174: l_cz_imp_devl_project_rec.DESC_TEXT,
175: l_cz_imp_devl_project_rec.ORIG_SYS_REF,
176: l_cz_imp_devl_project_rec.CREATION_DATE,
177: l_cz_imp_devl_project_rec.LAST_UPDATE_DATE,
178: l_cz_imp_devl_project_rec.DELETED_FLAG,

Line 175: l_cz_imp_devl_project_rec.ORIG_SYS_REF,

171: l_cz_imp_devl_project_rec.TOP_ITEM_ID,
172: l_cz_imp_devl_project_rec.VERSION,
173: l_cz_imp_devl_project_rec.EXPLOSION_TYPE,
174: l_cz_imp_devl_project_rec.DESC_TEXT,
175: l_cz_imp_devl_project_rec.ORIG_SYS_REF,
176: l_cz_imp_devl_project_rec.CREATION_DATE,
177: l_cz_imp_devl_project_rec.LAST_UPDATE_DATE,
178: l_cz_imp_devl_project_rec.DELETED_FLAG,
179: l_cz_imp_devl_project_rec.EFF_FROM,

Line 176: l_cz_imp_devl_project_rec.CREATION_DATE,

172: l_cz_imp_devl_project_rec.VERSION,
173: l_cz_imp_devl_project_rec.EXPLOSION_TYPE,
174: l_cz_imp_devl_project_rec.DESC_TEXT,
175: l_cz_imp_devl_project_rec.ORIG_SYS_REF,
176: l_cz_imp_devl_project_rec.CREATION_DATE,
177: l_cz_imp_devl_project_rec.LAST_UPDATE_DATE,
178: l_cz_imp_devl_project_rec.DELETED_FLAG,
179: l_cz_imp_devl_project_rec.EFF_FROM,
180: l_cz_imp_devl_project_rec.EFF_TO,

Line 177: l_cz_imp_devl_project_rec.LAST_UPDATE_DATE,

173: l_cz_imp_devl_project_rec.EXPLOSION_TYPE,
174: l_cz_imp_devl_project_rec.DESC_TEXT,
175: l_cz_imp_devl_project_rec.ORIG_SYS_REF,
176: l_cz_imp_devl_project_rec.CREATION_DATE,
177: l_cz_imp_devl_project_rec.LAST_UPDATE_DATE,
178: l_cz_imp_devl_project_rec.DELETED_FLAG,
179: l_cz_imp_devl_project_rec.EFF_FROM,
180: l_cz_imp_devl_project_rec.EFF_TO,
181: l_cz_imp_devl_project_rec.CREATED_BY,

Line 178: l_cz_imp_devl_project_rec.DELETED_FLAG,

174: l_cz_imp_devl_project_rec.DESC_TEXT,
175: l_cz_imp_devl_project_rec.ORIG_SYS_REF,
176: l_cz_imp_devl_project_rec.CREATION_DATE,
177: l_cz_imp_devl_project_rec.LAST_UPDATE_DATE,
178: l_cz_imp_devl_project_rec.DELETED_FLAG,
179: l_cz_imp_devl_project_rec.EFF_FROM,
180: l_cz_imp_devl_project_rec.EFF_TO,
181: l_cz_imp_devl_project_rec.CREATED_BY,
182: l_cz_imp_devl_project_rec.LAST_UPDATED_BY,

Line 179: l_cz_imp_devl_project_rec.EFF_FROM,

175: l_cz_imp_devl_project_rec.ORIG_SYS_REF,
176: l_cz_imp_devl_project_rec.CREATION_DATE,
177: l_cz_imp_devl_project_rec.LAST_UPDATE_DATE,
178: l_cz_imp_devl_project_rec.DELETED_FLAG,
179: l_cz_imp_devl_project_rec.EFF_FROM,
180: l_cz_imp_devl_project_rec.EFF_TO,
181: l_cz_imp_devl_project_rec.CREATED_BY,
182: l_cz_imp_devl_project_rec.LAST_UPDATED_BY,
183: l_cz_imp_devl_project_rec.SECURITY_MASK,

Line 180: l_cz_imp_devl_project_rec.EFF_TO,

176: l_cz_imp_devl_project_rec.CREATION_DATE,
177: l_cz_imp_devl_project_rec.LAST_UPDATE_DATE,
178: l_cz_imp_devl_project_rec.DELETED_FLAG,
179: l_cz_imp_devl_project_rec.EFF_FROM,
180: l_cz_imp_devl_project_rec.EFF_TO,
181: l_cz_imp_devl_project_rec.CREATED_BY,
182: l_cz_imp_devl_project_rec.LAST_UPDATED_BY,
183: l_cz_imp_devl_project_rec.SECURITY_MASK,
184: l_cz_imp_devl_project_rec.EFF_MASK,

Line 181: l_cz_imp_devl_project_rec.CREATED_BY,

177: l_cz_imp_devl_project_rec.LAST_UPDATE_DATE,
178: l_cz_imp_devl_project_rec.DELETED_FLAG,
179: l_cz_imp_devl_project_rec.EFF_FROM,
180: l_cz_imp_devl_project_rec.EFF_TO,
181: l_cz_imp_devl_project_rec.CREATED_BY,
182: l_cz_imp_devl_project_rec.LAST_UPDATED_BY,
183: l_cz_imp_devl_project_rec.SECURITY_MASK,
184: l_cz_imp_devl_project_rec.EFF_MASK,
185: l_cz_imp_devl_project_rec.CHECKOUT_USER,

Line 182: l_cz_imp_devl_project_rec.LAST_UPDATED_BY,

178: l_cz_imp_devl_project_rec.DELETED_FLAG,
179: l_cz_imp_devl_project_rec.EFF_FROM,
180: l_cz_imp_devl_project_rec.EFF_TO,
181: l_cz_imp_devl_project_rec.CREATED_BY,
182: l_cz_imp_devl_project_rec.LAST_UPDATED_BY,
183: l_cz_imp_devl_project_rec.SECURITY_MASK,
184: l_cz_imp_devl_project_rec.EFF_MASK,
185: l_cz_imp_devl_project_rec.CHECKOUT_USER,
186: l_cz_imp_devl_project_rec.RUN_ID,

Line 183: l_cz_imp_devl_project_rec.SECURITY_MASK,

179: l_cz_imp_devl_project_rec.EFF_FROM,
180: l_cz_imp_devl_project_rec.EFF_TO,
181: l_cz_imp_devl_project_rec.CREATED_BY,
182: l_cz_imp_devl_project_rec.LAST_UPDATED_BY,
183: l_cz_imp_devl_project_rec.SECURITY_MASK,
184: l_cz_imp_devl_project_rec.EFF_MASK,
185: l_cz_imp_devl_project_rec.CHECKOUT_USER,
186: l_cz_imp_devl_project_rec.RUN_ID,
187: l_cz_imp_devl_project_rec.REC_STATUS,

Line 184: l_cz_imp_devl_project_rec.EFF_MASK,

180: l_cz_imp_devl_project_rec.EFF_TO,
181: l_cz_imp_devl_project_rec.CREATED_BY,
182: l_cz_imp_devl_project_rec.LAST_UPDATED_BY,
183: l_cz_imp_devl_project_rec.SECURITY_MASK,
184: l_cz_imp_devl_project_rec.EFF_MASK,
185: l_cz_imp_devl_project_rec.CHECKOUT_USER,
186: l_cz_imp_devl_project_rec.RUN_ID,
187: l_cz_imp_devl_project_rec.REC_STATUS,
188: l_cz_imp_devl_project_rec.DISPOSITION,

Line 185: l_cz_imp_devl_project_rec.CHECKOUT_USER,

181: l_cz_imp_devl_project_rec.CREATED_BY,
182: l_cz_imp_devl_project_rec.LAST_UPDATED_BY,
183: l_cz_imp_devl_project_rec.SECURITY_MASK,
184: l_cz_imp_devl_project_rec.EFF_MASK,
185: l_cz_imp_devl_project_rec.CHECKOUT_USER,
186: l_cz_imp_devl_project_rec.RUN_ID,
187: l_cz_imp_devl_project_rec.REC_STATUS,
188: l_cz_imp_devl_project_rec.DISPOSITION,
189: l_cz_imp_devl_project_rec.FSK_INTLTEXT_1_1,

Line 186: l_cz_imp_devl_project_rec.RUN_ID,

182: l_cz_imp_devl_project_rec.LAST_UPDATED_BY,
183: l_cz_imp_devl_project_rec.SECURITY_MASK,
184: l_cz_imp_devl_project_rec.EFF_MASK,
185: l_cz_imp_devl_project_rec.CHECKOUT_USER,
186: l_cz_imp_devl_project_rec.RUN_ID,
187: l_cz_imp_devl_project_rec.REC_STATUS,
188: l_cz_imp_devl_project_rec.DISPOSITION,
189: l_cz_imp_devl_project_rec.FSK_INTLTEXT_1_1,
190: l_cz_imp_devl_project_rec.MODEL_ID,

Line 187: l_cz_imp_devl_project_rec.REC_STATUS,

183: l_cz_imp_devl_project_rec.SECURITY_MASK,
184: l_cz_imp_devl_project_rec.EFF_MASK,
185: l_cz_imp_devl_project_rec.CHECKOUT_USER,
186: l_cz_imp_devl_project_rec.RUN_ID,
187: l_cz_imp_devl_project_rec.REC_STATUS,
188: l_cz_imp_devl_project_rec.DISPOSITION,
189: l_cz_imp_devl_project_rec.FSK_INTLTEXT_1_1,
190: l_cz_imp_devl_project_rec.MODEL_ID,
191: l_cz_imp_devl_project_rec.PLAN_LEVEL,

Line 188: l_cz_imp_devl_project_rec.DISPOSITION,

184: l_cz_imp_devl_project_rec.EFF_MASK,
185: l_cz_imp_devl_project_rec.CHECKOUT_USER,
186: l_cz_imp_devl_project_rec.RUN_ID,
187: l_cz_imp_devl_project_rec.REC_STATUS,
188: l_cz_imp_devl_project_rec.DISPOSITION,
189: l_cz_imp_devl_project_rec.FSK_INTLTEXT_1_1,
190: l_cz_imp_devl_project_rec.MODEL_ID,
191: l_cz_imp_devl_project_rec.PLAN_LEVEL,
192: l_cz_imp_devl_project_rec.PERSISTENT_PROJECT_ID,

Line 189: l_cz_imp_devl_project_rec.FSK_INTLTEXT_1_1,

185: l_cz_imp_devl_project_rec.CHECKOUT_USER,
186: l_cz_imp_devl_project_rec.RUN_ID,
187: l_cz_imp_devl_project_rec.REC_STATUS,
188: l_cz_imp_devl_project_rec.DISPOSITION,
189: l_cz_imp_devl_project_rec.FSK_INTLTEXT_1_1,
190: l_cz_imp_devl_project_rec.MODEL_ID,
191: l_cz_imp_devl_project_rec.PLAN_LEVEL,
192: l_cz_imp_devl_project_rec.PERSISTENT_PROJECT_ID,
193: l_cz_imp_devl_project_rec.MODEL_TYPE,

Line 190: l_cz_imp_devl_project_rec.MODEL_ID,

186: l_cz_imp_devl_project_rec.RUN_ID,
187: l_cz_imp_devl_project_rec.REC_STATUS,
188: l_cz_imp_devl_project_rec.DISPOSITION,
189: l_cz_imp_devl_project_rec.FSK_INTLTEXT_1_1,
190: l_cz_imp_devl_project_rec.MODEL_ID,
191: l_cz_imp_devl_project_rec.PLAN_LEVEL,
192: l_cz_imp_devl_project_rec.PERSISTENT_PROJECT_ID,
193: l_cz_imp_devl_project_rec.MODEL_TYPE,
194: l_cz_imp_devl_project_rec.INVENTORY_ITEM_ID,

Line 191: l_cz_imp_devl_project_rec.PLAN_LEVEL,

187: l_cz_imp_devl_project_rec.REC_STATUS,
188: l_cz_imp_devl_project_rec.DISPOSITION,
189: l_cz_imp_devl_project_rec.FSK_INTLTEXT_1_1,
190: l_cz_imp_devl_project_rec.MODEL_ID,
191: l_cz_imp_devl_project_rec.PLAN_LEVEL,
192: l_cz_imp_devl_project_rec.PERSISTENT_PROJECT_ID,
193: l_cz_imp_devl_project_rec.MODEL_TYPE,
194: l_cz_imp_devl_project_rec.INVENTORY_ITEM_ID,
195: l_cz_imp_devl_project_rec.PRODUCT_KEY,

Line 192: l_cz_imp_devl_project_rec.PERSISTENT_PROJECT_ID,

188: l_cz_imp_devl_project_rec.DISPOSITION,
189: l_cz_imp_devl_project_rec.FSK_INTLTEXT_1_1,
190: l_cz_imp_devl_project_rec.MODEL_ID,
191: l_cz_imp_devl_project_rec.PLAN_LEVEL,
192: l_cz_imp_devl_project_rec.PERSISTENT_PROJECT_ID,
193: l_cz_imp_devl_project_rec.MODEL_TYPE,
194: l_cz_imp_devl_project_rec.INVENTORY_ITEM_ID,
195: l_cz_imp_devl_project_rec.PRODUCT_KEY,
196: l_cz_imp_devl_project_rec.LAST_UPDATE_LOGIN,

Line 193: l_cz_imp_devl_project_rec.MODEL_TYPE,

189: l_cz_imp_devl_project_rec.FSK_INTLTEXT_1_1,
190: l_cz_imp_devl_project_rec.MODEL_ID,
191: l_cz_imp_devl_project_rec.PLAN_LEVEL,
192: l_cz_imp_devl_project_rec.PERSISTENT_PROJECT_ID,
193: l_cz_imp_devl_project_rec.MODEL_TYPE,
194: l_cz_imp_devl_project_rec.INVENTORY_ITEM_ID,
195: l_cz_imp_devl_project_rec.PRODUCT_KEY,
196: l_cz_imp_devl_project_rec.LAST_UPDATE_LOGIN,
197: l_cz_imp_devl_project_rec.BOM_CAPTION_RULE_ID,

Line 194: l_cz_imp_devl_project_rec.INVENTORY_ITEM_ID,

190: l_cz_imp_devl_project_rec.MODEL_ID,
191: l_cz_imp_devl_project_rec.PLAN_LEVEL,
192: l_cz_imp_devl_project_rec.PERSISTENT_PROJECT_ID,
193: l_cz_imp_devl_project_rec.MODEL_TYPE,
194: l_cz_imp_devl_project_rec.INVENTORY_ITEM_ID,
195: l_cz_imp_devl_project_rec.PRODUCT_KEY,
196: l_cz_imp_devl_project_rec.LAST_UPDATE_LOGIN,
197: l_cz_imp_devl_project_rec.BOM_CAPTION_RULE_ID,
198: l_cz_imp_devl_project_rec.NONBOM_CAPTION_RULE_ID,

Line 195: l_cz_imp_devl_project_rec.PRODUCT_KEY,

191: l_cz_imp_devl_project_rec.PLAN_LEVEL,
192: l_cz_imp_devl_project_rec.PERSISTENT_PROJECT_ID,
193: l_cz_imp_devl_project_rec.MODEL_TYPE,
194: l_cz_imp_devl_project_rec.INVENTORY_ITEM_ID,
195: l_cz_imp_devl_project_rec.PRODUCT_KEY,
196: l_cz_imp_devl_project_rec.LAST_UPDATE_LOGIN,
197: l_cz_imp_devl_project_rec.BOM_CAPTION_RULE_ID,
198: l_cz_imp_devl_project_rec.NONBOM_CAPTION_RULE_ID,
199: l_cz_imp_devl_project_rec.SEEDED_FLAG

Line 196: l_cz_imp_devl_project_rec.LAST_UPDATE_LOGIN,

192: l_cz_imp_devl_project_rec.PERSISTENT_PROJECT_ID,
193: l_cz_imp_devl_project_rec.MODEL_TYPE,
194: l_cz_imp_devl_project_rec.INVENTORY_ITEM_ID,
195: l_cz_imp_devl_project_rec.PRODUCT_KEY,
196: l_cz_imp_devl_project_rec.LAST_UPDATE_LOGIN,
197: l_cz_imp_devl_project_rec.BOM_CAPTION_RULE_ID,
198: l_cz_imp_devl_project_rec.NONBOM_CAPTION_RULE_ID,
199: l_cz_imp_devl_project_rec.SEEDED_FLAG
200: );

Line 197: l_cz_imp_devl_project_rec.BOM_CAPTION_RULE_ID,

193: l_cz_imp_devl_project_rec.MODEL_TYPE,
194: l_cz_imp_devl_project_rec.INVENTORY_ITEM_ID,
195: l_cz_imp_devl_project_rec.PRODUCT_KEY,
196: l_cz_imp_devl_project_rec.LAST_UPDATE_LOGIN,
197: l_cz_imp_devl_project_rec.BOM_CAPTION_RULE_ID,
198: l_cz_imp_devl_project_rec.NONBOM_CAPTION_RULE_ID,
199: l_cz_imp_devl_project_rec.SEEDED_FLAG
200: );
201:

Line 198: l_cz_imp_devl_project_rec.NONBOM_CAPTION_RULE_ID,

194: l_cz_imp_devl_project_rec.INVENTORY_ITEM_ID,
195: l_cz_imp_devl_project_rec.PRODUCT_KEY,
196: l_cz_imp_devl_project_rec.LAST_UPDATE_LOGIN,
197: l_cz_imp_devl_project_rec.BOM_CAPTION_RULE_ID,
198: l_cz_imp_devl_project_rec.NONBOM_CAPTION_RULE_ID,
199: l_cz_imp_devl_project_rec.SEEDED_FLAG
200: );
201:
202:

Line 199: l_cz_imp_devl_project_rec.SEEDED_FLAG

195: l_cz_imp_devl_project_rec.PRODUCT_KEY,
196: l_cz_imp_devl_project_rec.LAST_UPDATE_LOGIN,
197: l_cz_imp_devl_project_rec.BOM_CAPTION_RULE_ID,
198: l_cz_imp_devl_project_rec.NONBOM_CAPTION_RULE_ID,
199: l_cz_imp_devl_project_rec.SEEDED_FLAG
200: );
201:
202:
203: -- Standard call to get message count and if count is 1, get message info.

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

356: l_cz_imp_ps_nodes_rec.EXPLOSION_TYPE:= NULL;
357: l_cz_imp_ps_nodes_rec.NAME:= G_VARIABLE_MODEL_TOPNODE_OSR||p_intent;
358: l_cz_imp_ps_nodes_rec.ORIG_SYS_REF:= G_VARIABLE_MODEL_TOPNODE_OSR||p_intent;
359: l_cz_imp_ps_nodes_rec.RESOURCE_FLAG:= NULL;
360: l_cz_imp_ps_nodes_rec.TOP_ITEM_ID:= 1; -- same value as in cz_imp_devl_projects
361: l_cz_imp_ps_nodes_rec.INITIAL_VALUE:= NULL;
362: l_cz_imp_ps_nodes_rec.PARENT_ID:= NULL;
363: l_cz_imp_ps_nodes_rec.MINIMUM:= 1;
364: l_cz_imp_ps_nodes_rec.MAXIMUM:= 1;

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

996: DECODE(variableDatatype_tbl(i), 'LN', G_VAR_MODEL_TEXT_FEATURE_OSR||p_intent||':'||variableCode_tbl(i), -- ORIG_SYS_REF for Line Number
997: 'DR', G_VAR_MODEL_DEVI_FEATURE_OSR||p_intent||':'||variableCode_tbl(i), -- ORIG_SYS_REF for Deviation Rule
998: G_VARIABLE_MODEL_FEATURE_OSR||p_intent||':'||variableCode_tbl(i)), -- ORIG_SYS_REF
999: NULL, --RESOURCE_FLAG
1000: 1, --TOP_ITEM_ID -- same value as in cz_imp_devl_projects
1001: NULL, --INITIAL_VALUE
1002: NULL, --PARENT_ID
1003: -- 0, --MINIMUM -- Commented for Bug 4090738
1004: DECODE(variableDatatype_tbl(i),'N',NULL,0), --MINIMUM -- Added for Bug 4090738

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

1388: NULL, --EXPLOSION_TYPE,
1389: variableOption_tbl(i), --NAME
1390: G_VARIABLE_MODEL_OPTION_OSR||p_intent||':'||variableCode_tbl(i)||':'||variableOption_tbl(i), --ORIG_SYS_REF
1391: NULL, --RESOURCE_FLAG
1392: 1, --TOP_ITEM_ID -- same value as in cz_imp_devl_projects
1393: NULL, --INITIAL_VALUE
1394: NULL, --PARENT_ID
1395: 0, --MINIMUM
1396: NULL, --MAXIMUM