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