APPS.PNP_CMERGE dependencies on PN_SPACE_ASSIGN_CUST

Line 128: FROM pn_space_assign_cust

124: FOR UPDATE NOWAIT;
125: /* Lock Customer Assignments */
126: CURSOR cust_assignments IS
127: SELECT cust_space_assign_id
128: FROM pn_space_assign_cust
129: WHERE cust_account_id IN
130: (SELECT racm.duplicate_id
131: FROM ra_customer_merges racm
132: WHERE racm.process_flag = 'N'

Line 216: arp_message.set_token( 'TABLE_NAME', 'PN_SPACE_ASSIGN_CUST', FALSE );

212: CLOSE rec_period_lines;
213:
214: /* Lock Customer Assignments */
215: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
216: arp_message.set_token( 'TABLE_NAME', 'PN_SPACE_ASSIGN_CUST', FALSE );
217:
218: OPEN cust_assignments;
219: CLOSE cust_assignments;
220:

Line 1964: | Account merge procedure for the table, pn_space_assign_cust_all

1960: | PROCEDURE
1961: | update_space_assign_cust
1962: |
1963: | DESCRIPTION
1964: | Account merge procedure for the table, pn_space_assign_cust_all
1965: | Column updated Corresponding HZ table.column
1966: | -------------------- -----------------------------
1967: | cust_account_id HZ_CUST_ACCOUNTS.cust_account_id
1968: | site_use_id HZ_CUST_SITE_USES.site_use_id

Line 1995: PN_SPACE_ASSIGN_CUST.cust_space_assign_id%TYPE

1991: INDEX BY BINARY_INTEGER;
1992: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
1993:
1994: TYPE cust_space_assign_id_LIST_TYPE IS TABLE OF
1995: PN_SPACE_ASSIGN_CUST.cust_space_assign_id%TYPE
1996: INDEX BY BINARY_INTEGER;
1997: PRIMARY_KEY_ID_LIST cust_space_assign_id_LIST_TYPE;
1998:
1999: TYPE CUST_ACCOUNT_ID_LIST_TYPE IS TABLE OF

Line 2000: PN_SPACE_ASSIGN_CUST.CUST_ACCOUNT_ID%TYPE

1996: INDEX BY BINARY_INTEGER;
1997: PRIMARY_KEY_ID_LIST cust_space_assign_id_LIST_TYPE;
1998:
1999: TYPE CUST_ACCOUNT_ID_LIST_TYPE IS TABLE OF
2000: PN_SPACE_ASSIGN_CUST.CUST_ACCOUNT_ID%TYPE
2001: INDEX BY BINARY_INTEGER;
2002: NUM_COL1_ORIG_LIST CUST_ACCOUNT_ID_LIST_TYPE;
2003: NUM_COL1_NEW_LIST CUST_ACCOUNT_ID_LIST_TYPE;
2004:

Line 2006: PN_SPACE_ASSIGN_CUST.SITE_USE_ID%TYPE

2002: NUM_COL1_ORIG_LIST CUST_ACCOUNT_ID_LIST_TYPE;
2003: NUM_COL1_NEW_LIST CUST_ACCOUNT_ID_LIST_TYPE;
2004:
2005: TYPE SITE_USE_ID_LIST_TYPE IS TABLE OF
2006: PN_SPACE_ASSIGN_CUST.SITE_USE_ID%TYPE
2007: INDEX BY BINARY_INTEGER;
2008: NUM_COL2_ORIG_LIST SITE_USE_ID_LIST_TYPE;
2009: NUM_COL2_NEW_LIST SITE_USE_ID_LIST_TYPE;
2010:

Line 2018: FROM PN_SPACE_ASSIGN_CUST yt

2014: m.CUSTOMER_MERGE_HEADER_ID
2015: ,yt.cust_space_assign_id
2016: ,yt.CUST_ACCOUNT_ID
2017: ,yt.SITE_USE_ID
2018: FROM PN_SPACE_ASSIGN_CUST yt
2019: ,RA_CUSTOMER_MERGES m
2020: WHERE ( yt.CUST_ACCOUNT_ID = m.DUPLICATE_ID
2021: OR yt.SITE_USE_ID = m.DUPLICATE_SITE_ID )
2022: AND m.process_flag = 'N'

Line 2038: arp_message.set_token('TABLE_NAME','PN_SPACE_ASSIGN_CUST',FALSE);

2034: IF process_mode='LOCK' THEN
2035: NULL;
2036: ELSE
2037: arp_message.set_name('AR','AR_UPDATING_TABLE');
2038: arp_message.set_token('TABLE_NAME','PN_SPACE_ASSIGN_CUST',FALSE);
2039: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
2040: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
2041:
2042: OPEN merged_records;

Line 2086: 'PN_SPACE_ASSIGN_CUST',

2082: LAST_UPDATE_DATE,
2083: LAST_UPDATED_BY
2084: ) VALUES (
2085: HZ_CUSTOMER_MERGE_LOG_s.NEXTVAL,
2086: 'PN_SPACE_ASSIGN_CUST',
2087: MERGE_HEADER_ID_LIST(I),
2088: PRIMARY_KEY_ID_LIST(I),
2089: NUM_COL1_ORIG_LIST(I),
2090: NUM_COL1_NEW_LIST(I),

Line 2105: UPDATE PN_SPACE_ASSIGN_CUST yt SET

2101:
2102: END IF;
2103:
2104: FORALL I IN 1..MERGE_HEADER_ID_LIST.COUNT
2105: UPDATE PN_SPACE_ASSIGN_CUST yt SET
2106: CUST_ACCOUNT_ID=NUM_COL1_NEW_LIST(I)
2107: ,SITE_USE_ID=NUM_COL2_NEW_LIST(I)
2108: ,LAST_UPDATE_DATE=SYSDATE
2109: ,last_updated_by=arp_standard.profile.user_id