DBA Data[Home] [Help]

APPS.OKC_XPRT_IMPORT_VARIABLES_PVT dependencies on FND_GLOBAL

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 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 315: FND_GLOBAL.LOGIN_ID, --LAST_UPDATE_LOGIN

311: SEEDED_FLAG
312: )
313: VALUES
314: (
315: FND_GLOBAL.LOGIN_ID, --LAST_UPDATE_LOGIN
316: NULL, -- LOCALE_ID
317: l_model_component_name, --LOCALIZED_STR
318: NULL, -- INTL_TEXT_ID
319: SYSDATE, -- CREATION_DATE

Line 324: FND_GLOBAL.USER_ID, -- CREATED_BY

320: SYSDATE, -- LAST_UPDATE_DATE
321: '0', -- DELETED_FLAG
322: NULL, -- EFF_FROM
323: NULL, -- EFF_TO
324: FND_GLOBAL.USER_ID, -- CREATED_BY
325: FND_GLOBAL.USER_ID, -- LAST_UPDATED_BY
326: NULL, -- SECURITY_MASK
327: NULL, -- EFF_MASK
328: NULL, -- CHECKOUT_USER

Line 325: FND_GLOBAL.USER_ID, -- LAST_UPDATED_BY

321: '0', -- DELETED_FLAG
322: NULL, -- EFF_FROM
323: NULL, -- EFF_TO
324: FND_GLOBAL.USER_ID, -- CREATED_BY
325: FND_GLOBAL.USER_ID, -- LAST_UPDATED_BY
326: NULL, -- SECURITY_MASK
327: NULL, -- EFF_MASK
328: NULL, -- CHECKOUT_USER
329: l_language, --LANGUAGE

Line 395: l_cz_imp_ps_nodes_rec.CREATED_BY:= FND_GLOBAL.USER_ID;

391: l_cz_imp_ps_nodes_rec.USER_NUM04:= NULL;
392: l_cz_imp_ps_nodes_rec.CHECKOUT_USER:= NULL;
393: l_cz_imp_ps_nodes_rec.CREATION_DATE:= SYSDATE;
394: l_cz_imp_ps_nodes_rec.LAST_UPDATE_DATE:= SYSDATE;
395: l_cz_imp_ps_nodes_rec.CREATED_BY:= FND_GLOBAL.USER_ID;
396: l_cz_imp_ps_nodes_rec.LAST_UPDATED_BY:= FND_GLOBAL.USER_ID;
397: l_cz_imp_ps_nodes_rec.SECURITY_MASK:= NULL;
398: l_cz_imp_ps_nodes_rec.FSK_INTLTEXT_1_1:= G_VARIABLE_MODEL_TOPNODE_OSR||p_intent;
399: l_cz_imp_ps_nodes_rec.FSK_INTLTEXT_1_EXT:= NULL;

Line 396: l_cz_imp_ps_nodes_rec.LAST_UPDATED_BY:= FND_GLOBAL.USER_ID;

392: l_cz_imp_ps_nodes_rec.CHECKOUT_USER:= NULL;
393: l_cz_imp_ps_nodes_rec.CREATION_DATE:= SYSDATE;
394: l_cz_imp_ps_nodes_rec.LAST_UPDATE_DATE:= SYSDATE;
395: l_cz_imp_ps_nodes_rec.CREATED_BY:= FND_GLOBAL.USER_ID;
396: l_cz_imp_ps_nodes_rec.LAST_UPDATED_BY:= FND_GLOBAL.USER_ID;
397: l_cz_imp_ps_nodes_rec.SECURITY_MASK:= NULL;
398: l_cz_imp_ps_nodes_rec.FSK_INTLTEXT_1_1:= G_VARIABLE_MODEL_TOPNODE_OSR||p_intent;
399: l_cz_imp_ps_nodes_rec.FSK_INTLTEXT_1_EXT:= NULL;
400: l_cz_imp_ps_nodes_rec.FSK_ITEMMASTER_2_1:= NULL;

Line 431: l_cz_imp_ps_nodes_rec.LAST_UPDATE_LOGIN:= FND_GLOBAL.LOGIN_ID;

427: l_cz_imp_ps_nodes_rec.PRIMARY_UOM_CODE:= NULL;
428: l_cz_imp_ps_nodes_rec.COMPONENT_SEQUENCE_PATH:= NULL; -- Must be NULL
429: l_cz_imp_ps_nodes_rec.BOM_SORT_ORDER:= NULL;
430: l_cz_imp_ps_nodes_rec.IB_TRACKABLE:= NULL;
431: l_cz_imp_ps_nodes_rec.LAST_UPDATE_LOGIN:= FND_GLOBAL.LOGIN_ID;
432: l_cz_imp_ps_nodes_rec.INITIAL_NUM_VALUE:= NULL;
433: l_cz_imp_ps_nodes_rec.SRC_APPLICATION_ID:= G_APPLICATION_ID;
434: l_cz_imp_ps_nodes_rec.FSK_ITEMMASTER_2_2:= NULL;
435: l_cz_imp_ps_nodes_rec.INSTANTIABLE_FLAG:= NULL;

Line 843: FND_GLOBAL.LOGIN_ID, --LAST_UPDATE_LOGIN

839: SEEDED_FLAG
840: )
841: VALUES
842: (
843: FND_GLOBAL.LOGIN_ID, --LAST_UPDATE_LOGIN
844: NULL, -- LOCALE_ID
845: variableName_tbl(i), --LOCALIZED_STR
846: NULL, -- INTL_TEXT_ID
847: SYSDATE, -- CREATION_DATE

Line 852: FND_GLOBAL.USER_ID, -- CREATED_BY

848: SYSDATE, -- LAST_UPDATE_DATE
849: '0', -- DELETED_FLAG
850: NULL, -- EFF_FROM
851: NULL, -- EFF_TO
852: FND_GLOBAL.USER_ID, -- CREATED_BY
853: FND_GLOBAL.USER_ID, -- LAST_UPDATED_BY
854: NULL, -- SECURITY_MASK
855: NULL, -- EFF_MASK
856: NULL, -- CHECKOUT_USER

Line 853: FND_GLOBAL.USER_ID, -- LAST_UPDATED_BY

849: '0', -- DELETED_FLAG
850: NULL, -- EFF_FROM
851: NULL, -- EFF_TO
852: FND_GLOBAL.USER_ID, -- CREATED_BY
853: FND_GLOBAL.USER_ID, -- LAST_UPDATED_BY
854: NULL, -- SECURITY_MASK
855: NULL, -- EFF_MASK
856: NULL, -- CHECKOUT_USER
857: l_language,

Line 1037: FND_GLOBAL.USER_ID, --CREATED_BY

1033: NULL, --USER_NUM04,
1034: NULL, --CHECKOUT_USER,
1035: SYSDATE, --CREATION_DATE
1036: SYSDATE, --LAST_UPDATE_DATE
1037: FND_GLOBAL.USER_ID, --CREATED_BY
1038: FND_GLOBAL.USER_ID, --LAST_UPDATED_BY
1039: NULL, --SECURITY_MASK,
1040: --G_VARIABLE_MODEL_FEATURE_OSR||p_intent||':'||variableCode_tbl(i), --FSK_INTLTEXT_1_1
1041: DECODE(variableDatatype_tbl(i), 'LN', G_VAR_MODEL_TEXT_FEATURE_OSR||p_intent||':'||variableCode_tbl(i), -- FSK_INTLTEXT_1_1 for Line Number

Line 1038: FND_GLOBAL.USER_ID, --LAST_UPDATED_BY

1034: NULL, --CHECKOUT_USER,
1035: SYSDATE, --CREATION_DATE
1036: SYSDATE, --LAST_UPDATE_DATE
1037: FND_GLOBAL.USER_ID, --CREATED_BY
1038: FND_GLOBAL.USER_ID, --LAST_UPDATED_BY
1039: NULL, --SECURITY_MASK,
1040: --G_VARIABLE_MODEL_FEATURE_OSR||p_intent||':'||variableCode_tbl(i), --FSK_INTLTEXT_1_1
1041: DECODE(variableDatatype_tbl(i), 'LN', G_VAR_MODEL_TEXT_FEATURE_OSR||p_intent||':'||variableCode_tbl(i), -- FSK_INTLTEXT_1_1 for Line Number
1042: 'DR', G_VAR_MODEL_DEVI_FEATURE_OSR||p_intent||':'||variableCode_tbl(i), -- FSK_INTLTEXT_1_1 for Deviation Rule

Line 1076: FND_GLOBAL.LOGIN_ID, --LAST_UPDATE_LOGIN,

1072: NULL, --PRIMARY_UOM_CODE,
1073: NULL, --COMPONENT_SEQUENCE_PATH, -- Must be NULL
1074: NULL, --BOM_SORT_ORDER,
1075: NULL, --IB_TRACKABLE,
1076: FND_GLOBAL.LOGIN_ID, --LAST_UPDATE_LOGIN,
1077: NULL, --INITIAL_NUM_VALUE,
1078: G_APPLICATION_ID, --SRC_APPLICATION_ID
1079: NULL, --FSK_ITEMMASTER_2_2,
1080: NULL, --INSTANTIABLE_FLAG,

Line 1241: FND_GLOBAL.LOGIN_ID, --LAST_UPDATE_LOGIN

1237: SEEDED_FLAG
1238: )
1239: VALUES
1240: (
1241: FND_GLOBAL.LOGIN_ID, --LAST_UPDATE_LOGIN
1242: NULL, -- LOCALE_ID
1243: variableOptionDesc_tbl(i), --LOCALIZED_STR
1244: NULL, -- INTL_TEXT_ID
1245: SYSDATE, -- CREATION_DATE

Line 1250: FND_GLOBAL.USER_ID, -- CREATED_BY

1246: SYSDATE, -- LAST_UPDATE_DATE
1247: '0', -- DELETED_FLAG
1248: NULL, -- EFF_FROM
1249: NULL, -- EFF_TO
1250: FND_GLOBAL.USER_ID, -- CREATED_BY
1251: FND_GLOBAL.USER_ID, -- LAST_UPDATED_BY
1252: NULL, -- SECURITY_MASK
1253: NULL, -- EFF_MASK
1254: NULL, -- CHECKOUT_USER

Line 1251: FND_GLOBAL.USER_ID, -- LAST_UPDATED_BY

1247: '0', -- DELETED_FLAG
1248: NULL, -- EFF_FROM
1249: NULL, -- EFF_TO
1250: FND_GLOBAL.USER_ID, -- CREATED_BY
1251: FND_GLOBAL.USER_ID, -- LAST_UPDATED_BY
1252: NULL, -- SECURITY_MASK
1253: NULL, -- EFF_MASK
1254: NULL, -- CHECKOUT_USER
1255: l_language, --LANGUAGE

Line 1427: FND_GLOBAL.USER_ID, --CREATED_BY

1423: NULL, --USER_NUM04,
1424: NULL, --CHECKOUT_USER,
1425: SYSDATE, --CREATION_DATE
1426: SYSDATE, --LAST_UPDATE_DATE
1427: FND_GLOBAL.USER_ID, --CREATED_BY
1428: FND_GLOBAL.USER_ID, --LAST_UPDATED_BY
1429: NULL, --SECURITY_MASK,
1430: G_VARIABLE_MODEL_OPTION_OSR||p_intent||':'||variableCode_tbl(i)||':'||variableOption_tbl(i), --FSK_INTLTEXT_1_1
1431: NULL, --FSK_INTLTEXT_1_EXT,

Line 1428: FND_GLOBAL.USER_ID, --LAST_UPDATED_BY

1424: NULL, --CHECKOUT_USER,
1425: SYSDATE, --CREATION_DATE
1426: SYSDATE, --LAST_UPDATE_DATE
1427: FND_GLOBAL.USER_ID, --CREATED_BY
1428: FND_GLOBAL.USER_ID, --LAST_UPDATED_BY
1429: NULL, --SECURITY_MASK,
1430: G_VARIABLE_MODEL_OPTION_OSR||p_intent||':'||variableCode_tbl(i)||':'||variableOption_tbl(i), --FSK_INTLTEXT_1_1
1431: NULL, --FSK_INTLTEXT_1_EXT,
1432: NULL, --FSK_ITEMMASTER_2_1,

Line 1463: FND_GLOBAL.LOGIN_ID, --LAST_UPDATE_LOGIN,

1459: NULL, --PRIMARY_UOM_CODE,
1460: NULL, --COMPONENT_SEQUENCE_PATH, -- Must be NULL
1461: NULL, --BOM_SORT_ORDER,
1462: NULL, --IB_TRACKABLE,
1463: FND_GLOBAL.LOGIN_ID, --LAST_UPDATE_LOGIN,
1464: NULL, --INITIAL_NUM_VALUE,
1465: G_APPLICATION_ID, --SRC_APPLICATION_ID
1466: NULL, --FSK_ITEMMASTER_2_2,
1467: NULL, --INSTANTIABLE_FLAG,