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

Line 71: l_cz_imp_devl_project_rec CZ_IMP_DEVL_PROJECT%ROWTYPE;

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

Line 73: l_model_desc CZ_IMP_DEVL_PROJECT.DESC_TEXT%TYPE;

69: ) IS
70:
71: l_cz_imp_devl_project_rec CZ_IMP_DEVL_PROJECT%ROWTYPE;
72: l_api_name CONSTANT VARCHAR2(30) := 'create_clause_model';
73: l_model_desc CZ_IMP_DEVL_PROJECT.DESC_TEXT%TYPE;
74:
75: BEGIN
76:
77: -- start debug log

Line 93: -- populate the l_cz_imp_devl_project_rec

89: FND_MESSAGE.set_token('INTENT_MEANING',okc_util.decode_lookup('OKC_ARTICLE_INTENT',p_intent));
90: l_model_desc := FND_MESSAGE.get;
91:
92:
93: -- populate the l_cz_imp_devl_project_rec
94: l_cz_imp_devl_project_rec.DEVL_PROJECT_ID:= NULL;
95: l_cz_imp_devl_project_rec.INTL_TEXT_ID:= NULL;
96: l_cz_imp_devl_project_rec.ORGANIZATION_ID:= p_org_id;
97: l_cz_imp_devl_project_rec.NAME:= G_CLAUSE_MODEL_OSR||p_org_id||':'||p_intent ;

Line 94: l_cz_imp_devl_project_rec.DEVL_PROJECT_ID:= NULL;

90: l_model_desc := FND_MESSAGE.get;
91:
92:
93: -- populate the l_cz_imp_devl_project_rec
94: l_cz_imp_devl_project_rec.DEVL_PROJECT_ID:= NULL;
95: l_cz_imp_devl_project_rec.INTL_TEXT_ID:= NULL;
96: l_cz_imp_devl_project_rec.ORGANIZATION_ID:= p_org_id;
97: l_cz_imp_devl_project_rec.NAME:= G_CLAUSE_MODEL_OSR||p_org_id||':'||p_intent ;
98: l_cz_imp_devl_project_rec.GSL_FILENAME:= NULL;

Line 95: l_cz_imp_devl_project_rec.INTL_TEXT_ID:= NULL;

91:
92:
93: -- populate the l_cz_imp_devl_project_rec
94: l_cz_imp_devl_project_rec.DEVL_PROJECT_ID:= NULL;
95: l_cz_imp_devl_project_rec.INTL_TEXT_ID:= NULL;
96: l_cz_imp_devl_project_rec.ORGANIZATION_ID:= p_org_id;
97: l_cz_imp_devl_project_rec.NAME:= G_CLAUSE_MODEL_OSR||p_org_id||':'||p_intent ;
98: l_cz_imp_devl_project_rec.GSL_FILENAME:= NULL;
99: l_cz_imp_devl_project_rec.TOP_ITEM_ID:= 1;

Line 96: l_cz_imp_devl_project_rec.ORGANIZATION_ID:= p_org_id;

92:
93: -- populate the l_cz_imp_devl_project_rec
94: l_cz_imp_devl_project_rec.DEVL_PROJECT_ID:= NULL;
95: l_cz_imp_devl_project_rec.INTL_TEXT_ID:= NULL;
96: l_cz_imp_devl_project_rec.ORGANIZATION_ID:= p_org_id;
97: l_cz_imp_devl_project_rec.NAME:= G_CLAUSE_MODEL_OSR||p_org_id||':'||p_intent ;
98: l_cz_imp_devl_project_rec.GSL_FILENAME:= NULL;
99: l_cz_imp_devl_project_rec.TOP_ITEM_ID:= 1;
100: l_cz_imp_devl_project_rec.VERSION:= NULL;

Line 97: l_cz_imp_devl_project_rec.NAME:= G_CLAUSE_MODEL_OSR||p_org_id||':'||p_intent ;

93: -- populate the l_cz_imp_devl_project_rec
94: l_cz_imp_devl_project_rec.DEVL_PROJECT_ID:= NULL;
95: l_cz_imp_devl_project_rec.INTL_TEXT_ID:= NULL;
96: l_cz_imp_devl_project_rec.ORGANIZATION_ID:= p_org_id;
97: l_cz_imp_devl_project_rec.NAME:= G_CLAUSE_MODEL_OSR||p_org_id||':'||p_intent ;
98: l_cz_imp_devl_project_rec.GSL_FILENAME:= NULL;
99: l_cz_imp_devl_project_rec.TOP_ITEM_ID:= 1;
100: l_cz_imp_devl_project_rec.VERSION:= NULL;
101: l_cz_imp_devl_project_rec.EXPLOSION_TYPE:= NULL;

Line 98: l_cz_imp_devl_project_rec.GSL_FILENAME:= NULL;

94: l_cz_imp_devl_project_rec.DEVL_PROJECT_ID:= NULL;
95: l_cz_imp_devl_project_rec.INTL_TEXT_ID:= NULL;
96: l_cz_imp_devl_project_rec.ORGANIZATION_ID:= p_org_id;
97: l_cz_imp_devl_project_rec.NAME:= G_CLAUSE_MODEL_OSR||p_org_id||':'||p_intent ;
98: l_cz_imp_devl_project_rec.GSL_FILENAME:= NULL;
99: l_cz_imp_devl_project_rec.TOP_ITEM_ID:= 1;
100: l_cz_imp_devl_project_rec.VERSION:= NULL;
101: l_cz_imp_devl_project_rec.EXPLOSION_TYPE:= NULL;
102: l_cz_imp_devl_project_rec.DESC_TEXT:= l_model_desc;

Line 99: l_cz_imp_devl_project_rec.TOP_ITEM_ID:= 1;

95: l_cz_imp_devl_project_rec.INTL_TEXT_ID:= NULL;
96: l_cz_imp_devl_project_rec.ORGANIZATION_ID:= p_org_id;
97: l_cz_imp_devl_project_rec.NAME:= G_CLAUSE_MODEL_OSR||p_org_id||':'||p_intent ;
98: l_cz_imp_devl_project_rec.GSL_FILENAME:= NULL;
99: l_cz_imp_devl_project_rec.TOP_ITEM_ID:= 1;
100: l_cz_imp_devl_project_rec.VERSION:= NULL;
101: l_cz_imp_devl_project_rec.EXPLOSION_TYPE:= NULL;
102: l_cz_imp_devl_project_rec.DESC_TEXT:= l_model_desc;
103: l_cz_imp_devl_project_rec.ORIG_SYS_REF:= G_CLAUSE_MODEL_OSR||p_org_id||':'||p_intent ;

Line 100: l_cz_imp_devl_project_rec.VERSION:= NULL;

96: l_cz_imp_devl_project_rec.ORGANIZATION_ID:= p_org_id;
97: l_cz_imp_devl_project_rec.NAME:= G_CLAUSE_MODEL_OSR||p_org_id||':'||p_intent ;
98: l_cz_imp_devl_project_rec.GSL_FILENAME:= NULL;
99: l_cz_imp_devl_project_rec.TOP_ITEM_ID:= 1;
100: l_cz_imp_devl_project_rec.VERSION:= NULL;
101: l_cz_imp_devl_project_rec.EXPLOSION_TYPE:= NULL;
102: l_cz_imp_devl_project_rec.DESC_TEXT:= l_model_desc;
103: l_cz_imp_devl_project_rec.ORIG_SYS_REF:= G_CLAUSE_MODEL_OSR||p_org_id||':'||p_intent ;
104: l_cz_imp_devl_project_rec.CREATION_DATE:= SYSDATE;

Line 101: l_cz_imp_devl_project_rec.EXPLOSION_TYPE:= NULL;

97: l_cz_imp_devl_project_rec.NAME:= G_CLAUSE_MODEL_OSR||p_org_id||':'||p_intent ;
98: l_cz_imp_devl_project_rec.GSL_FILENAME:= NULL;
99: l_cz_imp_devl_project_rec.TOP_ITEM_ID:= 1;
100: l_cz_imp_devl_project_rec.VERSION:= NULL;
101: l_cz_imp_devl_project_rec.EXPLOSION_TYPE:= NULL;
102: l_cz_imp_devl_project_rec.DESC_TEXT:= l_model_desc;
103: l_cz_imp_devl_project_rec.ORIG_SYS_REF:= G_CLAUSE_MODEL_OSR||p_org_id||':'||p_intent ;
104: l_cz_imp_devl_project_rec.CREATION_DATE:= SYSDATE;
105: l_cz_imp_devl_project_rec.LAST_UPDATE_DATE:= SYSDATE;

Line 102: l_cz_imp_devl_project_rec.DESC_TEXT:= l_model_desc;

98: l_cz_imp_devl_project_rec.GSL_FILENAME:= NULL;
99: l_cz_imp_devl_project_rec.TOP_ITEM_ID:= 1;
100: l_cz_imp_devl_project_rec.VERSION:= NULL;
101: l_cz_imp_devl_project_rec.EXPLOSION_TYPE:= NULL;
102: l_cz_imp_devl_project_rec.DESC_TEXT:= l_model_desc;
103: l_cz_imp_devl_project_rec.ORIG_SYS_REF:= G_CLAUSE_MODEL_OSR||p_org_id||':'||p_intent ;
104: l_cz_imp_devl_project_rec.CREATION_DATE:= SYSDATE;
105: l_cz_imp_devl_project_rec.LAST_UPDATE_DATE:= SYSDATE;
106: l_cz_imp_devl_project_rec.DELETED_FLAG:= '0'; -- '0' Not deleted

Line 103: l_cz_imp_devl_project_rec.ORIG_SYS_REF:= G_CLAUSE_MODEL_OSR||p_org_id||':'||p_intent ;

99: l_cz_imp_devl_project_rec.TOP_ITEM_ID:= 1;
100: l_cz_imp_devl_project_rec.VERSION:= NULL;
101: l_cz_imp_devl_project_rec.EXPLOSION_TYPE:= NULL;
102: l_cz_imp_devl_project_rec.DESC_TEXT:= l_model_desc;
103: l_cz_imp_devl_project_rec.ORIG_SYS_REF:= G_CLAUSE_MODEL_OSR||p_org_id||':'||p_intent ;
104: l_cz_imp_devl_project_rec.CREATION_DATE:= SYSDATE;
105: l_cz_imp_devl_project_rec.LAST_UPDATE_DATE:= SYSDATE;
106: l_cz_imp_devl_project_rec.DELETED_FLAG:= '0'; -- '0' Not deleted
107: l_cz_imp_devl_project_rec.EFF_FROM:= NULL;

Line 104: l_cz_imp_devl_project_rec.CREATION_DATE:= SYSDATE;

100: l_cz_imp_devl_project_rec.VERSION:= NULL;
101: l_cz_imp_devl_project_rec.EXPLOSION_TYPE:= NULL;
102: l_cz_imp_devl_project_rec.DESC_TEXT:= l_model_desc;
103: l_cz_imp_devl_project_rec.ORIG_SYS_REF:= G_CLAUSE_MODEL_OSR||p_org_id||':'||p_intent ;
104: l_cz_imp_devl_project_rec.CREATION_DATE:= SYSDATE;
105: l_cz_imp_devl_project_rec.LAST_UPDATE_DATE:= SYSDATE;
106: l_cz_imp_devl_project_rec.DELETED_FLAG:= '0'; -- '0' Not deleted
107: l_cz_imp_devl_project_rec.EFF_FROM:= NULL;
108: l_cz_imp_devl_project_rec.EFF_TO:= NULL;

Line 105: l_cz_imp_devl_project_rec.LAST_UPDATE_DATE:= SYSDATE;

101: l_cz_imp_devl_project_rec.EXPLOSION_TYPE:= NULL;
102: l_cz_imp_devl_project_rec.DESC_TEXT:= l_model_desc;
103: l_cz_imp_devl_project_rec.ORIG_SYS_REF:= G_CLAUSE_MODEL_OSR||p_org_id||':'||p_intent ;
104: l_cz_imp_devl_project_rec.CREATION_DATE:= SYSDATE;
105: l_cz_imp_devl_project_rec.LAST_UPDATE_DATE:= SYSDATE;
106: l_cz_imp_devl_project_rec.DELETED_FLAG:= '0'; -- '0' Not deleted
107: l_cz_imp_devl_project_rec.EFF_FROM:= NULL;
108: l_cz_imp_devl_project_rec.EFF_TO:= NULL;
109: l_cz_imp_devl_project_rec.CREATED_BY:= FND_GLOBAL.USER_ID;

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

102: l_cz_imp_devl_project_rec.DESC_TEXT:= l_model_desc;
103: l_cz_imp_devl_project_rec.ORIG_SYS_REF:= G_CLAUSE_MODEL_OSR||p_org_id||':'||p_intent ;
104: l_cz_imp_devl_project_rec.CREATION_DATE:= SYSDATE;
105: l_cz_imp_devl_project_rec.LAST_UPDATE_DATE:= SYSDATE;
106: l_cz_imp_devl_project_rec.DELETED_FLAG:= '0'; -- '0' Not deleted
107: l_cz_imp_devl_project_rec.EFF_FROM:= NULL;
108: l_cz_imp_devl_project_rec.EFF_TO:= NULL;
109: l_cz_imp_devl_project_rec.CREATED_BY:= FND_GLOBAL.USER_ID;
110: l_cz_imp_devl_project_rec.LAST_UPDATED_BY:= FND_GLOBAL.USER_ID;

Line 107: l_cz_imp_devl_project_rec.EFF_FROM:= NULL;

103: l_cz_imp_devl_project_rec.ORIG_SYS_REF:= G_CLAUSE_MODEL_OSR||p_org_id||':'||p_intent ;
104: l_cz_imp_devl_project_rec.CREATION_DATE:= SYSDATE;
105: l_cz_imp_devl_project_rec.LAST_UPDATE_DATE:= SYSDATE;
106: l_cz_imp_devl_project_rec.DELETED_FLAG:= '0'; -- '0' Not deleted
107: l_cz_imp_devl_project_rec.EFF_FROM:= NULL;
108: l_cz_imp_devl_project_rec.EFF_TO:= NULL;
109: l_cz_imp_devl_project_rec.CREATED_BY:= FND_GLOBAL.USER_ID;
110: l_cz_imp_devl_project_rec.LAST_UPDATED_BY:= FND_GLOBAL.USER_ID;
111: l_cz_imp_devl_project_rec.SECURITY_MASK:= NULL;

Line 108: l_cz_imp_devl_project_rec.EFF_TO:= NULL;

104: l_cz_imp_devl_project_rec.CREATION_DATE:= SYSDATE;
105: l_cz_imp_devl_project_rec.LAST_UPDATE_DATE:= SYSDATE;
106: l_cz_imp_devl_project_rec.DELETED_FLAG:= '0'; -- '0' Not deleted
107: l_cz_imp_devl_project_rec.EFF_FROM:= NULL;
108: l_cz_imp_devl_project_rec.EFF_TO:= NULL;
109: l_cz_imp_devl_project_rec.CREATED_BY:= FND_GLOBAL.USER_ID;
110: l_cz_imp_devl_project_rec.LAST_UPDATED_BY:= FND_GLOBAL.USER_ID;
111: l_cz_imp_devl_project_rec.SECURITY_MASK:= NULL;
112: l_cz_imp_devl_project_rec.EFF_MASK:= NULL;

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

105: l_cz_imp_devl_project_rec.LAST_UPDATE_DATE:= SYSDATE;
106: l_cz_imp_devl_project_rec.DELETED_FLAG:= '0'; -- '0' Not deleted
107: l_cz_imp_devl_project_rec.EFF_FROM:= NULL;
108: l_cz_imp_devl_project_rec.EFF_TO:= NULL;
109: l_cz_imp_devl_project_rec.CREATED_BY:= FND_GLOBAL.USER_ID;
110: l_cz_imp_devl_project_rec.LAST_UPDATED_BY:= FND_GLOBAL.USER_ID;
111: l_cz_imp_devl_project_rec.SECURITY_MASK:= NULL;
112: l_cz_imp_devl_project_rec.EFF_MASK:= NULL;
113: l_cz_imp_devl_project_rec.CHECKOUT_USER:= NULL;

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

106: l_cz_imp_devl_project_rec.DELETED_FLAG:= '0'; -- '0' Not deleted
107: l_cz_imp_devl_project_rec.EFF_FROM:= NULL;
108: l_cz_imp_devl_project_rec.EFF_TO:= NULL;
109: l_cz_imp_devl_project_rec.CREATED_BY:= FND_GLOBAL.USER_ID;
110: l_cz_imp_devl_project_rec.LAST_UPDATED_BY:= FND_GLOBAL.USER_ID;
111: l_cz_imp_devl_project_rec.SECURITY_MASK:= NULL;
112: l_cz_imp_devl_project_rec.EFF_MASK:= NULL;
113: l_cz_imp_devl_project_rec.CHECKOUT_USER:= NULL;
114: l_cz_imp_devl_project_rec.RUN_ID:= G_RUN_ID;

Line 111: l_cz_imp_devl_project_rec.SECURITY_MASK:= NULL;

107: l_cz_imp_devl_project_rec.EFF_FROM:= NULL;
108: l_cz_imp_devl_project_rec.EFF_TO:= NULL;
109: l_cz_imp_devl_project_rec.CREATED_BY:= FND_GLOBAL.USER_ID;
110: l_cz_imp_devl_project_rec.LAST_UPDATED_BY:= FND_GLOBAL.USER_ID;
111: l_cz_imp_devl_project_rec.SECURITY_MASK:= NULL;
112: l_cz_imp_devl_project_rec.EFF_MASK:= NULL;
113: l_cz_imp_devl_project_rec.CHECKOUT_USER:= NULL;
114: l_cz_imp_devl_project_rec.RUN_ID:= G_RUN_ID;
115: l_cz_imp_devl_project_rec.REC_STATUS:= NULL;

Line 112: l_cz_imp_devl_project_rec.EFF_MASK:= NULL;

108: l_cz_imp_devl_project_rec.EFF_TO:= NULL;
109: l_cz_imp_devl_project_rec.CREATED_BY:= FND_GLOBAL.USER_ID;
110: l_cz_imp_devl_project_rec.LAST_UPDATED_BY:= FND_GLOBAL.USER_ID;
111: l_cz_imp_devl_project_rec.SECURITY_MASK:= NULL;
112: l_cz_imp_devl_project_rec.EFF_MASK:= NULL;
113: l_cz_imp_devl_project_rec.CHECKOUT_USER:= NULL;
114: l_cz_imp_devl_project_rec.RUN_ID:= G_RUN_ID;
115: l_cz_imp_devl_project_rec.REC_STATUS:= NULL;
116: l_cz_imp_devl_project_rec.DISPOSITION:= NULL;

Line 113: l_cz_imp_devl_project_rec.CHECKOUT_USER:= NULL;

109: l_cz_imp_devl_project_rec.CREATED_BY:= FND_GLOBAL.USER_ID;
110: l_cz_imp_devl_project_rec.LAST_UPDATED_BY:= FND_GLOBAL.USER_ID;
111: l_cz_imp_devl_project_rec.SECURITY_MASK:= NULL;
112: l_cz_imp_devl_project_rec.EFF_MASK:= NULL;
113: l_cz_imp_devl_project_rec.CHECKOUT_USER:= NULL;
114: l_cz_imp_devl_project_rec.RUN_ID:= G_RUN_ID;
115: l_cz_imp_devl_project_rec.REC_STATUS:= NULL;
116: l_cz_imp_devl_project_rec.DISPOSITION:= NULL;
117: l_cz_imp_devl_project_rec.FSK_INTLTEXT_1_1:= NULL;

Line 114: l_cz_imp_devl_project_rec.RUN_ID:= G_RUN_ID;

110: l_cz_imp_devl_project_rec.LAST_UPDATED_BY:= FND_GLOBAL.USER_ID;
111: l_cz_imp_devl_project_rec.SECURITY_MASK:= NULL;
112: l_cz_imp_devl_project_rec.EFF_MASK:= NULL;
113: l_cz_imp_devl_project_rec.CHECKOUT_USER:= NULL;
114: l_cz_imp_devl_project_rec.RUN_ID:= G_RUN_ID;
115: l_cz_imp_devl_project_rec.REC_STATUS:= NULL;
116: l_cz_imp_devl_project_rec.DISPOSITION:= NULL;
117: l_cz_imp_devl_project_rec.FSK_INTLTEXT_1_1:= NULL;
118: l_cz_imp_devl_project_rec.MODEL_ID:= p_model_id;

Line 115: l_cz_imp_devl_project_rec.REC_STATUS:= NULL;

111: l_cz_imp_devl_project_rec.SECURITY_MASK:= NULL;
112: l_cz_imp_devl_project_rec.EFF_MASK:= NULL;
113: l_cz_imp_devl_project_rec.CHECKOUT_USER:= NULL;
114: l_cz_imp_devl_project_rec.RUN_ID:= G_RUN_ID;
115: l_cz_imp_devl_project_rec.REC_STATUS:= NULL;
116: l_cz_imp_devl_project_rec.DISPOSITION:= NULL;
117: l_cz_imp_devl_project_rec.FSK_INTLTEXT_1_1:= NULL;
118: l_cz_imp_devl_project_rec.MODEL_ID:= p_model_id;
119: l_cz_imp_devl_project_rec.PLAN_LEVEL:= 0;

Line 116: l_cz_imp_devl_project_rec.DISPOSITION:= NULL;

112: l_cz_imp_devl_project_rec.EFF_MASK:= NULL;
113: l_cz_imp_devl_project_rec.CHECKOUT_USER:= NULL;
114: l_cz_imp_devl_project_rec.RUN_ID:= G_RUN_ID;
115: l_cz_imp_devl_project_rec.REC_STATUS:= NULL;
116: l_cz_imp_devl_project_rec.DISPOSITION:= NULL;
117: l_cz_imp_devl_project_rec.FSK_INTLTEXT_1_1:= NULL;
118: l_cz_imp_devl_project_rec.MODEL_ID:= p_model_id;
119: l_cz_imp_devl_project_rec.PLAN_LEVEL:= 0;
120: l_cz_imp_devl_project_rec.PERSISTENT_PROJECT_ID:= NULL;

Line 117: l_cz_imp_devl_project_rec.FSK_INTLTEXT_1_1:= NULL;

113: l_cz_imp_devl_project_rec.CHECKOUT_USER:= NULL;
114: l_cz_imp_devl_project_rec.RUN_ID:= G_RUN_ID;
115: l_cz_imp_devl_project_rec.REC_STATUS:= NULL;
116: l_cz_imp_devl_project_rec.DISPOSITION:= NULL;
117: l_cz_imp_devl_project_rec.FSK_INTLTEXT_1_1:= NULL;
118: l_cz_imp_devl_project_rec.MODEL_ID:= p_model_id;
119: l_cz_imp_devl_project_rec.PLAN_LEVEL:= 0;
120: l_cz_imp_devl_project_rec.PERSISTENT_PROJECT_ID:= NULL;
121: l_cz_imp_devl_project_rec.MODEL_TYPE:= 'C'; -- non BOM Model

Line 118: l_cz_imp_devl_project_rec.MODEL_ID:= p_model_id;

114: l_cz_imp_devl_project_rec.RUN_ID:= G_RUN_ID;
115: l_cz_imp_devl_project_rec.REC_STATUS:= NULL;
116: l_cz_imp_devl_project_rec.DISPOSITION:= NULL;
117: l_cz_imp_devl_project_rec.FSK_INTLTEXT_1_1:= NULL;
118: l_cz_imp_devl_project_rec.MODEL_ID:= p_model_id;
119: l_cz_imp_devl_project_rec.PLAN_LEVEL:= 0;
120: l_cz_imp_devl_project_rec.PERSISTENT_PROJECT_ID:= NULL;
121: l_cz_imp_devl_project_rec.MODEL_TYPE:= 'C'; -- non BOM Model
122: l_cz_imp_devl_project_rec.INVENTORY_ITEM_ID:= NULL;

Line 119: l_cz_imp_devl_project_rec.PLAN_LEVEL:= 0;

115: l_cz_imp_devl_project_rec.REC_STATUS:= NULL;
116: l_cz_imp_devl_project_rec.DISPOSITION:= NULL;
117: l_cz_imp_devl_project_rec.FSK_INTLTEXT_1_1:= NULL;
118: l_cz_imp_devl_project_rec.MODEL_ID:= p_model_id;
119: l_cz_imp_devl_project_rec.PLAN_LEVEL:= 0;
120: l_cz_imp_devl_project_rec.PERSISTENT_PROJECT_ID:= NULL;
121: l_cz_imp_devl_project_rec.MODEL_TYPE:= 'C'; -- non BOM Model
122: l_cz_imp_devl_project_rec.INVENTORY_ITEM_ID:= NULL;
123: l_cz_imp_devl_project_rec.PRODUCT_KEY:= NULL;

Line 120: l_cz_imp_devl_project_rec.PERSISTENT_PROJECT_ID:= NULL;

116: l_cz_imp_devl_project_rec.DISPOSITION:= NULL;
117: l_cz_imp_devl_project_rec.FSK_INTLTEXT_1_1:= NULL;
118: l_cz_imp_devl_project_rec.MODEL_ID:= p_model_id;
119: l_cz_imp_devl_project_rec.PLAN_LEVEL:= 0;
120: l_cz_imp_devl_project_rec.PERSISTENT_PROJECT_ID:= NULL;
121: l_cz_imp_devl_project_rec.MODEL_TYPE:= 'C'; -- non BOM Model
122: l_cz_imp_devl_project_rec.INVENTORY_ITEM_ID:= NULL;
123: l_cz_imp_devl_project_rec.PRODUCT_KEY:= NULL;
124: l_cz_imp_devl_project_rec.LAST_UPDATE_LOGIN:= FND_GLOBAL.LOGIN_ID;

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

117: l_cz_imp_devl_project_rec.FSK_INTLTEXT_1_1:= NULL;
118: l_cz_imp_devl_project_rec.MODEL_ID:= p_model_id;
119: l_cz_imp_devl_project_rec.PLAN_LEVEL:= 0;
120: l_cz_imp_devl_project_rec.PERSISTENT_PROJECT_ID:= NULL;
121: l_cz_imp_devl_project_rec.MODEL_TYPE:= 'C'; -- non BOM Model
122: l_cz_imp_devl_project_rec.INVENTORY_ITEM_ID:= NULL;
123: l_cz_imp_devl_project_rec.PRODUCT_KEY:= NULL;
124: l_cz_imp_devl_project_rec.LAST_UPDATE_LOGIN:= FND_GLOBAL.LOGIN_ID;
125: l_cz_imp_devl_project_rec.BOM_CAPTION_RULE_ID:= NULL;

Line 122: l_cz_imp_devl_project_rec.INVENTORY_ITEM_ID:= NULL;

118: l_cz_imp_devl_project_rec.MODEL_ID:= p_model_id;
119: l_cz_imp_devl_project_rec.PLAN_LEVEL:= 0;
120: l_cz_imp_devl_project_rec.PERSISTENT_PROJECT_ID:= NULL;
121: l_cz_imp_devl_project_rec.MODEL_TYPE:= 'C'; -- non BOM Model
122: l_cz_imp_devl_project_rec.INVENTORY_ITEM_ID:= NULL;
123: l_cz_imp_devl_project_rec.PRODUCT_KEY:= NULL;
124: l_cz_imp_devl_project_rec.LAST_UPDATE_LOGIN:= FND_GLOBAL.LOGIN_ID;
125: l_cz_imp_devl_project_rec.BOM_CAPTION_RULE_ID:= NULL;
126: 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 123: l_cz_imp_devl_project_rec.PRODUCT_KEY:= NULL;

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

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

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

Line 125: l_cz_imp_devl_project_rec.BOM_CAPTION_RULE_ID:= NULL;

121: l_cz_imp_devl_project_rec.MODEL_TYPE:= 'C'; -- non BOM Model
122: l_cz_imp_devl_project_rec.INVENTORY_ITEM_ID:= NULL;
123: l_cz_imp_devl_project_rec.PRODUCT_KEY:= NULL;
124: l_cz_imp_devl_project_rec.LAST_UPDATE_LOGIN:= FND_GLOBAL.LOGIN_ID;
125: l_cz_imp_devl_project_rec.BOM_CAPTION_RULE_ID:= NULL;
126: l_cz_imp_devl_project_rec.NONBOM_CAPTION_RULE_ID:= OKC_XPRT_CZ_INT_PVT.G_CAPTION_RULE_DESC; -- display desc in runtime UIs
127: l_cz_imp_devl_project_rec.SEEDED_FLAG:= '1'; -- '0' unseeded , '1' seeded
128:
129: --

Line 126: 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.INVENTORY_ITEM_ID:= NULL;
123: l_cz_imp_devl_project_rec.PRODUCT_KEY:= NULL;
124: l_cz_imp_devl_project_rec.LAST_UPDATE_LOGIN:= FND_GLOBAL.LOGIN_ID;
125: l_cz_imp_devl_project_rec.BOM_CAPTION_RULE_ID:= NULL;
126: l_cz_imp_devl_project_rec.NONBOM_CAPTION_RULE_ID:= OKC_XPRT_CZ_INT_PVT.G_CAPTION_RULE_DESC; -- display desc in runtime UIs
127: l_cz_imp_devl_project_rec.SEEDED_FLAG:= '1'; -- '0' unseeded , '1' seeded
128:
129: --
130:

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

123: l_cz_imp_devl_project_rec.PRODUCT_KEY:= NULL;
124: l_cz_imp_devl_project_rec.LAST_UPDATE_LOGIN:= FND_GLOBAL.LOGIN_ID;
125: l_cz_imp_devl_project_rec.BOM_CAPTION_RULE_ID:= NULL;
126: l_cz_imp_devl_project_rec.NONBOM_CAPTION_RULE_ID:= OKC_XPRT_CZ_INT_PVT.G_CAPTION_RULE_DESC; -- display desc in runtime UIs
127: l_cz_imp_devl_project_rec.SEEDED_FLAG:= '1'; -- '0' unseeded , '1' seeded
128:
129: --
130:
131: -- insert the Clause Model Record into cz_devl_project

Line 132: INSERT INTO cz_imp_devl_project

128:
129: --
130:
131: -- insert the Clause Model Record into cz_devl_project
132: INSERT INTO cz_imp_devl_project
133: (
134: DEVL_PROJECT_ID,
135: INTL_TEXT_ID,
136: ORGANIZATION_ID,

Line 171: l_cz_imp_devl_project_rec.DEVL_PROJECT_ID,

167: SEEDED_FLAG
168: )
169: VALUES
170: (
171: l_cz_imp_devl_project_rec.DEVL_PROJECT_ID,
172: l_cz_imp_devl_project_rec.INTL_TEXT_ID,
173: l_cz_imp_devl_project_rec.ORGANIZATION_ID,
174: l_cz_imp_devl_project_rec.NAME,
175: l_cz_imp_devl_project_rec.GSL_FILENAME,

Line 172: l_cz_imp_devl_project_rec.INTL_TEXT_ID,

168: )
169: VALUES
170: (
171: l_cz_imp_devl_project_rec.DEVL_PROJECT_ID,
172: l_cz_imp_devl_project_rec.INTL_TEXT_ID,
173: l_cz_imp_devl_project_rec.ORGANIZATION_ID,
174: l_cz_imp_devl_project_rec.NAME,
175: l_cz_imp_devl_project_rec.GSL_FILENAME,
176: l_cz_imp_devl_project_rec.TOP_ITEM_ID,

Line 173: l_cz_imp_devl_project_rec.ORGANIZATION_ID,

169: VALUES
170: (
171: l_cz_imp_devl_project_rec.DEVL_PROJECT_ID,
172: l_cz_imp_devl_project_rec.INTL_TEXT_ID,
173: l_cz_imp_devl_project_rec.ORGANIZATION_ID,
174: l_cz_imp_devl_project_rec.NAME,
175: l_cz_imp_devl_project_rec.GSL_FILENAME,
176: l_cz_imp_devl_project_rec.TOP_ITEM_ID,
177: l_cz_imp_devl_project_rec.VERSION,

Line 174: l_cz_imp_devl_project_rec.NAME,

170: (
171: l_cz_imp_devl_project_rec.DEVL_PROJECT_ID,
172: l_cz_imp_devl_project_rec.INTL_TEXT_ID,
173: l_cz_imp_devl_project_rec.ORGANIZATION_ID,
174: l_cz_imp_devl_project_rec.NAME,
175: l_cz_imp_devl_project_rec.GSL_FILENAME,
176: l_cz_imp_devl_project_rec.TOP_ITEM_ID,
177: l_cz_imp_devl_project_rec.VERSION,
178: l_cz_imp_devl_project_rec.EXPLOSION_TYPE,

Line 175: l_cz_imp_devl_project_rec.GSL_FILENAME,

171: l_cz_imp_devl_project_rec.DEVL_PROJECT_ID,
172: l_cz_imp_devl_project_rec.INTL_TEXT_ID,
173: l_cz_imp_devl_project_rec.ORGANIZATION_ID,
174: l_cz_imp_devl_project_rec.NAME,
175: l_cz_imp_devl_project_rec.GSL_FILENAME,
176: l_cz_imp_devl_project_rec.TOP_ITEM_ID,
177: l_cz_imp_devl_project_rec.VERSION,
178: l_cz_imp_devl_project_rec.EXPLOSION_TYPE,
179: l_cz_imp_devl_project_rec.DESC_TEXT,

Line 176: l_cz_imp_devl_project_rec.TOP_ITEM_ID,

172: l_cz_imp_devl_project_rec.INTL_TEXT_ID,
173: l_cz_imp_devl_project_rec.ORGANIZATION_ID,
174: l_cz_imp_devl_project_rec.NAME,
175: l_cz_imp_devl_project_rec.GSL_FILENAME,
176: l_cz_imp_devl_project_rec.TOP_ITEM_ID,
177: l_cz_imp_devl_project_rec.VERSION,
178: l_cz_imp_devl_project_rec.EXPLOSION_TYPE,
179: l_cz_imp_devl_project_rec.DESC_TEXT,
180: l_cz_imp_devl_project_rec.ORIG_SYS_REF,

Line 177: l_cz_imp_devl_project_rec.VERSION,

173: l_cz_imp_devl_project_rec.ORGANIZATION_ID,
174: l_cz_imp_devl_project_rec.NAME,
175: l_cz_imp_devl_project_rec.GSL_FILENAME,
176: l_cz_imp_devl_project_rec.TOP_ITEM_ID,
177: l_cz_imp_devl_project_rec.VERSION,
178: l_cz_imp_devl_project_rec.EXPLOSION_TYPE,
179: l_cz_imp_devl_project_rec.DESC_TEXT,
180: l_cz_imp_devl_project_rec.ORIG_SYS_REF,
181: l_cz_imp_devl_project_rec.CREATION_DATE,

Line 178: l_cz_imp_devl_project_rec.EXPLOSION_TYPE,

174: l_cz_imp_devl_project_rec.NAME,
175: l_cz_imp_devl_project_rec.GSL_FILENAME,
176: l_cz_imp_devl_project_rec.TOP_ITEM_ID,
177: l_cz_imp_devl_project_rec.VERSION,
178: l_cz_imp_devl_project_rec.EXPLOSION_TYPE,
179: l_cz_imp_devl_project_rec.DESC_TEXT,
180: l_cz_imp_devl_project_rec.ORIG_SYS_REF,
181: l_cz_imp_devl_project_rec.CREATION_DATE,
182: l_cz_imp_devl_project_rec.LAST_UPDATE_DATE,

Line 179: l_cz_imp_devl_project_rec.DESC_TEXT,

175: l_cz_imp_devl_project_rec.GSL_FILENAME,
176: l_cz_imp_devl_project_rec.TOP_ITEM_ID,
177: l_cz_imp_devl_project_rec.VERSION,
178: l_cz_imp_devl_project_rec.EXPLOSION_TYPE,
179: l_cz_imp_devl_project_rec.DESC_TEXT,
180: l_cz_imp_devl_project_rec.ORIG_SYS_REF,
181: l_cz_imp_devl_project_rec.CREATION_DATE,
182: l_cz_imp_devl_project_rec.LAST_UPDATE_DATE,
183: l_cz_imp_devl_project_rec.DELETED_FLAG,

Line 180: l_cz_imp_devl_project_rec.ORIG_SYS_REF,

176: l_cz_imp_devl_project_rec.TOP_ITEM_ID,
177: l_cz_imp_devl_project_rec.VERSION,
178: l_cz_imp_devl_project_rec.EXPLOSION_TYPE,
179: l_cz_imp_devl_project_rec.DESC_TEXT,
180: l_cz_imp_devl_project_rec.ORIG_SYS_REF,
181: l_cz_imp_devl_project_rec.CREATION_DATE,
182: l_cz_imp_devl_project_rec.LAST_UPDATE_DATE,
183: l_cz_imp_devl_project_rec.DELETED_FLAG,
184: l_cz_imp_devl_project_rec.EFF_FROM,

Line 181: l_cz_imp_devl_project_rec.CREATION_DATE,

177: l_cz_imp_devl_project_rec.VERSION,
178: l_cz_imp_devl_project_rec.EXPLOSION_TYPE,
179: l_cz_imp_devl_project_rec.DESC_TEXT,
180: l_cz_imp_devl_project_rec.ORIG_SYS_REF,
181: l_cz_imp_devl_project_rec.CREATION_DATE,
182: l_cz_imp_devl_project_rec.LAST_UPDATE_DATE,
183: l_cz_imp_devl_project_rec.DELETED_FLAG,
184: l_cz_imp_devl_project_rec.EFF_FROM,
185: l_cz_imp_devl_project_rec.EFF_TO,

Line 182: l_cz_imp_devl_project_rec.LAST_UPDATE_DATE,

178: l_cz_imp_devl_project_rec.EXPLOSION_TYPE,
179: l_cz_imp_devl_project_rec.DESC_TEXT,
180: l_cz_imp_devl_project_rec.ORIG_SYS_REF,
181: l_cz_imp_devl_project_rec.CREATION_DATE,
182: l_cz_imp_devl_project_rec.LAST_UPDATE_DATE,
183: l_cz_imp_devl_project_rec.DELETED_FLAG,
184: l_cz_imp_devl_project_rec.EFF_FROM,
185: l_cz_imp_devl_project_rec.EFF_TO,
186: l_cz_imp_devl_project_rec.CREATED_BY,

Line 183: l_cz_imp_devl_project_rec.DELETED_FLAG,

179: l_cz_imp_devl_project_rec.DESC_TEXT,
180: l_cz_imp_devl_project_rec.ORIG_SYS_REF,
181: l_cz_imp_devl_project_rec.CREATION_DATE,
182: l_cz_imp_devl_project_rec.LAST_UPDATE_DATE,
183: l_cz_imp_devl_project_rec.DELETED_FLAG,
184: l_cz_imp_devl_project_rec.EFF_FROM,
185: l_cz_imp_devl_project_rec.EFF_TO,
186: l_cz_imp_devl_project_rec.CREATED_BY,
187: l_cz_imp_devl_project_rec.LAST_UPDATED_BY,

Line 184: l_cz_imp_devl_project_rec.EFF_FROM,

180: l_cz_imp_devl_project_rec.ORIG_SYS_REF,
181: l_cz_imp_devl_project_rec.CREATION_DATE,
182: l_cz_imp_devl_project_rec.LAST_UPDATE_DATE,
183: l_cz_imp_devl_project_rec.DELETED_FLAG,
184: l_cz_imp_devl_project_rec.EFF_FROM,
185: l_cz_imp_devl_project_rec.EFF_TO,
186: l_cz_imp_devl_project_rec.CREATED_BY,
187: l_cz_imp_devl_project_rec.LAST_UPDATED_BY,
188: l_cz_imp_devl_project_rec.SECURITY_MASK,

Line 185: l_cz_imp_devl_project_rec.EFF_TO,

181: l_cz_imp_devl_project_rec.CREATION_DATE,
182: l_cz_imp_devl_project_rec.LAST_UPDATE_DATE,
183: l_cz_imp_devl_project_rec.DELETED_FLAG,
184: l_cz_imp_devl_project_rec.EFF_FROM,
185: l_cz_imp_devl_project_rec.EFF_TO,
186: l_cz_imp_devl_project_rec.CREATED_BY,
187: l_cz_imp_devl_project_rec.LAST_UPDATED_BY,
188: l_cz_imp_devl_project_rec.SECURITY_MASK,
189: l_cz_imp_devl_project_rec.EFF_MASK,

Line 186: l_cz_imp_devl_project_rec.CREATED_BY,

182: l_cz_imp_devl_project_rec.LAST_UPDATE_DATE,
183: l_cz_imp_devl_project_rec.DELETED_FLAG,
184: l_cz_imp_devl_project_rec.EFF_FROM,
185: l_cz_imp_devl_project_rec.EFF_TO,
186: l_cz_imp_devl_project_rec.CREATED_BY,
187: l_cz_imp_devl_project_rec.LAST_UPDATED_BY,
188: l_cz_imp_devl_project_rec.SECURITY_MASK,
189: l_cz_imp_devl_project_rec.EFF_MASK,
190: l_cz_imp_devl_project_rec.CHECKOUT_USER,

Line 187: l_cz_imp_devl_project_rec.LAST_UPDATED_BY,

183: l_cz_imp_devl_project_rec.DELETED_FLAG,
184: l_cz_imp_devl_project_rec.EFF_FROM,
185: l_cz_imp_devl_project_rec.EFF_TO,
186: l_cz_imp_devl_project_rec.CREATED_BY,
187: l_cz_imp_devl_project_rec.LAST_UPDATED_BY,
188: l_cz_imp_devl_project_rec.SECURITY_MASK,
189: l_cz_imp_devl_project_rec.EFF_MASK,
190: l_cz_imp_devl_project_rec.CHECKOUT_USER,
191: l_cz_imp_devl_project_rec.RUN_ID,

Line 188: l_cz_imp_devl_project_rec.SECURITY_MASK,

184: l_cz_imp_devl_project_rec.EFF_FROM,
185: l_cz_imp_devl_project_rec.EFF_TO,
186: l_cz_imp_devl_project_rec.CREATED_BY,
187: l_cz_imp_devl_project_rec.LAST_UPDATED_BY,
188: l_cz_imp_devl_project_rec.SECURITY_MASK,
189: l_cz_imp_devl_project_rec.EFF_MASK,
190: l_cz_imp_devl_project_rec.CHECKOUT_USER,
191: l_cz_imp_devl_project_rec.RUN_ID,
192: l_cz_imp_devl_project_rec.REC_STATUS,

Line 189: l_cz_imp_devl_project_rec.EFF_MASK,

185: l_cz_imp_devl_project_rec.EFF_TO,
186: l_cz_imp_devl_project_rec.CREATED_BY,
187: l_cz_imp_devl_project_rec.LAST_UPDATED_BY,
188: l_cz_imp_devl_project_rec.SECURITY_MASK,
189: l_cz_imp_devl_project_rec.EFF_MASK,
190: l_cz_imp_devl_project_rec.CHECKOUT_USER,
191: l_cz_imp_devl_project_rec.RUN_ID,
192: l_cz_imp_devl_project_rec.REC_STATUS,
193: l_cz_imp_devl_project_rec.DISPOSITION,

Line 190: l_cz_imp_devl_project_rec.CHECKOUT_USER,

186: l_cz_imp_devl_project_rec.CREATED_BY,
187: l_cz_imp_devl_project_rec.LAST_UPDATED_BY,
188: l_cz_imp_devl_project_rec.SECURITY_MASK,
189: l_cz_imp_devl_project_rec.EFF_MASK,
190: l_cz_imp_devl_project_rec.CHECKOUT_USER,
191: l_cz_imp_devl_project_rec.RUN_ID,
192: l_cz_imp_devl_project_rec.REC_STATUS,
193: l_cz_imp_devl_project_rec.DISPOSITION,
194: l_cz_imp_devl_project_rec.FSK_INTLTEXT_1_1,

Line 191: l_cz_imp_devl_project_rec.RUN_ID,

187: l_cz_imp_devl_project_rec.LAST_UPDATED_BY,
188: l_cz_imp_devl_project_rec.SECURITY_MASK,
189: l_cz_imp_devl_project_rec.EFF_MASK,
190: l_cz_imp_devl_project_rec.CHECKOUT_USER,
191: l_cz_imp_devl_project_rec.RUN_ID,
192: l_cz_imp_devl_project_rec.REC_STATUS,
193: l_cz_imp_devl_project_rec.DISPOSITION,
194: l_cz_imp_devl_project_rec.FSK_INTLTEXT_1_1,
195: l_cz_imp_devl_project_rec.MODEL_ID,

Line 192: l_cz_imp_devl_project_rec.REC_STATUS,

188: l_cz_imp_devl_project_rec.SECURITY_MASK,
189: l_cz_imp_devl_project_rec.EFF_MASK,
190: l_cz_imp_devl_project_rec.CHECKOUT_USER,
191: l_cz_imp_devl_project_rec.RUN_ID,
192: l_cz_imp_devl_project_rec.REC_STATUS,
193: l_cz_imp_devl_project_rec.DISPOSITION,
194: l_cz_imp_devl_project_rec.FSK_INTLTEXT_1_1,
195: l_cz_imp_devl_project_rec.MODEL_ID,
196: l_cz_imp_devl_project_rec.PLAN_LEVEL,

Line 193: l_cz_imp_devl_project_rec.DISPOSITION,

189: l_cz_imp_devl_project_rec.EFF_MASK,
190: l_cz_imp_devl_project_rec.CHECKOUT_USER,
191: l_cz_imp_devl_project_rec.RUN_ID,
192: l_cz_imp_devl_project_rec.REC_STATUS,
193: l_cz_imp_devl_project_rec.DISPOSITION,
194: l_cz_imp_devl_project_rec.FSK_INTLTEXT_1_1,
195: l_cz_imp_devl_project_rec.MODEL_ID,
196: l_cz_imp_devl_project_rec.PLAN_LEVEL,
197: l_cz_imp_devl_project_rec.PERSISTENT_PROJECT_ID,

Line 194: l_cz_imp_devl_project_rec.FSK_INTLTEXT_1_1,

190: l_cz_imp_devl_project_rec.CHECKOUT_USER,
191: l_cz_imp_devl_project_rec.RUN_ID,
192: l_cz_imp_devl_project_rec.REC_STATUS,
193: l_cz_imp_devl_project_rec.DISPOSITION,
194: l_cz_imp_devl_project_rec.FSK_INTLTEXT_1_1,
195: l_cz_imp_devl_project_rec.MODEL_ID,
196: l_cz_imp_devl_project_rec.PLAN_LEVEL,
197: l_cz_imp_devl_project_rec.PERSISTENT_PROJECT_ID,
198: l_cz_imp_devl_project_rec.MODEL_TYPE,

Line 195: l_cz_imp_devl_project_rec.MODEL_ID,

191: l_cz_imp_devl_project_rec.RUN_ID,
192: l_cz_imp_devl_project_rec.REC_STATUS,
193: l_cz_imp_devl_project_rec.DISPOSITION,
194: l_cz_imp_devl_project_rec.FSK_INTLTEXT_1_1,
195: l_cz_imp_devl_project_rec.MODEL_ID,
196: l_cz_imp_devl_project_rec.PLAN_LEVEL,
197: l_cz_imp_devl_project_rec.PERSISTENT_PROJECT_ID,
198: l_cz_imp_devl_project_rec.MODEL_TYPE,
199: l_cz_imp_devl_project_rec.INVENTORY_ITEM_ID,

Line 196: l_cz_imp_devl_project_rec.PLAN_LEVEL,

192: l_cz_imp_devl_project_rec.REC_STATUS,
193: l_cz_imp_devl_project_rec.DISPOSITION,
194: l_cz_imp_devl_project_rec.FSK_INTLTEXT_1_1,
195: l_cz_imp_devl_project_rec.MODEL_ID,
196: l_cz_imp_devl_project_rec.PLAN_LEVEL,
197: l_cz_imp_devl_project_rec.PERSISTENT_PROJECT_ID,
198: l_cz_imp_devl_project_rec.MODEL_TYPE,
199: l_cz_imp_devl_project_rec.INVENTORY_ITEM_ID,
200: l_cz_imp_devl_project_rec.PRODUCT_KEY,

Line 197: l_cz_imp_devl_project_rec.PERSISTENT_PROJECT_ID,

193: l_cz_imp_devl_project_rec.DISPOSITION,
194: l_cz_imp_devl_project_rec.FSK_INTLTEXT_1_1,
195: l_cz_imp_devl_project_rec.MODEL_ID,
196: l_cz_imp_devl_project_rec.PLAN_LEVEL,
197: l_cz_imp_devl_project_rec.PERSISTENT_PROJECT_ID,
198: l_cz_imp_devl_project_rec.MODEL_TYPE,
199: l_cz_imp_devl_project_rec.INVENTORY_ITEM_ID,
200: l_cz_imp_devl_project_rec.PRODUCT_KEY,
201: l_cz_imp_devl_project_rec.LAST_UPDATE_LOGIN,

Line 198: l_cz_imp_devl_project_rec.MODEL_TYPE,

194: l_cz_imp_devl_project_rec.FSK_INTLTEXT_1_1,
195: l_cz_imp_devl_project_rec.MODEL_ID,
196: l_cz_imp_devl_project_rec.PLAN_LEVEL,
197: l_cz_imp_devl_project_rec.PERSISTENT_PROJECT_ID,
198: l_cz_imp_devl_project_rec.MODEL_TYPE,
199: l_cz_imp_devl_project_rec.INVENTORY_ITEM_ID,
200: l_cz_imp_devl_project_rec.PRODUCT_KEY,
201: l_cz_imp_devl_project_rec.LAST_UPDATE_LOGIN,
202: l_cz_imp_devl_project_rec.BOM_CAPTION_RULE_ID,

Line 199: l_cz_imp_devl_project_rec.INVENTORY_ITEM_ID,

195: l_cz_imp_devl_project_rec.MODEL_ID,
196: l_cz_imp_devl_project_rec.PLAN_LEVEL,
197: l_cz_imp_devl_project_rec.PERSISTENT_PROJECT_ID,
198: l_cz_imp_devl_project_rec.MODEL_TYPE,
199: l_cz_imp_devl_project_rec.INVENTORY_ITEM_ID,
200: l_cz_imp_devl_project_rec.PRODUCT_KEY,
201: l_cz_imp_devl_project_rec.LAST_UPDATE_LOGIN,
202: l_cz_imp_devl_project_rec.BOM_CAPTION_RULE_ID,
203: l_cz_imp_devl_project_rec.NONBOM_CAPTION_RULE_ID,

Line 200: l_cz_imp_devl_project_rec.PRODUCT_KEY,

196: l_cz_imp_devl_project_rec.PLAN_LEVEL,
197: l_cz_imp_devl_project_rec.PERSISTENT_PROJECT_ID,
198: l_cz_imp_devl_project_rec.MODEL_TYPE,
199: l_cz_imp_devl_project_rec.INVENTORY_ITEM_ID,
200: l_cz_imp_devl_project_rec.PRODUCT_KEY,
201: l_cz_imp_devl_project_rec.LAST_UPDATE_LOGIN,
202: l_cz_imp_devl_project_rec.BOM_CAPTION_RULE_ID,
203: l_cz_imp_devl_project_rec.NONBOM_CAPTION_RULE_ID,
204: l_cz_imp_devl_project_rec.SEEDED_FLAG

Line 201: l_cz_imp_devl_project_rec.LAST_UPDATE_LOGIN,

197: l_cz_imp_devl_project_rec.PERSISTENT_PROJECT_ID,
198: l_cz_imp_devl_project_rec.MODEL_TYPE,
199: l_cz_imp_devl_project_rec.INVENTORY_ITEM_ID,
200: l_cz_imp_devl_project_rec.PRODUCT_KEY,
201: l_cz_imp_devl_project_rec.LAST_UPDATE_LOGIN,
202: l_cz_imp_devl_project_rec.BOM_CAPTION_RULE_ID,
203: l_cz_imp_devl_project_rec.NONBOM_CAPTION_RULE_ID,
204: l_cz_imp_devl_project_rec.SEEDED_FLAG
205: );

Line 202: l_cz_imp_devl_project_rec.BOM_CAPTION_RULE_ID,

198: l_cz_imp_devl_project_rec.MODEL_TYPE,
199: l_cz_imp_devl_project_rec.INVENTORY_ITEM_ID,
200: l_cz_imp_devl_project_rec.PRODUCT_KEY,
201: l_cz_imp_devl_project_rec.LAST_UPDATE_LOGIN,
202: l_cz_imp_devl_project_rec.BOM_CAPTION_RULE_ID,
203: l_cz_imp_devl_project_rec.NONBOM_CAPTION_RULE_ID,
204: l_cz_imp_devl_project_rec.SEEDED_FLAG
205: );
206:

Line 203: l_cz_imp_devl_project_rec.NONBOM_CAPTION_RULE_ID,

199: l_cz_imp_devl_project_rec.INVENTORY_ITEM_ID,
200: l_cz_imp_devl_project_rec.PRODUCT_KEY,
201: l_cz_imp_devl_project_rec.LAST_UPDATE_LOGIN,
202: l_cz_imp_devl_project_rec.BOM_CAPTION_RULE_ID,
203: l_cz_imp_devl_project_rec.NONBOM_CAPTION_RULE_ID,
204: l_cz_imp_devl_project_rec.SEEDED_FLAG
205: );
206:
207:

Line 204: l_cz_imp_devl_project_rec.SEEDED_FLAG

200: l_cz_imp_devl_project_rec.PRODUCT_KEY,
201: l_cz_imp_devl_project_rec.LAST_UPDATE_LOGIN,
202: l_cz_imp_devl_project_rec.BOM_CAPTION_RULE_ID,
203: l_cz_imp_devl_project_rec.NONBOM_CAPTION_RULE_ID,
204: l_cz_imp_devl_project_rec.SEEDED_FLAG
205: );
206:
207:
208: -- Standard call to get message count and if count is 1, get message info.

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

363: l_cz_imp_ps_nodes_rec.EXPLOSION_TYPE:= NULL;
364: l_cz_imp_ps_nodes_rec.NAME:= G_CLAUSE_MODEL_TOPNODE_OSR||p_org_id||':'||p_intent;
365: l_cz_imp_ps_nodes_rec.ORIG_SYS_REF:= G_CLAUSE_MODEL_TOPNODE_OSR||p_org_id||':'||p_intent;
366: l_cz_imp_ps_nodes_rec.RESOURCE_FLAG:= NULL;
367: l_cz_imp_ps_nodes_rec.TOP_ITEM_ID:= 1; -- same value as in cz_imp_devl_projects
368: l_cz_imp_ps_nodes_rec.INITIAL_VALUE:= NULL;
369: l_cz_imp_ps_nodes_rec.PARENT_ID:= NULL;
370: l_cz_imp_ps_nodes_rec.MINIMUM:= 1;
371: l_cz_imp_ps_nodes_rec.MAXIMUM:= 1;

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

791: l_cz_imp_ps_nodes_rec.EXPLOSION_TYPE:= NULL;
792: l_cz_imp_ps_nodes_rec.NAME:= G_CLAUSE_MODEL_FEATURE_OSR||p_org_id||':'||p_intent;
793: l_cz_imp_ps_nodes_rec.ORIG_SYS_REF:= G_CLAUSE_MODEL_FEATURE_OSR||p_org_id||':'||p_intent;
794: l_cz_imp_ps_nodes_rec.RESOURCE_FLAG:= NULL;
795: l_cz_imp_ps_nodes_rec.TOP_ITEM_ID:= 1; -- same value as in cz_imp_devl_projects
796: l_cz_imp_ps_nodes_rec.INITIAL_VALUE:= NULL;
797: l_cz_imp_ps_nodes_rec.PARENT_ID:= NULL;
798: l_cz_imp_ps_nodes_rec.MINIMUM:= 0; -- 0 for feature
799: l_cz_imp_ps_nodes_rec.MAXIMUM:= NULL;

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

1371: NULL, --EXPLOSION_TYPE,
1372: ClauseIdList_tbl(i), --NAME
1373: G_CLAUSE_MODEL_OPTION_OSR||p_org_id ||':'||p_intent||':'||ClauseIdList_tbl(i), --ORIG_SYS_REF
1374: NULL, --RESOURCE_FLAG
1375: 1, --TOP_ITEM_ID -- same value as in cz_imp_devl_projects
1376: NULL, --INITIAL_VALUE
1377: NULL, --PARENT_ID
1378: 1, --MINIMUM
1379: 1, --MAXIMUM

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

1611: l_cz_imp_ps_nodes_rec.EXPLOSION_TYPE:= NULL;
1612: l_cz_imp_ps_nodes_rec.NAME:= G_CLAUSE_MODEL_VM_REF_NODE_OSR||p_org_id||':'||p_intent;
1613: l_cz_imp_ps_nodes_rec.ORIG_SYS_REF:= G_CLAUSE_MODEL_VM_REF_NODE_OSR||p_org_id||':'||p_intent;
1614: l_cz_imp_ps_nodes_rec.RESOURCE_FLAG:= NULL;
1615: l_cz_imp_ps_nodes_rec.TOP_ITEM_ID:= 1; -- same value as in cz_imp_devl_projects
1616: l_cz_imp_ps_nodes_rec.INITIAL_VALUE:= NULL;
1617: l_cz_imp_ps_nodes_rec.PARENT_ID:= NULL;
1618: l_cz_imp_ps_nodes_rec.MINIMUM:= 1;
1619: l_cz_imp_ps_nodes_rec.MAXIMUM:= NULL;