DBA Data[Home] [Help]

APPS.OKC_XPRT_IMPORT_CLAUSES_PVT dependencies on FND_GLOBAL

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

318: SEEDED_FLAG
319: )
320: VALUES
321: (
322: FND_GLOBAL.LOGIN_ID, --LAST_UPDATE_LOGIN
323: NULL, -- LOCALE_ID
324: l_model_component_name, --LOCALIZED_STR
325: NULL, -- INTL_TEXT_ID
326: SYSDATE, -- CREATION_DATE

Line 331: FND_GLOBAL.USER_ID, -- CREATED_BY

327: SYSDATE, -- LAST_UPDATE_DATE
328: '0', -- DELETED_FLAG
329: NULL, -- EFF_FROM
330: NULL, -- EFF_TO
331: FND_GLOBAL.USER_ID, -- CREATED_BY
332: FND_GLOBAL.USER_ID, -- LAST_UPDATED_BY
333: NULL, -- SECURITY_MASK
334: NULL, -- EFF_MASK
335: NULL, -- CHECKOUT_USER

Line 332: FND_GLOBAL.USER_ID, -- LAST_UPDATED_BY

328: '0', -- DELETED_FLAG
329: NULL, -- EFF_FROM
330: NULL, -- EFF_TO
331: FND_GLOBAL.USER_ID, -- CREATED_BY
332: FND_GLOBAL.USER_ID, -- LAST_UPDATED_BY
333: NULL, -- SECURITY_MASK
334: NULL, -- EFF_MASK
335: NULL, -- CHECKOUT_USER
336: l_language, --LANGUAGE

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

398: l_cz_imp_ps_nodes_rec.USER_NUM04:= NULL;
399: l_cz_imp_ps_nodes_rec.CHECKOUT_USER:= NULL;
400: l_cz_imp_ps_nodes_rec.CREATION_DATE:= SYSDATE;
401: l_cz_imp_ps_nodes_rec.LAST_UPDATE_DATE:= SYSDATE;
402: l_cz_imp_ps_nodes_rec.CREATED_BY:= FND_GLOBAL.USER_ID;
403: l_cz_imp_ps_nodes_rec.LAST_UPDATED_BY:= FND_GLOBAL.USER_ID;
404: l_cz_imp_ps_nodes_rec.SECURITY_MASK:= NULL;
405: l_cz_imp_ps_nodes_rec.FSK_INTLTEXT_1_1:= G_CLAUSE_MODEL_TOPNODE_OSR||p_org_id||':'||p_intent;
406: l_cz_imp_ps_nodes_rec.FSK_INTLTEXT_1_EXT:= NULL;

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

399: l_cz_imp_ps_nodes_rec.CHECKOUT_USER:= NULL;
400: l_cz_imp_ps_nodes_rec.CREATION_DATE:= SYSDATE;
401: l_cz_imp_ps_nodes_rec.LAST_UPDATE_DATE:= SYSDATE;
402: l_cz_imp_ps_nodes_rec.CREATED_BY:= FND_GLOBAL.USER_ID;
403: l_cz_imp_ps_nodes_rec.LAST_UPDATED_BY:= FND_GLOBAL.USER_ID;
404: l_cz_imp_ps_nodes_rec.SECURITY_MASK:= NULL;
405: l_cz_imp_ps_nodes_rec.FSK_INTLTEXT_1_1:= G_CLAUSE_MODEL_TOPNODE_OSR||p_org_id||':'||p_intent;
406: l_cz_imp_ps_nodes_rec.FSK_INTLTEXT_1_EXT:= NULL;
407: l_cz_imp_ps_nodes_rec.FSK_ITEMMASTER_2_1:= NULL;

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

434: l_cz_imp_ps_nodes_rec.PRIMARY_UOM_CODE:= NULL;
435: l_cz_imp_ps_nodes_rec.COMPONENT_SEQUENCE_PATH:= NULL; -- Must be NULL
436: l_cz_imp_ps_nodes_rec.BOM_SORT_ORDER:= NULL;
437: l_cz_imp_ps_nodes_rec.IB_TRACKABLE:= NULL;
438: l_cz_imp_ps_nodes_rec.LAST_UPDATE_LOGIN:= FND_GLOBAL.LOGIN_ID;
439: l_cz_imp_ps_nodes_rec.INITIAL_NUM_VALUE:= NULL;
440: l_cz_imp_ps_nodes_rec.SRC_APPLICATION_ID:= G_APPLICATION_ID;
441: l_cz_imp_ps_nodes_rec.FSK_ITEMMASTER_2_2:= NULL;
442: l_cz_imp_ps_nodes_rec.INSTANTIABLE_FLAG:= NULL;

Line 750: FND_GLOBAL.LOGIN_ID, --LAST_UPDATE_LOGIN

746: SEEDED_FLAG
747: )
748: VALUES
749: (
750: FND_GLOBAL.LOGIN_ID, --LAST_UPDATE_LOGIN
751: NULL, -- LOCALE_ID
752: l_model_feature_name, --LOCALIZED_STR
753: NULL, -- INTL_TEXT_ID
754: SYSDATE, -- CREATION_DATE

Line 759: FND_GLOBAL.USER_ID, -- CREATED_BY

755: SYSDATE, -- LAST_UPDATE_DATE
756: '0', -- DELETED_FLAG
757: NULL, -- EFF_FROM
758: NULL, -- EFF_TO
759: FND_GLOBAL.USER_ID, -- CREATED_BY
760: FND_GLOBAL.USER_ID, -- LAST_UPDATED_BY
761: NULL, -- SECURITY_MASK
762: NULL, -- EFF_MASK
763: NULL, -- CHECKOUT_USER

Line 760: FND_GLOBAL.USER_ID, -- LAST_UPDATED_BY

756: '0', -- DELETED_FLAG
757: NULL, -- EFF_FROM
758: NULL, -- EFF_TO
759: FND_GLOBAL.USER_ID, -- CREATED_BY
760: FND_GLOBAL.USER_ID, -- LAST_UPDATED_BY
761: NULL, -- SECURITY_MASK
762: NULL, -- EFF_MASK
763: NULL, -- CHECKOUT_USER
764: l_language, --LANGUAGE

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

826: l_cz_imp_ps_nodes_rec.USER_NUM04:= NULL;
827: l_cz_imp_ps_nodes_rec.CHECKOUT_USER:= NULL;
828: l_cz_imp_ps_nodes_rec.CREATION_DATE:= SYSDATE;
829: l_cz_imp_ps_nodes_rec.LAST_UPDATE_DATE:= SYSDATE;
830: l_cz_imp_ps_nodes_rec.CREATED_BY:= FND_GLOBAL.USER_ID;
831: l_cz_imp_ps_nodes_rec.LAST_UPDATED_BY:= FND_GLOBAL.USER_ID;
832: l_cz_imp_ps_nodes_rec.SECURITY_MASK:= NULL;
833: l_cz_imp_ps_nodes_rec.FSK_INTLTEXT_1_1:= G_CLAUSE_MODEL_FEATURE_OSR||p_org_id||':'||p_intent;
834: l_cz_imp_ps_nodes_rec.FSK_INTLTEXT_1_EXT:= NULL;

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

827: l_cz_imp_ps_nodes_rec.CHECKOUT_USER:= NULL;
828: l_cz_imp_ps_nodes_rec.CREATION_DATE:= SYSDATE;
829: l_cz_imp_ps_nodes_rec.LAST_UPDATE_DATE:= SYSDATE;
830: l_cz_imp_ps_nodes_rec.CREATED_BY:= FND_GLOBAL.USER_ID;
831: l_cz_imp_ps_nodes_rec.LAST_UPDATED_BY:= FND_GLOBAL.USER_ID;
832: l_cz_imp_ps_nodes_rec.SECURITY_MASK:= NULL;
833: l_cz_imp_ps_nodes_rec.FSK_INTLTEXT_1_1:= G_CLAUSE_MODEL_FEATURE_OSR||p_org_id||':'||p_intent;
834: l_cz_imp_ps_nodes_rec.FSK_INTLTEXT_1_EXT:= NULL;
835: l_cz_imp_ps_nodes_rec.FSK_ITEMMASTER_2_1:= NULL;

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

862: l_cz_imp_ps_nodes_rec.PRIMARY_UOM_CODE:= NULL;
863: l_cz_imp_ps_nodes_rec.COMPONENT_SEQUENCE_PATH:= NULL; -- Must be NULL
864: l_cz_imp_ps_nodes_rec.BOM_SORT_ORDER:= NULL;
865: l_cz_imp_ps_nodes_rec.IB_TRACKABLE:= NULL;
866: l_cz_imp_ps_nodes_rec.LAST_UPDATE_LOGIN:= FND_GLOBAL.LOGIN_ID;
867: l_cz_imp_ps_nodes_rec.INITIAL_NUM_VALUE:= NULL;
868: l_cz_imp_ps_nodes_rec.SRC_APPLICATION_ID:= G_APPLICATION_ID;
869: l_cz_imp_ps_nodes_rec.FSK_ITEMMASTER_2_2:= NULL;
870: l_cz_imp_ps_nodes_rec.INSTANTIABLE_FLAG:= NULL;

Line 1233: FND_GLOBAL.LOGIN_ID, --LAST_UPDATE_LOGIN

1229: SEEDED_FLAG
1230: )
1231: VALUES
1232: (
1233: FND_GLOBAL.LOGIN_ID, --LAST_UPDATE_LOGIN
1234: NULL, -- LOCALE_ID
1235: ClauseTitleList_tbl(i), --LOCALIZED_STR
1236: NULL, -- INTL_TEXT_ID
1237: SYSDATE, -- CREATION_DATE

Line 1242: FND_GLOBAL.USER_ID, -- CREATED_BY

1238: SYSDATE, -- LAST_UPDATE_DATE
1239: '0', -- DELETED_FLAG
1240: NULL, -- EFF_FROM
1241: NULL, -- EFF_TO
1242: FND_GLOBAL.USER_ID, -- CREATED_BY
1243: FND_GLOBAL.USER_ID, -- LAST_UPDATED_BY
1244: NULL, -- SECURITY_MASK
1245: NULL, -- EFF_MASK
1246: NULL, -- CHECKOUT_USER

Line 1243: FND_GLOBAL.USER_ID, -- LAST_UPDATED_BY

1239: '0', -- DELETED_FLAG
1240: NULL, -- EFF_FROM
1241: NULL, -- EFF_TO
1242: FND_GLOBAL.USER_ID, -- CREATED_BY
1243: FND_GLOBAL.USER_ID, -- LAST_UPDATED_BY
1244: NULL, -- SECURITY_MASK
1245: NULL, -- EFF_MASK
1246: NULL, -- CHECKOUT_USER
1247: l_language, --LANGUAGE

Line 1410: FND_GLOBAL.USER_ID, --CREATED_BY

1406: NULL, --USER_NUM04,
1407: NULL, --CHECKOUT_USER,
1408: SYSDATE, --CREATION_DATE
1409: SYSDATE, --LAST_UPDATE_DATE
1410: FND_GLOBAL.USER_ID, --CREATED_BY
1411: FND_GLOBAL.USER_ID, --LAST_UPDATED_BY
1412: NULL, --SECURITY_MASK,
1413: G_CLAUSE_MODEL_OPTION_OSR||p_org_id ||':'||p_intent||':'||ClauseIdList_tbl(i),--FSK_INTLTEXT_1_1
1414: NULL, --FSK_INTLTEXT_1_EXT,

Line 1411: FND_GLOBAL.USER_ID, --LAST_UPDATED_BY

1407: NULL, --CHECKOUT_USER,
1408: SYSDATE, --CREATION_DATE
1409: SYSDATE, --LAST_UPDATE_DATE
1410: FND_GLOBAL.USER_ID, --CREATED_BY
1411: FND_GLOBAL.USER_ID, --LAST_UPDATED_BY
1412: NULL, --SECURITY_MASK,
1413: G_CLAUSE_MODEL_OPTION_OSR||p_org_id ||':'||p_intent||':'||ClauseIdList_tbl(i),--FSK_INTLTEXT_1_1
1414: NULL, --FSK_INTLTEXT_1_EXT,
1415: NULL, --FSK_ITEMMASTER_2_1,

Line 1446: FND_GLOBAL.LOGIN_ID, --LAST_UPDATE_LOGIN,

1442: NULL, --PRIMARY_UOM_CODE,
1443: NULL, --COMPONENT_SEQUENCE_PATH, -- Must be NULL
1444: NULL, --BOM_SORT_ORDER,
1445: NULL, --IB_TRACKABLE,
1446: FND_GLOBAL.LOGIN_ID, --LAST_UPDATE_LOGIN,
1447: NULL, --INITIAL_NUM_VALUE,
1448: G_APPLICATION_ID, --SRC_APPLICATION_ID
1449: NULL, --FSK_ITEMMASTER_2_2,
1450: NULL, --INSTANTIABLE_FLAG,

Line 1570: FND_GLOBAL.LOGIN_ID, --LAST_UPDATE_LOGIN

1566: SEEDED_FLAG
1567: )
1568: VALUES
1569: (
1570: FND_GLOBAL.LOGIN_ID, --LAST_UPDATE_LOGIN
1571: NULL, -- LOCALE_ID
1572: l_variable_model_name, --LOCALIZED_STR
1573: NULL, -- INTL_TEXT_ID
1574: SYSDATE, -- CREATION_DATE

Line 1579: FND_GLOBAL.USER_ID, -- CREATED_BY

1575: SYSDATE, -- LAST_UPDATE_DATE
1576: '0', -- DELETED_FLAG
1577: NULL, -- EFF_FROM
1578: NULL, -- EFF_TO
1579: FND_GLOBAL.USER_ID, -- CREATED_BY
1580: FND_GLOBAL.USER_ID, -- LAST_UPDATED_BY
1581: NULL, -- SECURITY_MASK
1582: NULL, -- EFF_MASK
1583: NULL, -- CHECKOUT_USER

Line 1580: FND_GLOBAL.USER_ID, -- LAST_UPDATED_BY

1576: '0', -- DELETED_FLAG
1577: NULL, -- EFF_FROM
1578: NULL, -- EFF_TO
1579: FND_GLOBAL.USER_ID, -- CREATED_BY
1580: FND_GLOBAL.USER_ID, -- LAST_UPDATED_BY
1581: NULL, -- SECURITY_MASK
1582: NULL, -- EFF_MASK
1583: NULL, -- CHECKOUT_USER
1584: l_language, --LANGUAGE

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

1646: l_cz_imp_ps_nodes_rec.USER_NUM04:= NULL;
1647: l_cz_imp_ps_nodes_rec.CHECKOUT_USER:= NULL;
1648: l_cz_imp_ps_nodes_rec.CREATION_DATE:= SYSDATE;
1649: l_cz_imp_ps_nodes_rec.LAST_UPDATE_DATE:= SYSDATE;
1650: l_cz_imp_ps_nodes_rec.CREATED_BY:= FND_GLOBAL.USER_ID;
1651: l_cz_imp_ps_nodes_rec.LAST_UPDATED_BY:= FND_GLOBAL.USER_ID;
1652: l_cz_imp_ps_nodes_rec.SECURITY_MASK:= NULL;
1653: l_cz_imp_ps_nodes_rec.FSK_INTLTEXT_1_1:= G_CLAUSE_MODEL_VM_REF_NODE_OSR||p_org_id||':'||p_intent;
1654: l_cz_imp_ps_nodes_rec.FSK_INTLTEXT_1_EXT:= NULL;

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

1647: l_cz_imp_ps_nodes_rec.CHECKOUT_USER:= NULL;
1648: l_cz_imp_ps_nodes_rec.CREATION_DATE:= SYSDATE;
1649: l_cz_imp_ps_nodes_rec.LAST_UPDATE_DATE:= SYSDATE;
1650: l_cz_imp_ps_nodes_rec.CREATED_BY:= FND_GLOBAL.USER_ID;
1651: l_cz_imp_ps_nodes_rec.LAST_UPDATED_BY:= FND_GLOBAL.USER_ID;
1652: l_cz_imp_ps_nodes_rec.SECURITY_MASK:= NULL;
1653: l_cz_imp_ps_nodes_rec.FSK_INTLTEXT_1_1:= G_CLAUSE_MODEL_VM_REF_NODE_OSR||p_org_id||':'||p_intent;
1654: l_cz_imp_ps_nodes_rec.FSK_INTLTEXT_1_EXT:= NULL;
1655: l_cz_imp_ps_nodes_rec.FSK_ITEMMASTER_2_1:= NULL;

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

1682: l_cz_imp_ps_nodes_rec.PRIMARY_UOM_CODE:= NULL;
1683: l_cz_imp_ps_nodes_rec.COMPONENT_SEQUENCE_PATH:= NULL; -- Must be NULL
1684: l_cz_imp_ps_nodes_rec.BOM_SORT_ORDER:= NULL;
1685: l_cz_imp_ps_nodes_rec.IB_TRACKABLE:= NULL;
1686: l_cz_imp_ps_nodes_rec.LAST_UPDATE_LOGIN:= FND_GLOBAL.LOGIN_ID;
1687: l_cz_imp_ps_nodes_rec.INITIAL_NUM_VALUE:= NULL;
1688: l_cz_imp_ps_nodes_rec.SRC_APPLICATION_ID:= G_APPLICATION_ID;
1689: l_cz_imp_ps_nodes_rec.FSK_ITEMMASTER_2_2:= NULL;
1690: l_cz_imp_ps_nodes_rec.INSTANTIABLE_FLAG:= '4';