DBA Data[Home] [Help]

APPS.QP_ATTR_GRP_PVT dependencies on FND_GLOBAL

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

1463: g_pricing_attr_count_final_tbl(l_atgrp_final_index) := g_pricing_attr_count_tmp_tbl(grp_no_index);
1464:
1465: -- populate the standard who columns
1466: g_creation_date_final_tbl(l_atgrp_final_index) := sysdate;
1467: g_created_by_final_tbl(l_atgrp_final_index) := FND_GLOBAL.USER_ID;
1468: g_last_update_date_final_tbl(l_atgrp_final_index) := sysdate;
1469: g_last_updated_by_final_tbl(l_atgrp_final_index) := FND_GLOBAL.USER_ID;
1470: g_last_update_login_final_tbl(l_atgrp_final_index) := FND_GLOBAL.LOGIN_ID;
1471: g_program_appl_id_final_tbl(l_atgrp_final_index) := FND_GLOBAL.PROG_APPL_ID;

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

1465: -- populate the standard who columns
1466: g_creation_date_final_tbl(l_atgrp_final_index) := sysdate;
1467: g_created_by_final_tbl(l_atgrp_final_index) := FND_GLOBAL.USER_ID;
1468: g_last_update_date_final_tbl(l_atgrp_final_index) := sysdate;
1469: g_last_updated_by_final_tbl(l_atgrp_final_index) := FND_GLOBAL.USER_ID;
1470: g_last_update_login_final_tbl(l_atgrp_final_index) := FND_GLOBAL.LOGIN_ID;
1471: g_program_appl_id_final_tbl(l_atgrp_final_index) := FND_GLOBAL.PROG_APPL_ID;
1472: g_program_id_final_tbl(l_atgrp_final_index) := FND_GLOBAL.CONC_PROGRAM_ID;
1473: g_program_upd_date_final_tbl(l_atgrp_final_index) := sysdate;

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

1466: g_creation_date_final_tbl(l_atgrp_final_index) := sysdate;
1467: g_created_by_final_tbl(l_atgrp_final_index) := FND_GLOBAL.USER_ID;
1468: g_last_update_date_final_tbl(l_atgrp_final_index) := sysdate;
1469: g_last_updated_by_final_tbl(l_atgrp_final_index) := FND_GLOBAL.USER_ID;
1470: g_last_update_login_final_tbl(l_atgrp_final_index) := FND_GLOBAL.LOGIN_ID;
1471: g_program_appl_id_final_tbl(l_atgrp_final_index) := FND_GLOBAL.PROG_APPL_ID;
1472: g_program_id_final_tbl(l_atgrp_final_index) := FND_GLOBAL.CONC_PROGRAM_ID;
1473: g_program_upd_date_final_tbl(l_atgrp_final_index) := sysdate;
1474: g_request_id_final_tbl(l_atgrp_final_index) := FND_GLOBAL.CONC_REQUEST_ID;

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

1467: g_created_by_final_tbl(l_atgrp_final_index) := FND_GLOBAL.USER_ID;
1468: g_last_update_date_final_tbl(l_atgrp_final_index) := sysdate;
1469: g_last_updated_by_final_tbl(l_atgrp_final_index) := FND_GLOBAL.USER_ID;
1470: g_last_update_login_final_tbl(l_atgrp_final_index) := FND_GLOBAL.LOGIN_ID;
1471: g_program_appl_id_final_tbl(l_atgrp_final_index) := FND_GLOBAL.PROG_APPL_ID;
1472: g_program_id_final_tbl(l_atgrp_final_index) := FND_GLOBAL.CONC_PROGRAM_ID;
1473: g_program_upd_date_final_tbl(l_atgrp_final_index) := sysdate;
1474: g_request_id_final_tbl(l_atgrp_final_index) := FND_GLOBAL.CONC_REQUEST_ID;
1475:

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

1468: g_last_update_date_final_tbl(l_atgrp_final_index) := sysdate;
1469: g_last_updated_by_final_tbl(l_atgrp_final_index) := FND_GLOBAL.USER_ID;
1470: g_last_update_login_final_tbl(l_atgrp_final_index) := FND_GLOBAL.LOGIN_ID;
1471: g_program_appl_id_final_tbl(l_atgrp_final_index) := FND_GLOBAL.PROG_APPL_ID;
1472: g_program_id_final_tbl(l_atgrp_final_index) := FND_GLOBAL.CONC_PROGRAM_ID;
1473: g_program_upd_date_final_tbl(l_atgrp_final_index) := sysdate;
1474: g_request_id_final_tbl(l_atgrp_final_index) := FND_GLOBAL.CONC_REQUEST_ID;
1475:
1476: end if; -- l_other_grp_exists = 'Y' and grp_no_index = -1

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

1470: g_last_update_login_final_tbl(l_atgrp_final_index) := FND_GLOBAL.LOGIN_ID;
1471: g_program_appl_id_final_tbl(l_atgrp_final_index) := FND_GLOBAL.PROG_APPL_ID;
1472: g_program_id_final_tbl(l_atgrp_final_index) := FND_GLOBAL.CONC_PROGRAM_ID;
1473: g_program_upd_date_final_tbl(l_atgrp_final_index) := sysdate;
1474: g_request_id_final_tbl(l_atgrp_final_index) := FND_GLOBAL.CONC_REQUEST_ID;
1475:
1476: end if; -- l_other_grp_exists = 'Y' and grp_no_index = -1
1477:
1478: grp_no_index := g_qual_grouping_no_tmp_tbl.next(grp_no_index);

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

1784: g_pattern_pat_type_final_tbl(l_pattern_final_index) := p_pattern_type;
1785: g_pattern_pat_string_final_tbl(l_pattern_final_index) := p_pat_string;
1786:
1787: g_pattern_cr_dt_final_tbl(l_pattern_final_index) := sysdate;
1788: g_pattern_cr_by_final_tbl(l_pattern_final_index) := FND_GLOBAL.USER_ID;
1789: g_pattern_lst_up_dt_final_tbl(l_pattern_final_index) := sysdate;
1790: g_pattern_lt_up_by_final_tbl(l_pattern_final_index) := FND_GLOBAL.USER_ID;
1791: g_pattern_lt_up_lg_final_tbl(l_pattern_final_index) := FND_GLOBAL.LOGIN_ID;
1792: g_pattern_pr_ap_id_final_tbl(l_pattern_final_index) := FND_GLOBAL.PROG_APPL_ID;

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

1786:
1787: g_pattern_cr_dt_final_tbl(l_pattern_final_index) := sysdate;
1788: g_pattern_cr_by_final_tbl(l_pattern_final_index) := FND_GLOBAL.USER_ID;
1789: g_pattern_lst_up_dt_final_tbl(l_pattern_final_index) := sysdate;
1790: g_pattern_lt_up_by_final_tbl(l_pattern_final_index) := FND_GLOBAL.USER_ID;
1791: g_pattern_lt_up_lg_final_tbl(l_pattern_final_index) := FND_GLOBAL.LOGIN_ID;
1792: g_pattern_pr_ap_id_final_tbl(l_pattern_final_index) := FND_GLOBAL.PROG_APPL_ID;
1793: g_pattern_pr_id_final_tbl(l_pattern_final_index) := FND_GLOBAL.CONC_PROGRAM_ID;
1794: g_pattern_pr_up_dt_final_tbl(l_pattern_final_index) := sysdate;

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

1787: g_pattern_cr_dt_final_tbl(l_pattern_final_index) := sysdate;
1788: g_pattern_cr_by_final_tbl(l_pattern_final_index) := FND_GLOBAL.USER_ID;
1789: g_pattern_lst_up_dt_final_tbl(l_pattern_final_index) := sysdate;
1790: g_pattern_lt_up_by_final_tbl(l_pattern_final_index) := FND_GLOBAL.USER_ID;
1791: g_pattern_lt_up_lg_final_tbl(l_pattern_final_index) := FND_GLOBAL.LOGIN_ID;
1792: g_pattern_pr_ap_id_final_tbl(l_pattern_final_index) := FND_GLOBAL.PROG_APPL_ID;
1793: g_pattern_pr_id_final_tbl(l_pattern_final_index) := FND_GLOBAL.CONC_PROGRAM_ID;
1794: g_pattern_pr_up_dt_final_tbl(l_pattern_final_index) := sysdate;
1795: g_pattern_req_id_final_tbl(l_pattern_final_index) := FND_GLOBAL.CONC_REQUEST_ID;

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

1788: g_pattern_cr_by_final_tbl(l_pattern_final_index) := FND_GLOBAL.USER_ID;
1789: g_pattern_lst_up_dt_final_tbl(l_pattern_final_index) := sysdate;
1790: g_pattern_lt_up_by_final_tbl(l_pattern_final_index) := FND_GLOBAL.USER_ID;
1791: g_pattern_lt_up_lg_final_tbl(l_pattern_final_index) := FND_GLOBAL.LOGIN_ID;
1792: g_pattern_pr_ap_id_final_tbl(l_pattern_final_index) := FND_GLOBAL.PROG_APPL_ID;
1793: g_pattern_pr_id_final_tbl(l_pattern_final_index) := FND_GLOBAL.CONC_PROGRAM_ID;
1794: g_pattern_pr_up_dt_final_tbl(l_pattern_final_index) := sysdate;
1795: g_pattern_req_id_final_tbl(l_pattern_final_index) := FND_GLOBAL.CONC_REQUEST_ID;
1796: end if;

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

1789: g_pattern_lst_up_dt_final_tbl(l_pattern_final_index) := sysdate;
1790: g_pattern_lt_up_by_final_tbl(l_pattern_final_index) := FND_GLOBAL.USER_ID;
1791: g_pattern_lt_up_lg_final_tbl(l_pattern_final_index) := FND_GLOBAL.LOGIN_ID;
1792: g_pattern_pr_ap_id_final_tbl(l_pattern_final_index) := FND_GLOBAL.PROG_APPL_ID;
1793: g_pattern_pr_id_final_tbl(l_pattern_final_index) := FND_GLOBAL.CONC_PROGRAM_ID;
1794: g_pattern_pr_up_dt_final_tbl(l_pattern_final_index) := sysdate;
1795: g_pattern_req_id_final_tbl(l_pattern_final_index) := FND_GLOBAL.CONC_REQUEST_ID;
1796: end if;
1797: end loop; --k in 1..g_pattern_grouping_no_tmp_tbl.count

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

1791: g_pattern_lt_up_lg_final_tbl(l_pattern_final_index) := FND_GLOBAL.LOGIN_ID;
1792: g_pattern_pr_ap_id_final_tbl(l_pattern_final_index) := FND_GLOBAL.PROG_APPL_ID;
1793: g_pattern_pr_id_final_tbl(l_pattern_final_index) := FND_GLOBAL.CONC_PROGRAM_ID;
1794: g_pattern_pr_up_dt_final_tbl(l_pattern_final_index) := sysdate;
1795: g_pattern_req_id_final_tbl(l_pattern_final_index) := FND_GLOBAL.CONC_REQUEST_ID;
1796: end if;
1797: end loop; --k in 1..g_pattern_grouping_no_tmp_tbl.count
1798: populate_patterns;
1799: end if; -- l_pattern_to_be_created = 'Y'

Line 1947: FND_GLOBAL.USER_ID,

1943: VALUES
1944: (p_pattern_id,
1945: j.pricing_phase_id,
1946: sysdate,
1947: FND_GLOBAL.USER_ID,
1948: sysdate,
1949: FND_GLOBAL.USER_ID,
1950: FND_GLOBAL.LOGIN_ID,
1951: FND_GLOBAL.PROG_APPL_ID,

Line 1949: FND_GLOBAL.USER_ID,

1945: j.pricing_phase_id,
1946: sysdate,
1947: FND_GLOBAL.USER_ID,
1948: sysdate,
1949: FND_GLOBAL.USER_ID,
1950: FND_GLOBAL.LOGIN_ID,
1951: FND_GLOBAL.PROG_APPL_ID,
1952: FND_GLOBAL.CONC_PROGRAM_ID,
1953: sysdate,

Line 1950: FND_GLOBAL.LOGIN_ID,

1946: sysdate,
1947: FND_GLOBAL.USER_ID,
1948: sysdate,
1949: FND_GLOBAL.USER_ID,
1950: FND_GLOBAL.LOGIN_ID,
1951: FND_GLOBAL.PROG_APPL_ID,
1952: FND_GLOBAL.CONC_PROGRAM_ID,
1953: sysdate,
1954: FND_GLOBAL.CONC_REQUEST_ID

Line 1951: FND_GLOBAL.PROG_APPL_ID,

1947: FND_GLOBAL.USER_ID,
1948: sysdate,
1949: FND_GLOBAL.USER_ID,
1950: FND_GLOBAL.LOGIN_ID,
1951: FND_GLOBAL.PROG_APPL_ID,
1952: FND_GLOBAL.CONC_PROGRAM_ID,
1953: sysdate,
1954: FND_GLOBAL.CONC_REQUEST_ID
1955: );

Line 1952: FND_GLOBAL.CONC_PROGRAM_ID,

1948: sysdate,
1949: FND_GLOBAL.USER_ID,
1950: FND_GLOBAL.LOGIN_ID,
1951: FND_GLOBAL.PROG_APPL_ID,
1952: FND_GLOBAL.CONC_PROGRAM_ID,
1953: sysdate,
1954: FND_GLOBAL.CONC_REQUEST_ID
1955: );
1956:

Line 1954: FND_GLOBAL.CONC_REQUEST_ID

1950: FND_GLOBAL.LOGIN_ID,
1951: FND_GLOBAL.PROG_APPL_ID,
1952: FND_GLOBAL.CONC_PROGRAM_ID,
1953: sysdate,
1954: FND_GLOBAL.CONC_REQUEST_ID
1955: );
1956:
1957: if g_call_from_setup <> 'Y' then
1958: commit;

Line 2007: FND_GLOBAL.USER_ID,

2003: VALUES
2004: (p_pattern_id,
2005: p_pricing_phase_id,
2006: sysdate,
2007: FND_GLOBAL.USER_ID,
2008: sysdate,
2009: FND_GLOBAL.USER_ID,
2010: FND_GLOBAL.LOGIN_ID,
2011: FND_GLOBAL.PROG_APPL_ID,

Line 2009: FND_GLOBAL.USER_ID,

2005: p_pricing_phase_id,
2006: sysdate,
2007: FND_GLOBAL.USER_ID,
2008: sysdate,
2009: FND_GLOBAL.USER_ID,
2010: FND_GLOBAL.LOGIN_ID,
2011: FND_GLOBAL.PROG_APPL_ID,
2012: FND_GLOBAL.CONC_PROGRAM_ID,
2013: sysdate,

Line 2010: FND_GLOBAL.LOGIN_ID,

2006: sysdate,
2007: FND_GLOBAL.USER_ID,
2008: sysdate,
2009: FND_GLOBAL.USER_ID,
2010: FND_GLOBAL.LOGIN_ID,
2011: FND_GLOBAL.PROG_APPL_ID,
2012: FND_GLOBAL.CONC_PROGRAM_ID,
2013: sysdate,
2014: FND_GLOBAL.CONC_REQUEST_ID

Line 2011: FND_GLOBAL.PROG_APPL_ID,

2007: FND_GLOBAL.USER_ID,
2008: sysdate,
2009: FND_GLOBAL.USER_ID,
2010: FND_GLOBAL.LOGIN_ID,
2011: FND_GLOBAL.PROG_APPL_ID,
2012: FND_GLOBAL.CONC_PROGRAM_ID,
2013: sysdate,
2014: FND_GLOBAL.CONC_REQUEST_ID
2015: );

Line 2012: FND_GLOBAL.CONC_PROGRAM_ID,

2008: sysdate,
2009: FND_GLOBAL.USER_ID,
2010: FND_GLOBAL.LOGIN_ID,
2011: FND_GLOBAL.PROG_APPL_ID,
2012: FND_GLOBAL.CONC_PROGRAM_ID,
2013: sysdate,
2014: FND_GLOBAL.CONC_REQUEST_ID
2015: );
2016:

Line 2014: FND_GLOBAL.CONC_REQUEST_ID

2010: FND_GLOBAL.LOGIN_ID,
2011: FND_GLOBAL.PROG_APPL_ID,
2012: FND_GLOBAL.CONC_PROGRAM_ID,
2013: sysdate,
2014: FND_GLOBAL.CONC_REQUEST_ID
2015: );
2016:
2017: if g_call_from_setup <> 'Y' then
2018: commit;