DBA Data[Home] [Help]

APPS.QP_ATTR_GRP_PVT dependencies on FND_GLOBAL

Line 1473: g_created_by_final_tbl(l_atgrp_final_index) := FND_GLOBAL.USER_ID;

1469: g_pricing_attr_count_final_tbl(l_atgrp_final_index) := g_pricing_attr_count_tmp_tbl(grp_no_index);
1470:
1471: -- populate the standard who columns
1472: g_creation_date_final_tbl(l_atgrp_final_index) := sysdate;
1473: g_created_by_final_tbl(l_atgrp_final_index) := FND_GLOBAL.USER_ID;
1474: g_last_update_date_final_tbl(l_atgrp_final_index) := sysdate;
1475: g_last_updated_by_final_tbl(l_atgrp_final_index) := FND_GLOBAL.USER_ID;
1476: g_last_update_login_final_tbl(l_atgrp_final_index) := FND_GLOBAL.LOGIN_ID;
1477: g_program_appl_id_final_tbl(l_atgrp_final_index) := FND_GLOBAL.PROG_APPL_ID;

Line 1475: g_last_updated_by_final_tbl(l_atgrp_final_index) := FND_GLOBAL.USER_ID;

1471: -- populate the standard who columns
1472: g_creation_date_final_tbl(l_atgrp_final_index) := sysdate;
1473: g_created_by_final_tbl(l_atgrp_final_index) := FND_GLOBAL.USER_ID;
1474: g_last_update_date_final_tbl(l_atgrp_final_index) := sysdate;
1475: g_last_updated_by_final_tbl(l_atgrp_final_index) := FND_GLOBAL.USER_ID;
1476: g_last_update_login_final_tbl(l_atgrp_final_index) := FND_GLOBAL.LOGIN_ID;
1477: g_program_appl_id_final_tbl(l_atgrp_final_index) := FND_GLOBAL.PROG_APPL_ID;
1478: g_program_id_final_tbl(l_atgrp_final_index) := FND_GLOBAL.CONC_PROGRAM_ID;
1479: g_program_upd_date_final_tbl(l_atgrp_final_index) := sysdate;

Line 1476: g_last_update_login_final_tbl(l_atgrp_final_index) := FND_GLOBAL.LOGIN_ID;

1472: g_creation_date_final_tbl(l_atgrp_final_index) := sysdate;
1473: g_created_by_final_tbl(l_atgrp_final_index) := FND_GLOBAL.USER_ID;
1474: g_last_update_date_final_tbl(l_atgrp_final_index) := sysdate;
1475: g_last_updated_by_final_tbl(l_atgrp_final_index) := FND_GLOBAL.USER_ID;
1476: g_last_update_login_final_tbl(l_atgrp_final_index) := FND_GLOBAL.LOGIN_ID;
1477: g_program_appl_id_final_tbl(l_atgrp_final_index) := FND_GLOBAL.PROG_APPL_ID;
1478: g_program_id_final_tbl(l_atgrp_final_index) := FND_GLOBAL.CONC_PROGRAM_ID;
1479: g_program_upd_date_final_tbl(l_atgrp_final_index) := sysdate;
1480: g_request_id_final_tbl(l_atgrp_final_index) := FND_GLOBAL.CONC_REQUEST_ID;

Line 1477: g_program_appl_id_final_tbl(l_atgrp_final_index) := FND_GLOBAL.PROG_APPL_ID;

1473: g_created_by_final_tbl(l_atgrp_final_index) := FND_GLOBAL.USER_ID;
1474: g_last_update_date_final_tbl(l_atgrp_final_index) := sysdate;
1475: g_last_updated_by_final_tbl(l_atgrp_final_index) := FND_GLOBAL.USER_ID;
1476: g_last_update_login_final_tbl(l_atgrp_final_index) := FND_GLOBAL.LOGIN_ID;
1477: g_program_appl_id_final_tbl(l_atgrp_final_index) := FND_GLOBAL.PROG_APPL_ID;
1478: g_program_id_final_tbl(l_atgrp_final_index) := FND_GLOBAL.CONC_PROGRAM_ID;
1479: g_program_upd_date_final_tbl(l_atgrp_final_index) := sysdate;
1480: g_request_id_final_tbl(l_atgrp_final_index) := FND_GLOBAL.CONC_REQUEST_ID;
1481:

Line 1478: g_program_id_final_tbl(l_atgrp_final_index) := FND_GLOBAL.CONC_PROGRAM_ID;

1474: g_last_update_date_final_tbl(l_atgrp_final_index) := sysdate;
1475: g_last_updated_by_final_tbl(l_atgrp_final_index) := FND_GLOBAL.USER_ID;
1476: g_last_update_login_final_tbl(l_atgrp_final_index) := FND_GLOBAL.LOGIN_ID;
1477: g_program_appl_id_final_tbl(l_atgrp_final_index) := FND_GLOBAL.PROG_APPL_ID;
1478: g_program_id_final_tbl(l_atgrp_final_index) := FND_GLOBAL.CONC_PROGRAM_ID;
1479: g_program_upd_date_final_tbl(l_atgrp_final_index) := sysdate;
1480: g_request_id_final_tbl(l_atgrp_final_index) := FND_GLOBAL.CONC_REQUEST_ID;
1481:
1482: end if; -- l_other_grp_exists = 'Y' and grp_no_index = -1

Line 1480: g_request_id_final_tbl(l_atgrp_final_index) := FND_GLOBAL.CONC_REQUEST_ID;

1476: g_last_update_login_final_tbl(l_atgrp_final_index) := FND_GLOBAL.LOGIN_ID;
1477: g_program_appl_id_final_tbl(l_atgrp_final_index) := FND_GLOBAL.PROG_APPL_ID;
1478: g_program_id_final_tbl(l_atgrp_final_index) := FND_GLOBAL.CONC_PROGRAM_ID;
1479: g_program_upd_date_final_tbl(l_atgrp_final_index) := sysdate;
1480: g_request_id_final_tbl(l_atgrp_final_index) := FND_GLOBAL.CONC_REQUEST_ID;
1481:
1482: end if; -- l_other_grp_exists = 'Y' and grp_no_index = -1
1483:
1484: grp_no_index := g_qual_grouping_no_tmp_tbl.next(grp_no_index);

Line 1794: g_pattern_cr_by_final_tbl(l_pattern_final_index) := FND_GLOBAL.USER_ID;

1790: g_pattern_pat_type_final_tbl(l_pattern_final_index) := p_pattern_type;
1791: g_pattern_pat_string_final_tbl(l_pattern_final_index) := p_pat_string;
1792:
1793: g_pattern_cr_dt_final_tbl(l_pattern_final_index) := sysdate;
1794: g_pattern_cr_by_final_tbl(l_pattern_final_index) := FND_GLOBAL.USER_ID;
1795: g_pattern_lst_up_dt_final_tbl(l_pattern_final_index) := sysdate;
1796: g_pattern_lt_up_by_final_tbl(l_pattern_final_index) := FND_GLOBAL.USER_ID;
1797: g_pattern_lt_up_lg_final_tbl(l_pattern_final_index) := FND_GLOBAL.LOGIN_ID;
1798: g_pattern_pr_ap_id_final_tbl(l_pattern_final_index) := FND_GLOBAL.PROG_APPL_ID;

Line 1796: g_pattern_lt_up_by_final_tbl(l_pattern_final_index) := FND_GLOBAL.USER_ID;

1792:
1793: g_pattern_cr_dt_final_tbl(l_pattern_final_index) := sysdate;
1794: g_pattern_cr_by_final_tbl(l_pattern_final_index) := FND_GLOBAL.USER_ID;
1795: g_pattern_lst_up_dt_final_tbl(l_pattern_final_index) := sysdate;
1796: g_pattern_lt_up_by_final_tbl(l_pattern_final_index) := FND_GLOBAL.USER_ID;
1797: g_pattern_lt_up_lg_final_tbl(l_pattern_final_index) := FND_GLOBAL.LOGIN_ID;
1798: g_pattern_pr_ap_id_final_tbl(l_pattern_final_index) := FND_GLOBAL.PROG_APPL_ID;
1799: g_pattern_pr_id_final_tbl(l_pattern_final_index) := FND_GLOBAL.CONC_PROGRAM_ID;
1800: g_pattern_pr_up_dt_final_tbl(l_pattern_final_index) := sysdate;

Line 1797: g_pattern_lt_up_lg_final_tbl(l_pattern_final_index) := FND_GLOBAL.LOGIN_ID;

1793: g_pattern_cr_dt_final_tbl(l_pattern_final_index) := sysdate;
1794: g_pattern_cr_by_final_tbl(l_pattern_final_index) := FND_GLOBAL.USER_ID;
1795: g_pattern_lst_up_dt_final_tbl(l_pattern_final_index) := sysdate;
1796: g_pattern_lt_up_by_final_tbl(l_pattern_final_index) := FND_GLOBAL.USER_ID;
1797: g_pattern_lt_up_lg_final_tbl(l_pattern_final_index) := FND_GLOBAL.LOGIN_ID;
1798: g_pattern_pr_ap_id_final_tbl(l_pattern_final_index) := FND_GLOBAL.PROG_APPL_ID;
1799: g_pattern_pr_id_final_tbl(l_pattern_final_index) := FND_GLOBAL.CONC_PROGRAM_ID;
1800: g_pattern_pr_up_dt_final_tbl(l_pattern_final_index) := sysdate;
1801: g_pattern_req_id_final_tbl(l_pattern_final_index) := FND_GLOBAL.CONC_REQUEST_ID;

Line 1798: g_pattern_pr_ap_id_final_tbl(l_pattern_final_index) := FND_GLOBAL.PROG_APPL_ID;

1794: g_pattern_cr_by_final_tbl(l_pattern_final_index) := FND_GLOBAL.USER_ID;
1795: g_pattern_lst_up_dt_final_tbl(l_pattern_final_index) := sysdate;
1796: g_pattern_lt_up_by_final_tbl(l_pattern_final_index) := FND_GLOBAL.USER_ID;
1797: g_pattern_lt_up_lg_final_tbl(l_pattern_final_index) := FND_GLOBAL.LOGIN_ID;
1798: g_pattern_pr_ap_id_final_tbl(l_pattern_final_index) := FND_GLOBAL.PROG_APPL_ID;
1799: g_pattern_pr_id_final_tbl(l_pattern_final_index) := FND_GLOBAL.CONC_PROGRAM_ID;
1800: g_pattern_pr_up_dt_final_tbl(l_pattern_final_index) := sysdate;
1801: g_pattern_req_id_final_tbl(l_pattern_final_index) := FND_GLOBAL.CONC_REQUEST_ID;
1802: end if;

Line 1799: g_pattern_pr_id_final_tbl(l_pattern_final_index) := FND_GLOBAL.CONC_PROGRAM_ID;

1795: g_pattern_lst_up_dt_final_tbl(l_pattern_final_index) := sysdate;
1796: g_pattern_lt_up_by_final_tbl(l_pattern_final_index) := FND_GLOBAL.USER_ID;
1797: g_pattern_lt_up_lg_final_tbl(l_pattern_final_index) := FND_GLOBAL.LOGIN_ID;
1798: g_pattern_pr_ap_id_final_tbl(l_pattern_final_index) := FND_GLOBAL.PROG_APPL_ID;
1799: g_pattern_pr_id_final_tbl(l_pattern_final_index) := FND_GLOBAL.CONC_PROGRAM_ID;
1800: g_pattern_pr_up_dt_final_tbl(l_pattern_final_index) := sysdate;
1801: g_pattern_req_id_final_tbl(l_pattern_final_index) := FND_GLOBAL.CONC_REQUEST_ID;
1802: end if;
1803: end loop; --k in 1..g_pattern_grouping_no_tmp_tbl.count

Line 1801: g_pattern_req_id_final_tbl(l_pattern_final_index) := FND_GLOBAL.CONC_REQUEST_ID;

1797: g_pattern_lt_up_lg_final_tbl(l_pattern_final_index) := FND_GLOBAL.LOGIN_ID;
1798: g_pattern_pr_ap_id_final_tbl(l_pattern_final_index) := FND_GLOBAL.PROG_APPL_ID;
1799: g_pattern_pr_id_final_tbl(l_pattern_final_index) := FND_GLOBAL.CONC_PROGRAM_ID;
1800: g_pattern_pr_up_dt_final_tbl(l_pattern_final_index) := sysdate;
1801: g_pattern_req_id_final_tbl(l_pattern_final_index) := FND_GLOBAL.CONC_REQUEST_ID;
1802: end if;
1803: end loop; --k in 1..g_pattern_grouping_no_tmp_tbl.count
1804: populate_patterns;
1805: end if; -- l_pattern_to_be_created = 'Y'

Line 1953: FND_GLOBAL.USER_ID,

1949: VALUES
1950: (p_pattern_id,
1951: j.pricing_phase_id,
1952: sysdate,
1953: FND_GLOBAL.USER_ID,
1954: sysdate,
1955: FND_GLOBAL.USER_ID,
1956: FND_GLOBAL.LOGIN_ID,
1957: FND_GLOBAL.PROG_APPL_ID,

Line 1955: FND_GLOBAL.USER_ID,

1951: j.pricing_phase_id,
1952: sysdate,
1953: FND_GLOBAL.USER_ID,
1954: sysdate,
1955: FND_GLOBAL.USER_ID,
1956: FND_GLOBAL.LOGIN_ID,
1957: FND_GLOBAL.PROG_APPL_ID,
1958: FND_GLOBAL.CONC_PROGRAM_ID,
1959: sysdate,

Line 1956: FND_GLOBAL.LOGIN_ID,

1952: sysdate,
1953: FND_GLOBAL.USER_ID,
1954: sysdate,
1955: FND_GLOBAL.USER_ID,
1956: FND_GLOBAL.LOGIN_ID,
1957: FND_GLOBAL.PROG_APPL_ID,
1958: FND_GLOBAL.CONC_PROGRAM_ID,
1959: sysdate,
1960: FND_GLOBAL.CONC_REQUEST_ID

Line 1957: FND_GLOBAL.PROG_APPL_ID,

1953: FND_GLOBAL.USER_ID,
1954: sysdate,
1955: FND_GLOBAL.USER_ID,
1956: FND_GLOBAL.LOGIN_ID,
1957: FND_GLOBAL.PROG_APPL_ID,
1958: FND_GLOBAL.CONC_PROGRAM_ID,
1959: sysdate,
1960: FND_GLOBAL.CONC_REQUEST_ID
1961: );

Line 1958: FND_GLOBAL.CONC_PROGRAM_ID,

1954: sysdate,
1955: FND_GLOBAL.USER_ID,
1956: FND_GLOBAL.LOGIN_ID,
1957: FND_GLOBAL.PROG_APPL_ID,
1958: FND_GLOBAL.CONC_PROGRAM_ID,
1959: sysdate,
1960: FND_GLOBAL.CONC_REQUEST_ID
1961: );
1962:

Line 1960: FND_GLOBAL.CONC_REQUEST_ID

1956: FND_GLOBAL.LOGIN_ID,
1957: FND_GLOBAL.PROG_APPL_ID,
1958: FND_GLOBAL.CONC_PROGRAM_ID,
1959: sysdate,
1960: FND_GLOBAL.CONC_REQUEST_ID
1961: );
1962:
1963: if g_call_from_setup <> 'Y' then
1964: commit;

Line 2013: FND_GLOBAL.USER_ID,

2009: VALUES
2010: (p_pattern_id,
2011: p_pricing_phase_id,
2012: sysdate,
2013: FND_GLOBAL.USER_ID,
2014: sysdate,
2015: FND_GLOBAL.USER_ID,
2016: FND_GLOBAL.LOGIN_ID,
2017: FND_GLOBAL.PROG_APPL_ID,

Line 2015: FND_GLOBAL.USER_ID,

2011: p_pricing_phase_id,
2012: sysdate,
2013: FND_GLOBAL.USER_ID,
2014: sysdate,
2015: FND_GLOBAL.USER_ID,
2016: FND_GLOBAL.LOGIN_ID,
2017: FND_GLOBAL.PROG_APPL_ID,
2018: FND_GLOBAL.CONC_PROGRAM_ID,
2019: sysdate,

Line 2016: FND_GLOBAL.LOGIN_ID,

2012: sysdate,
2013: FND_GLOBAL.USER_ID,
2014: sysdate,
2015: FND_GLOBAL.USER_ID,
2016: FND_GLOBAL.LOGIN_ID,
2017: FND_GLOBAL.PROG_APPL_ID,
2018: FND_GLOBAL.CONC_PROGRAM_ID,
2019: sysdate,
2020: FND_GLOBAL.CONC_REQUEST_ID

Line 2017: FND_GLOBAL.PROG_APPL_ID,

2013: FND_GLOBAL.USER_ID,
2014: sysdate,
2015: FND_GLOBAL.USER_ID,
2016: FND_GLOBAL.LOGIN_ID,
2017: FND_GLOBAL.PROG_APPL_ID,
2018: FND_GLOBAL.CONC_PROGRAM_ID,
2019: sysdate,
2020: FND_GLOBAL.CONC_REQUEST_ID
2021: );

Line 2018: FND_GLOBAL.CONC_PROGRAM_ID,

2014: sysdate,
2015: FND_GLOBAL.USER_ID,
2016: FND_GLOBAL.LOGIN_ID,
2017: FND_GLOBAL.PROG_APPL_ID,
2018: FND_GLOBAL.CONC_PROGRAM_ID,
2019: sysdate,
2020: FND_GLOBAL.CONC_REQUEST_ID
2021: );
2022:

Line 2020: FND_GLOBAL.CONC_REQUEST_ID

2016: FND_GLOBAL.LOGIN_ID,
2017: FND_GLOBAL.PROG_APPL_ID,
2018: FND_GLOBAL.CONC_PROGRAM_ID,
2019: sysdate,
2020: FND_GLOBAL.CONC_REQUEST_ID
2021: );
2022:
2023: if g_call_from_setup <> 'Y' then
2024: commit;