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_RULES_PVT dependencies on FND_GLOBAL

Line 915: FND_GLOBAL.LOGIN_ID, --LAST_UPDATE_LOGIN

911: SEEDED_FLAG
912: )
913: VALUES
914: (
915: FND_GLOBAL.LOGIN_ID, --LAST_UPDATE_LOGIN
916: NULL, -- LOCALE_ID
917: l_rule_name, --LOCALIZED_STR
918: NULL, -- INTL_TEXT_ID
919: SYSDATE, -- CREATION_DATE

Line 924: FND_GLOBAL.USER_ID, -- CREATED_BY

920: SYSDATE, -- LAST_UPDATE_DATE
921: '0', -- DELETED_FLAG
922: NULL, -- EFF_FROM
923: NULL, -- EFF_TO
924: FND_GLOBAL.USER_ID, -- CREATED_BY
925: FND_GLOBAL.USER_ID, -- LAST_UPDATED_BY
926: NULL, -- SECURITY_MASK
927: NULL, -- EFF_MASK
928: NULL, -- CHECKOUT_USER

Line 925: FND_GLOBAL.USER_ID, -- LAST_UPDATED_BY

921: '0', -- DELETED_FLAG
922: NULL, -- EFF_FROM
923: NULL, -- EFF_TO
924: FND_GLOBAL.USER_ID, -- CREATED_BY
925: FND_GLOBAL.USER_ID, -- LAST_UPDATED_BY
926: NULL, -- SECURITY_MASK
927: NULL, -- EFF_MASK
928: NULL, -- CHECKOUT_USER
929: l_language, --LANGUAGE

Line 969: l_cz_imp_rules.CREATED_BY := FND_GLOBAL.USER_ID;

965: l_cz_imp_rules.LAST_UPDATE_DATE := SYSDATE;
966: l_cz_imp_rules.DELETED_FLAG := l_deleted_flag; -- check
967: l_cz_imp_rules.EFF_FROM := NULL;
968: l_cz_imp_rules.EFF_TO := NULL;
969: l_cz_imp_rules.CREATED_BY := FND_GLOBAL.USER_ID;
970: l_cz_imp_rules.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
971: l_cz_imp_rules.SECURITY_MASK := NULL;
972: l_cz_imp_rules.EFF_MASK := NULL;
973: l_cz_imp_rules.CHECKOUT_USER := NULL;

Line 970: l_cz_imp_rules.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

966: l_cz_imp_rules.DELETED_FLAG := l_deleted_flag; -- check
967: l_cz_imp_rules.EFF_FROM := NULL;
968: l_cz_imp_rules.EFF_TO := NULL;
969: l_cz_imp_rules.CREATED_BY := FND_GLOBAL.USER_ID;
970: l_cz_imp_rules.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
971: l_cz_imp_rules.SECURITY_MASK := NULL;
972: l_cz_imp_rules.EFF_MASK := NULL;
973: l_cz_imp_rules.CHECKOUT_USER := NULL;
974: l_cz_imp_rules.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line 974: l_cz_imp_rules.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

970: l_cz_imp_rules.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
971: l_cz_imp_rules.SECURITY_MASK := NULL;
972: l_cz_imp_rules.EFF_MASK := NULL;
973: l_cz_imp_rules.CHECKOUT_USER := NULL;
974: l_cz_imp_rules.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
975: l_cz_imp_rules.EFFECTIVE_USAGE_MASK := NULL;
976: l_cz_imp_rules.SEQ_NBR := NULL;
977: l_cz_imp_rules.EFFECTIVE_FROM := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_BEGIN;
978: l_cz_imp_rules.EFFECTIVE_UNTIL := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_END;

Line 1231: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID ;

1227: CURSOR csr_rules IS
1228: SELECT rule_id,
1229: published_flag
1230: FROM okc_xprt_rule_hdrs_all
1231: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID ;
1232:
1233: -- Templates Attached to each Rule
1234: CURSOR csr_templates(p_rule_id IN NUMBER) IS
1235: -- Local Rules

Line 1471: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID ;

1467: -- Rules to be Disabled
1468: CURSOR csr_rules IS
1469: SELECT rule_id
1470: FROM okc_xprt_rule_hdrs_all
1471: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID ;
1472:
1473: /*
1474: In case of rules to be disabled we look at the template assciation of the rule is CZ
1475: and delete the same

Line 1931: WHERE r.request_id = fnd_global.conc_request_id;

1927: -- Added Org_id to the cusor for R12
1928: CURSOR csr_intents IS
1929: SELECT distinct intent, org_id
1930: FROM okc_xprt_rule_hdrs_all r
1931: WHERE r.request_id = fnd_global.conc_request_id;
1932:
1933: CURSOR csr_get_var_model_dtl (l_intent VARCHAR2) IS
1934: SELECT devl_project_id, orig_sys_ref
1935: FROM cz_devl_projects

Line 2064: FND_GLOBAL.LOGIN_ID, --LAST_UPDATE_LOGIN

2060: SEEDED_FLAG
2061: )
2062: VALUES
2063: (
2064: FND_GLOBAL.LOGIN_ID, --LAST_UPDATE_LOGIN
2065: NULL, -- LOCALE_ID
2066: l_rule_name, --LOCALIZED_STR -
2067: NULL, -- INTL_TEXT_ID
2068: SYSDATE, -- CREATION_DATE

Line 2073: FND_GLOBAL.USER_ID, -- CREATED_BY

2069: SYSDATE, -- LAST_UPDATE_DATE
2070: '0', -- DELETED_FLAG
2071: NULL, -- EFF_FROM
2072: NULL, -- EFF_TO
2073: FND_GLOBAL.USER_ID, -- CREATED_BY
2074: FND_GLOBAL.USER_ID, -- LAST_UPDATED_BY
2075: NULL, -- SECURITY_MASK
2076: NULL, -- EFF_MASK
2077: NULL, -- CHECKOUT_USER

Line 2074: FND_GLOBAL.USER_ID, -- LAST_UPDATED_BY

2070: '0', -- DELETED_FLAG
2071: NULL, -- EFF_FROM
2072: NULL, -- EFF_TO
2073: FND_GLOBAL.USER_ID, -- CREATED_BY
2074: FND_GLOBAL.USER_ID, -- LAST_UPDATED_BY
2075: NULL, -- SECURITY_MASK
2076: NULL, -- EFF_MASK
2077: NULL, -- CHECKOUT_USER
2078: l_language, --LANGUAGE

Line 2120: l_cz_imp_rules.CREATED_BY := FND_GLOBAL.USER_ID;

2116: l_cz_imp_rules.LAST_UPDATE_DATE := SYSDATE;
2117: l_cz_imp_rules.DELETED_FLAG := 0; -- check
2118: l_cz_imp_rules.EFF_FROM := NULL;
2119: l_cz_imp_rules.EFF_TO := NULL;
2120: l_cz_imp_rules.CREATED_BY := FND_GLOBAL.USER_ID;
2121: l_cz_imp_rules.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2122: l_cz_imp_rules.SECURITY_MASK := NULL;
2123: l_cz_imp_rules.EFF_MASK := NULL;
2124: l_cz_imp_rules.CHECKOUT_USER := NULL;

Line 2121: l_cz_imp_rules.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

2117: l_cz_imp_rules.DELETED_FLAG := 0; -- check
2118: l_cz_imp_rules.EFF_FROM := NULL;
2119: l_cz_imp_rules.EFF_TO := NULL;
2120: l_cz_imp_rules.CREATED_BY := FND_GLOBAL.USER_ID;
2121: l_cz_imp_rules.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2122: l_cz_imp_rules.SECURITY_MASK := NULL;
2123: l_cz_imp_rules.EFF_MASK := NULL;
2124: l_cz_imp_rules.CHECKOUT_USER := NULL;
2125: l_cz_imp_rules.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line 2125: l_cz_imp_rules.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

2121: l_cz_imp_rules.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2122: l_cz_imp_rules.SECURITY_MASK := NULL;
2123: l_cz_imp_rules.EFF_MASK := NULL;
2124: l_cz_imp_rules.CHECKOUT_USER := NULL;
2125: l_cz_imp_rules.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2126: l_cz_imp_rules.EFFECTIVE_USAGE_MASK := NULL;
2127: l_cz_imp_rules.SEQ_NBR := l_seq_nbr;
2128: l_cz_imp_rules.EFFECTIVE_FROM := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_BEGIN;
2129: l_cz_imp_rules.EFFECTIVE_UNTIL := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_END;

Line 2503: FND_GLOBAL.LOGIN_ID, --LAST_UPDATE_LOGIN

2499: SEEDED_FLAG
2500: )
2501: VALUES
2502: (
2503: FND_GLOBAL.LOGIN_ID, --LAST_UPDATE_LOGIN
2504: NULL, -- LOCALE_ID
2505: l_rule_name, --LOCALIZED_STR -
2506: NULL, -- INTL_TEXT_ID
2507: SYSDATE, -- CREATION_DATE

Line 2512: FND_GLOBAL.USER_ID, -- CREATED_BY

2508: SYSDATE, -- LAST_UPDATE_DATE
2509: '0', -- DELETED_FLAG
2510: NULL, -- EFF_FROM
2511: NULL, -- EFF_TO
2512: FND_GLOBAL.USER_ID, -- CREATED_BY
2513: FND_GLOBAL.USER_ID, -- LAST_UPDATED_BY
2514: NULL, -- SECURITY_MASK
2515: NULL, -- EFF_MASK
2516: NULL, -- CHECKOUT_USER

Line 2513: FND_GLOBAL.USER_ID, -- LAST_UPDATED_BY

2509: '0', -- DELETED_FLAG
2510: NULL, -- EFF_FROM
2511: NULL, -- EFF_TO
2512: FND_GLOBAL.USER_ID, -- CREATED_BY
2513: FND_GLOBAL.USER_ID, -- LAST_UPDATED_BY
2514: NULL, -- SECURITY_MASK
2515: NULL, -- EFF_MASK
2516: NULL, -- CHECKOUT_USER
2517: l_language, --LANGUAGE

Line 2559: l_cz_imp_rules.CREATED_BY := FND_GLOBAL.USER_ID;

2555: l_cz_imp_rules.LAST_UPDATE_DATE := SYSDATE;
2556: l_cz_imp_rules.DELETED_FLAG := 0; -- check
2557: l_cz_imp_rules.EFF_FROM := NULL;
2558: l_cz_imp_rules.EFF_TO := NULL;
2559: l_cz_imp_rules.CREATED_BY := FND_GLOBAL.USER_ID;
2560: l_cz_imp_rules.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2561: l_cz_imp_rules.SECURITY_MASK := NULL;
2562: l_cz_imp_rules.EFF_MASK := NULL;
2563: l_cz_imp_rules.CHECKOUT_USER := NULL;

Line 2560: l_cz_imp_rules.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

2556: l_cz_imp_rules.DELETED_FLAG := 0; -- check
2557: l_cz_imp_rules.EFF_FROM := NULL;
2558: l_cz_imp_rules.EFF_TO := NULL;
2559: l_cz_imp_rules.CREATED_BY := FND_GLOBAL.USER_ID;
2560: l_cz_imp_rules.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2561: l_cz_imp_rules.SECURITY_MASK := NULL;
2562: l_cz_imp_rules.EFF_MASK := NULL;
2563: l_cz_imp_rules.CHECKOUT_USER := NULL;
2564: l_cz_imp_rules.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line 2564: l_cz_imp_rules.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

2560: l_cz_imp_rules.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2561: l_cz_imp_rules.SECURITY_MASK := NULL;
2562: l_cz_imp_rules.EFF_MASK := NULL;
2563: l_cz_imp_rules.CHECKOUT_USER := NULL;
2564: l_cz_imp_rules.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2565: l_cz_imp_rules.EFFECTIVE_USAGE_MASK := NULL;
2566: l_cz_imp_rules.SEQ_NBR := l_seq_nbr;
2567: l_cz_imp_rules.EFFECTIVE_FROM := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_BEGIN;
2568: l_cz_imp_rules.EFFECTIVE_UNTIL := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_END;