4241: BEGIN
4242:
4243: lReturnStatus := fnd_api.G_RET_STS_SUCCESS;
4244:
4245: gUserId := nvl(Fnd_Global.USER_ID, -1);
4246: gLoginId := nvl(Fnd_Global.LOGIN_ID, -1);
4247: lCiDel := FND_PROFILE.Value('BOM:CONFIG_ITEM_DELIMITER');
4248:
4249:
4242:
4243: lReturnStatus := fnd_api.G_RET_STS_SUCCESS;
4244:
4245: gUserId := nvl(Fnd_Global.USER_ID, -1);
4246: gLoginId := nvl(Fnd_Global.LOGIN_ID, -1);
4247: lCiDel := FND_PROFILE.Value('BOM:CONFIG_ITEM_DELIMITER');
4248:
4249:
4250:
5452: X_to_pk2_value => pConfigId,
5453: X_to_pk3_value => NULL,
5454: X_to_pk4_value => NULL,
5455: X_to_pk5_value => NULL,
5456: X_created_by => fnd_global.USER_ID,
5457: X_last_update_login => fnd_global.USER_ID,
5458: X_program_application_id => fnd_global.PROG_APPL_ID,
5459: X_program_id => fnd_global.CONC_REQUEST_ID,
5460: X_request_id => fnd_global.USER_ID,
5453: X_to_pk3_value => NULL,
5454: X_to_pk4_value => NULL,
5455: X_to_pk5_value => NULL,
5456: X_created_by => fnd_global.USER_ID,
5457: X_last_update_login => fnd_global.USER_ID,
5458: X_program_application_id => fnd_global.PROG_APPL_ID,
5459: X_program_id => fnd_global.CONC_REQUEST_ID,
5460: X_request_id => fnd_global.USER_ID,
5461: X_automatically_added_flag => NULL
5454: X_to_pk4_value => NULL,
5455: X_to_pk5_value => NULL,
5456: X_created_by => fnd_global.USER_ID,
5457: X_last_update_login => fnd_global.USER_ID,
5458: X_program_application_id => fnd_global.PROG_APPL_ID,
5459: X_program_id => fnd_global.CONC_REQUEST_ID,
5460: X_request_id => fnd_global.USER_ID,
5461: X_automatically_added_flag => NULL
5462: );
5455: X_to_pk5_value => NULL,
5456: X_created_by => fnd_global.USER_ID,
5457: X_last_update_login => fnd_global.USER_ID,
5458: X_program_application_id => fnd_global.PROG_APPL_ID,
5459: X_program_id => fnd_global.CONC_REQUEST_ID,
5460: X_request_id => fnd_global.USER_ID,
5461: X_automatically_added_flag => NULL
5462: );
5463: IF PG_DEBUG <> 0 THEN
5456: X_created_by => fnd_global.USER_ID,
5457: X_last_update_login => fnd_global.USER_ID,
5458: X_program_application_id => fnd_global.PROG_APPL_ID,
5459: X_program_id => fnd_global.CONC_REQUEST_ID,
5460: X_request_id => fnd_global.USER_ID,
5461: X_automatically_added_flag => NULL
5462: );
5463: IF PG_DEBUG <> 0 THEN
5464: oe_debug_pub.add('Create_Item: ' || 'Done copy_attachment ',3);
8450: l_bypassatp_profile_value VARCHAR2(100);
8451:
8452: BEGIN
8453:
8454: gUserId := nvl(Fnd_Global.USER_ID,-1);
8455: gLoginId := nvl(Fnd_Global.LOGIN_ID,-1);
8456:
8457:
8458: --
8451:
8452: BEGIN
8453:
8454: gUserId := nvl(Fnd_Global.USER_ID,-1);
8455: gLoginId := nvl(Fnd_Global.LOGIN_ID,-1);
8456:
8457:
8458: --
8459: -- check if config item already exists