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

Line 815: p_rule_header_rec.created_by := fnd_global.user_id;

811:
812: -- Start Defaulting 'WHO' columns
813: IF p_rule_header_rec.created_by = okc_api.g_miss_num
814: THEN
815: p_rule_header_rec.created_by := fnd_global.user_id;
816: END IF;
817:
818: IF p_rule_header_rec.creation_date = okc_api.g_miss_date
819: THEN

Line 825: p_rule_header_rec.last_updated_by := fnd_global.user_id;

821: END IF;
822:
823: IF p_rule_header_rec.last_updated_by = okc_api.g_miss_num
824: THEN
825: p_rule_header_rec.last_updated_by := fnd_global.user_id;
826: END IF;
827:
828: IF p_rule_header_rec.last_update_date = okc_api.g_miss_date
829: THEN

Line 835: p_rule_header_rec.last_update_login := fnd_global.login_id;

831: END IF;
832:
833: IF p_rule_header_rec.last_update_login = okc_api.g_miss_num
834: THEN
835: p_rule_header_rec.last_update_login := fnd_global.login_id;
836: END IF;
837:
838: IF fnd_global.conc_request_id = -1
839: THEN

Line 838: IF fnd_global.conc_request_id = -1

834: THEN
835: p_rule_header_rec.last_update_login := fnd_global.login_id;
836: END IF;
837:
838: IF fnd_global.conc_request_id = -1
839: THEN
840: p_rule_header_rec.request_id := NULL;
841: ELSE
842: p_rule_header_rec.request_id := fnd_global.conc_request_id;

Line 842: p_rule_header_rec.request_id := fnd_global.conc_request_id;

838: IF fnd_global.conc_request_id = -1
839: THEN
840: p_rule_header_rec.request_id := NULL;
841: ELSE
842: p_rule_header_rec.request_id := fnd_global.conc_request_id;
843: END IF;
844:
845: IF fnd_global.conc_program_id = -1
846: THEN

Line 845: IF fnd_global.conc_program_id = -1

841: ELSE
842: p_rule_header_rec.request_id := fnd_global.conc_request_id;
843: END IF;
844:
845: IF fnd_global.conc_program_id = -1
846: THEN
847: p_rule_header_rec.program_id := NULL;
848: p_rule_header_rec.program_update_date := NULL;
849: ELSE

Line 850: p_rule_header_rec.program_id := fnd_global.conc_program_id;

846: THEN
847: p_rule_header_rec.program_id := NULL;
848: p_rule_header_rec.program_update_date := NULL;
849: ELSE
850: p_rule_header_rec.program_id := fnd_global.conc_program_id;
851: -- Directly initializing it to the sysdate
852: p_rule_header_rec.program_update_date := SYSDATE;
853: END IF;
854:

Line 855: IF fnd_global.prog_appl_id = -1

851: -- Directly initializing it to the sysdate
852: p_rule_header_rec.program_update_date := SYSDATE;
853: END IF;
854:
855: IF fnd_global.prog_appl_id = -1
856: THEN
857: p_rule_header_rec.program_application_id := NULL;
858: ELSE
859: p_rule_header_rec.program_application_id :=

Line 860: fnd_global.prog_appl_id;

856: THEN
857: p_rule_header_rec.program_application_id := NULL;
858: ELSE
859: p_rule_header_rec.program_application_id :=
860: fnd_global.prog_appl_id;
861: END IF;
862: END default_rule_header;
863:
864: PROCEDURE validate_header (p_rule_header_rec IN rule_header_rec_type)

Line 1598: fnd_global.user_id, SYSDATE, fnd_global.user_id,

1594: p_rule_condition_rec.OPERATOR,
1595: p_rule_condition_rec.object_value_set_name,
1596: p_rule_condition_rec.object_value_type,
1597: p_rule_condition_rec.object_value_code, 1,
1598: fnd_global.user_id, SYSDATE, fnd_global.user_id,
1599: SYSDATE, fnd_global.login_id
1600: )
1601: RETURNING rule_condition_id
1602: INTO p_rule_condition_rec.rule_condition_id;

Line 1599: SYSDATE, fnd_global.login_id

1595: p_rule_condition_rec.object_value_set_name,
1596: p_rule_condition_rec.object_value_type,
1597: p_rule_condition_rec.object_value_code, 1,
1598: fnd_global.user_id, SYSDATE, fnd_global.user_id,
1599: SYSDATE, fnd_global.login_id
1600: )
1601: RETURNING rule_condition_id
1602: INTO p_rule_condition_rec.rule_condition_id;
1603:

Line 1679: fnd_global.user_id, SYSDATE, fnd_global.user_id,

1675: p_rule_condition_id
1676: --p_rule_cond_vals_tbl(i).rule_condition_id
1677: ,
1678: p_rule_cond_vals_tbl (i).object_value_code, 1,
1679: fnd_global.user_id, SYSDATE, fnd_global.user_id,
1680: SYSDATE, fnd_global.login_id
1681: )
1682: RETURNING rule_condition_value_id,
1683: rule_condition_id

Line 1680: SYSDATE, fnd_global.login_id

1676: --p_rule_cond_vals_tbl(i).rule_condition_id
1677: ,
1678: p_rule_cond_vals_tbl (i).object_value_code, 1,
1679: fnd_global.user_id, SYSDATE, fnd_global.user_id,
1680: SYSDATE, fnd_global.login_id
1681: )
1682: RETURNING rule_condition_value_id,
1683: rule_condition_id
1684: INTO p_rule_cond_vals_tbl (i).rule_condition_value_id,

Line 1849: fnd_global.user_id, SYSDATE, fnd_global.user_id,

1845: VALUES (okc_xprt_rule_outcomes_s.NEXTVAL,
1846: p_rule_outcome_rec.rule_id,
1847: p_rule_outcome_rec.object_type,
1848: p_rule_outcome_rec.object_value_id, 1,
1849: fnd_global.user_id, SYSDATE, fnd_global.user_id,
1850: SYSDATE, fnd_global.login_id,p_rule_outcome_rec.mandatory_yn, p_rule_outcome_rec.mandatory_rwa
1851: )
1852: RETURNING rule_outcome_id
1853: INTO p_rule_outcome_rec.rule_outcome_id;

Line 1850: SYSDATE, fnd_global.login_id,p_rule_outcome_rec.mandatory_yn, p_rule_outcome_rec.mandatory_rwa

1846: p_rule_outcome_rec.rule_id,
1847: p_rule_outcome_rec.object_type,
1848: p_rule_outcome_rec.object_value_id, 1,
1849: fnd_global.user_id, SYSDATE, fnd_global.user_id,
1850: SYSDATE, fnd_global.login_id,p_rule_outcome_rec.mandatory_yn, p_rule_outcome_rec.mandatory_rwa
1851: )
1852: RETURNING rule_outcome_id
1853: INTO p_rule_outcome_rec.rule_outcome_id;
1854: EXCEPTION

Line 1971: p_template_rules_rec.created_by := fnd_global.user_id;

1967: p_template_rules_rec.rule_id := g_rule_id;
1968: p_template_rules_rec.deleted_flag := 'N';
1969: p_template_rules_rec.published_flag := NULL;
1970: p_template_rules_rec.object_version_number := 1;
1971: p_template_rules_rec.created_by := fnd_global.user_id;
1972: p_template_rules_rec.creation_date := SYSDATE;
1973: p_template_rules_rec.last_updated_by := fnd_global.user_id;
1974: p_template_rules_rec.last_update_date := SYSDATE;
1975: p_template_rules_rec.last_update_login := fnd_global.login_id;

Line 1973: p_template_rules_rec.last_updated_by := fnd_global.user_id;

1969: p_template_rules_rec.published_flag := NULL;
1970: p_template_rules_rec.object_version_number := 1;
1971: p_template_rules_rec.created_by := fnd_global.user_id;
1972: p_template_rules_rec.creation_date := SYSDATE;
1973: p_template_rules_rec.last_updated_by := fnd_global.user_id;
1974: p_template_rules_rec.last_update_date := SYSDATE;
1975: p_template_rules_rec.last_update_login := fnd_global.login_id;
1976:
1977: -- Validate

Line 1975: p_template_rules_rec.last_update_login := fnd_global.login_id;

1971: p_template_rules_rec.created_by := fnd_global.user_id;
1972: p_template_rules_rec.creation_date := SYSDATE;
1973: p_template_rules_rec.last_updated_by := fnd_global.user_id;
1974: p_template_rules_rec.last_update_date := SYSDATE;
1975: p_template_rules_rec.last_update_login := fnd_global.login_id;
1976:
1977: -- Validate
1978: IF p_template_rules_rec.template_id IS NULL
1979: THEN

Line 2087: p_rule_header_rec.last_updated_by := fnd_global.user_id;

2083: p_db_rule_header IN okc_xprt_rule_hdrs_all%ROWTYPE
2084: )
2085: IS
2086: BEGIN
2087: p_rule_header_rec.last_updated_by := fnd_global.user_id;
2088: p_rule_header_rec.last_update_date := SYSDATE;
2089: p_rule_header_rec.last_update_login := fnd_global.login_id;
2090:
2091: IF p_rule_header_rec.org_id = okc_api.g_miss_num

Line 2089: p_rule_header_rec.last_update_login := fnd_global.login_id;

2085: IS
2086: BEGIN
2087: p_rule_header_rec.last_updated_by := fnd_global.user_id;
2088: p_rule_header_rec.last_update_date := SYSDATE;
2089: p_rule_header_rec.last_update_login := fnd_global.login_id;
2090:
2091: IF p_rule_header_rec.org_id = okc_api.g_miss_num
2092: THEN
2093: p_rule_header_rec.org_id := p_db_rule_header.org_id;

Line 2238: last_updated_by = fnd_global.user_id,

2234: rule_description = p_rule_header_rec.rule_description,
2235: org_wide_flag = p_rule_header_rec.org_wide_flag,
2236: condition_expr_code = p_rule_header_rec.condition_expr_code,
2237: object_version_number = object_version_number + 1,
2238: last_updated_by = fnd_global.user_id,
2239: last_update_date = SYSDATE,
2240: last_update_login = fnd_global.login_id
2241: WHERE rule_id = p_rule_header_rec.rule_id;
2242: EXCEPTION

Line 2240: last_update_login = fnd_global.login_id

2236: condition_expr_code = p_rule_header_rec.condition_expr_code,
2237: object_version_number = object_version_number + 1,
2238: last_updated_by = fnd_global.user_id,
2239: last_update_date = SYSDATE,
2240: last_update_login = fnd_global.login_id
2241: WHERE rule_id = p_rule_header_rec.rule_id;
2242: EXCEPTION
2243: WHEN OTHERS
2244: THEN