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;
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;
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;
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:
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
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);
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;
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;
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;
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;
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
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'
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,
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,
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
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: );
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:
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;
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,
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,
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
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: );
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:
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;