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

925: SEEDED_FLAG
926: )
927: VALUES
928: (
929: FND_GLOBAL.LOGIN_ID, --LAST_UPDATE_LOGIN
930: NULL, -- LOCALE_ID
931: l_rule_name, --LOCALIZED_STR
932: NULL, -- INTL_TEXT_ID
933: SYSDATE, -- CREATION_DATE

Line 938: FND_GLOBAL.USER_ID, -- CREATED_BY

934: SYSDATE, -- LAST_UPDATE_DATE
935: '0', -- DELETED_FLAG
936: NULL, -- EFF_FROM
937: NULL, -- EFF_TO
938: FND_GLOBAL.USER_ID, -- CREATED_BY
939: FND_GLOBAL.USER_ID, -- LAST_UPDATED_BY
940: NULL, -- SECURITY_MASK
941: NULL, -- EFF_MASK
942: NULL, -- CHECKOUT_USER

Line 939: FND_GLOBAL.USER_ID, -- LAST_UPDATED_BY

935: '0', -- DELETED_FLAG
936: NULL, -- EFF_FROM
937: NULL, -- EFF_TO
938: FND_GLOBAL.USER_ID, -- CREATED_BY
939: FND_GLOBAL.USER_ID, -- LAST_UPDATED_BY
940: NULL, -- SECURITY_MASK
941: NULL, -- EFF_MASK
942: NULL, -- CHECKOUT_USER
943: l_language, --LANGUAGE

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

979: l_cz_imp_rules.LAST_UPDATE_DATE := SYSDATE;
980: l_cz_imp_rules.DELETED_FLAG := l_deleted_flag; -- check
981: l_cz_imp_rules.EFF_FROM := NULL;
982: l_cz_imp_rules.EFF_TO := NULL;
983: l_cz_imp_rules.CREATED_BY := FND_GLOBAL.USER_ID;
984: l_cz_imp_rules.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
985: l_cz_imp_rules.SECURITY_MASK := NULL;
986: l_cz_imp_rules.EFF_MASK := NULL;
987: l_cz_imp_rules.CHECKOUT_USER := NULL;

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

980: l_cz_imp_rules.DELETED_FLAG := l_deleted_flag; -- check
981: l_cz_imp_rules.EFF_FROM := NULL;
982: l_cz_imp_rules.EFF_TO := NULL;
983: l_cz_imp_rules.CREATED_BY := FND_GLOBAL.USER_ID;
984: l_cz_imp_rules.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
985: l_cz_imp_rules.SECURITY_MASK := NULL;
986: l_cz_imp_rules.EFF_MASK := NULL;
987: l_cz_imp_rules.CHECKOUT_USER := NULL;
988: l_cz_imp_rules.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

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

984: l_cz_imp_rules.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
985: l_cz_imp_rules.SECURITY_MASK := NULL;
986: l_cz_imp_rules.EFF_MASK := NULL;
987: l_cz_imp_rules.CHECKOUT_USER := NULL;
988: l_cz_imp_rules.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
989: l_cz_imp_rules.EFFECTIVE_USAGE_MASK := NULL;
990: l_cz_imp_rules.SEQ_NBR := NULL;
991: l_cz_imp_rules.EFFECTIVE_FROM := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_BEGIN;
992: l_cz_imp_rules.EFFECTIVE_UNTIL := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_END;

Line 1245: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID ;

1241: CURSOR csr_rules IS
1242: SELECT rule_id,
1243: published_flag
1244: FROM okc_xprt_rule_hdrs_all
1245: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID ;
1246:
1247: -- Templates Attached to each Rule
1248: CURSOR csr_templates(p_rule_id IN NUMBER) IS
1249: -- Local Rules

Line 1485: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID ;

1481: -- Rules to be Disabled
1482: CURSOR csr_rules IS
1483: SELECT rule_id
1484: FROM okc_xprt_rule_hdrs_all
1485: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID ;
1486:
1487: /*
1488: In case of rules to be disabled we look at the template assciation of the rule is CZ
1489: and delete the same

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

1941: -- Added Org_id to the cusor for R12
1942: CURSOR csr_intents IS
1943: SELECT distinct intent, org_id
1944: FROM okc_xprt_rule_hdrs_all r
1945: WHERE r.request_id = fnd_global.conc_request_id;
1946:
1947: CURSOR csr_get_var_model_dtl (l_intent VARCHAR2) IS
1948: SELECT devl_project_id, orig_sys_ref
1949: FROM cz_devl_projects

Line 2078: FND_GLOBAL.LOGIN_ID, --LAST_UPDATE_LOGIN

2074: SEEDED_FLAG
2075: )
2076: VALUES
2077: (
2078: FND_GLOBAL.LOGIN_ID, --LAST_UPDATE_LOGIN
2079: NULL, -- LOCALE_ID
2080: l_rule_name, --LOCALIZED_STR -
2081: NULL, -- INTL_TEXT_ID
2082: SYSDATE, -- CREATION_DATE

Line 2087: FND_GLOBAL.USER_ID, -- CREATED_BY

2083: SYSDATE, -- LAST_UPDATE_DATE
2084: '0', -- DELETED_FLAG
2085: NULL, -- EFF_FROM
2086: NULL, -- EFF_TO
2087: FND_GLOBAL.USER_ID, -- CREATED_BY
2088: FND_GLOBAL.USER_ID, -- LAST_UPDATED_BY
2089: NULL, -- SECURITY_MASK
2090: NULL, -- EFF_MASK
2091: NULL, -- CHECKOUT_USER

Line 2088: FND_GLOBAL.USER_ID, -- LAST_UPDATED_BY

2084: '0', -- DELETED_FLAG
2085: NULL, -- EFF_FROM
2086: NULL, -- EFF_TO
2087: FND_GLOBAL.USER_ID, -- CREATED_BY
2088: FND_GLOBAL.USER_ID, -- LAST_UPDATED_BY
2089: NULL, -- SECURITY_MASK
2090: NULL, -- EFF_MASK
2091: NULL, -- CHECKOUT_USER
2092: l_language, --LANGUAGE

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

2130: l_cz_imp_rules.LAST_UPDATE_DATE := SYSDATE;
2131: l_cz_imp_rules.DELETED_FLAG := 0; -- check
2132: l_cz_imp_rules.EFF_FROM := NULL;
2133: l_cz_imp_rules.EFF_TO := NULL;
2134: l_cz_imp_rules.CREATED_BY := FND_GLOBAL.USER_ID;
2135: l_cz_imp_rules.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2136: l_cz_imp_rules.SECURITY_MASK := NULL;
2137: l_cz_imp_rules.EFF_MASK := NULL;
2138: l_cz_imp_rules.CHECKOUT_USER := NULL;

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

2131: l_cz_imp_rules.DELETED_FLAG := 0; -- check
2132: l_cz_imp_rules.EFF_FROM := NULL;
2133: l_cz_imp_rules.EFF_TO := NULL;
2134: l_cz_imp_rules.CREATED_BY := FND_GLOBAL.USER_ID;
2135: l_cz_imp_rules.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2136: l_cz_imp_rules.SECURITY_MASK := NULL;
2137: l_cz_imp_rules.EFF_MASK := NULL;
2138: l_cz_imp_rules.CHECKOUT_USER := NULL;
2139: l_cz_imp_rules.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

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

2135: l_cz_imp_rules.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2136: l_cz_imp_rules.SECURITY_MASK := NULL;
2137: l_cz_imp_rules.EFF_MASK := NULL;
2138: l_cz_imp_rules.CHECKOUT_USER := NULL;
2139: l_cz_imp_rules.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2140: l_cz_imp_rules.EFFECTIVE_USAGE_MASK := NULL;
2141: l_cz_imp_rules.SEQ_NBR := l_seq_nbr;
2142: l_cz_imp_rules.EFFECTIVE_FROM := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_BEGIN;
2143: l_cz_imp_rules.EFFECTIVE_UNTIL := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_END;

Line 2517: FND_GLOBAL.LOGIN_ID, --LAST_UPDATE_LOGIN

2513: SEEDED_FLAG
2514: )
2515: VALUES
2516: (
2517: FND_GLOBAL.LOGIN_ID, --LAST_UPDATE_LOGIN
2518: NULL, -- LOCALE_ID
2519: l_rule_name, --LOCALIZED_STR -
2520: NULL, -- INTL_TEXT_ID
2521: SYSDATE, -- CREATION_DATE

Line 2526: FND_GLOBAL.USER_ID, -- CREATED_BY

2522: SYSDATE, -- LAST_UPDATE_DATE
2523: '0', -- DELETED_FLAG
2524: NULL, -- EFF_FROM
2525: NULL, -- EFF_TO
2526: FND_GLOBAL.USER_ID, -- CREATED_BY
2527: FND_GLOBAL.USER_ID, -- LAST_UPDATED_BY
2528: NULL, -- SECURITY_MASK
2529: NULL, -- EFF_MASK
2530: NULL, -- CHECKOUT_USER

Line 2527: FND_GLOBAL.USER_ID, -- LAST_UPDATED_BY

2523: '0', -- DELETED_FLAG
2524: NULL, -- EFF_FROM
2525: NULL, -- EFF_TO
2526: FND_GLOBAL.USER_ID, -- CREATED_BY
2527: FND_GLOBAL.USER_ID, -- LAST_UPDATED_BY
2528: NULL, -- SECURITY_MASK
2529: NULL, -- EFF_MASK
2530: NULL, -- CHECKOUT_USER
2531: l_language, --LANGUAGE

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

2569: l_cz_imp_rules.LAST_UPDATE_DATE := SYSDATE;
2570: l_cz_imp_rules.DELETED_FLAG := 0; -- check
2571: l_cz_imp_rules.EFF_FROM := NULL;
2572: l_cz_imp_rules.EFF_TO := NULL;
2573: l_cz_imp_rules.CREATED_BY := FND_GLOBAL.USER_ID;
2574: l_cz_imp_rules.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2575: l_cz_imp_rules.SECURITY_MASK := NULL;
2576: l_cz_imp_rules.EFF_MASK := NULL;
2577: l_cz_imp_rules.CHECKOUT_USER := NULL;

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

2570: l_cz_imp_rules.DELETED_FLAG := 0; -- check
2571: l_cz_imp_rules.EFF_FROM := NULL;
2572: l_cz_imp_rules.EFF_TO := NULL;
2573: l_cz_imp_rules.CREATED_BY := FND_GLOBAL.USER_ID;
2574: l_cz_imp_rules.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2575: l_cz_imp_rules.SECURITY_MASK := NULL;
2576: l_cz_imp_rules.EFF_MASK := NULL;
2577: l_cz_imp_rules.CHECKOUT_USER := NULL;
2578: l_cz_imp_rules.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

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

2574: l_cz_imp_rules.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2575: l_cz_imp_rules.SECURITY_MASK := NULL;
2576: l_cz_imp_rules.EFF_MASK := NULL;
2577: l_cz_imp_rules.CHECKOUT_USER := NULL;
2578: l_cz_imp_rules.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2579: l_cz_imp_rules.EFFECTIVE_USAGE_MASK := NULL;
2580: l_cz_imp_rules.SEQ_NBR := l_seq_nbr;
2581: l_cz_imp_rules.EFFECTIVE_FROM := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_BEGIN;
2582: l_cz_imp_rules.EFFECTIVE_UNTIL := OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_END;