APPS.HZ_BATCH_ACTION_PUB dependencies on HZ_IMP_BATCH_SUMMARY

Line 1940: FROM hz_imp_batch_summary

1936:
1937: /*Cursor action( p_batch_id IN NUMBER ) IS
1938: SELECT BD_ACTION_ON_PARTIES,BD_ACTION_ON_ADDRESSES,
1939: BD_ACTION_ON_CONTACTS,BD_ACTION_ON_CONTACT_POINTS
1940: FROM hz_imp_batch_summary
1941: WHERE batch_id = p_batch_id;
1942:
1943: l_action_on_parties hz_imp_batch_summary.BD_ACTION_ON_PARTIES%TYPE;
1944: l_action_on_addresses hz_imp_batch_summary.BD_ACTION_ON_ADDRESSES%TYPE;

Line 1943: l_action_on_parties hz_imp_batch_summary.BD_ACTION_ON_PARTIES%TYPE;

1939: BD_ACTION_ON_CONTACTS,BD_ACTION_ON_CONTACT_POINTS
1940: FROM hz_imp_batch_summary
1941: WHERE batch_id = p_batch_id;
1942:
1943: l_action_on_parties hz_imp_batch_summary.BD_ACTION_ON_PARTIES%TYPE;
1944: l_action_on_addresses hz_imp_batch_summary.BD_ACTION_ON_ADDRESSES%TYPE;
1945: l_action_on_contacts hz_imp_batch_summary.BD_ACTION_ON_CONTACTS%TYPE;
1946: l_action_on_cont_points hz_imp_batch_summary.BD_ACTION_ON_CONTACT_POINTS%TYPE;
1947: */

Line 1944: l_action_on_addresses hz_imp_batch_summary.BD_ACTION_ON_ADDRESSES%TYPE;

1940: FROM hz_imp_batch_summary
1941: WHERE batch_id = p_batch_id;
1942:
1943: l_action_on_parties hz_imp_batch_summary.BD_ACTION_ON_PARTIES%TYPE;
1944: l_action_on_addresses hz_imp_batch_summary.BD_ACTION_ON_ADDRESSES%TYPE;
1945: l_action_on_contacts hz_imp_batch_summary.BD_ACTION_ON_CONTACTS%TYPE;
1946: l_action_on_cont_points hz_imp_batch_summary.BD_ACTION_ON_CONTACT_POINTS%TYPE;
1947: */
1948: l_debug_prefix VARCHAR2(30) := '';

Line 1945: l_action_on_contacts hz_imp_batch_summary.BD_ACTION_ON_CONTACTS%TYPE;

1941: WHERE batch_id = p_batch_id;
1942:
1943: l_action_on_parties hz_imp_batch_summary.BD_ACTION_ON_PARTIES%TYPE;
1944: l_action_on_addresses hz_imp_batch_summary.BD_ACTION_ON_ADDRESSES%TYPE;
1945: l_action_on_contacts hz_imp_batch_summary.BD_ACTION_ON_CONTACTS%TYPE;
1946: l_action_on_cont_points hz_imp_batch_summary.BD_ACTION_ON_CONTACT_POINTS%TYPE;
1947: */
1948: l_debug_prefix VARCHAR2(30) := '';
1949:

Line 1946: l_action_on_cont_points hz_imp_batch_summary.BD_ACTION_ON_CONTACT_POINTS%TYPE;

1942:
1943: l_action_on_parties hz_imp_batch_summary.BD_ACTION_ON_PARTIES%TYPE;
1944: l_action_on_addresses hz_imp_batch_summary.BD_ACTION_ON_ADDRESSES%TYPE;
1945: l_action_on_contacts hz_imp_batch_summary.BD_ACTION_ON_CONTACTS%TYPE;
1946: l_action_on_cont_points hz_imp_batch_summary.BD_ACTION_ON_CONTACT_POINTS%TYPE;
1947: */
1948: l_debug_prefix VARCHAR2(30) := '';
1949:
1950:

Line 1975: -- Update hz_imp_batch_summary table

1971:
1972:
1973: action_on_entities ( p_batch_id , 'PARTY' , p_action_on_parties );
1974:
1975: -- Update hz_imp_batch_summary table
1976: UPDATE HZ_IMP_BATCH_SUMMARY
1977: SET BD_ACTION_ON_PARTIES = p_action_on_parties
1978: WHERE batch_id = p_batch_id;
1979:

Line 1976: UPDATE HZ_IMP_BATCH_SUMMARY

1972:
1973: action_on_entities ( p_batch_id , 'PARTY' , p_action_on_parties );
1974:
1975: -- Update hz_imp_batch_summary table
1976: UPDATE HZ_IMP_BATCH_SUMMARY
1977: SET BD_ACTION_ON_PARTIES = p_action_on_parties
1978: WHERE batch_id = p_batch_id;
1979:
1980:

Line 1985: --Update hz_imp_batch_summary table

1981:
1982:
1983: action_on_entities ( p_batch_id , 'PARTY_SITES', p_action_on_addresses ) ;
1984:
1985: --Update hz_imp_batch_summary table
1986: UPDATE HZ_IMP_BATCH_SUMMARY
1987: SET BD_ACTION_ON_ADDRESSES = p_action_on_addresses
1988: WHERE batch_id = p_batch_id;
1989:

Line 1986: UPDATE HZ_IMP_BATCH_SUMMARY

1982:
1983: action_on_entities ( p_batch_id , 'PARTY_SITES', p_action_on_addresses ) ;
1984:
1985: --Update hz_imp_batch_summary table
1986: UPDATE HZ_IMP_BATCH_SUMMARY
1987: SET BD_ACTION_ON_ADDRESSES = p_action_on_addresses
1988: WHERE batch_id = p_batch_id;
1989:
1990:

Line 1995: --Update hz_imp_batch_summary table

1991:
1992:
1993: action_on_entities ( p_batch_id , 'CONTACTS',p_action_on_contacts );
1994:
1995: --Update hz_imp_batch_summary table
1996: UPDATE HZ_IMP_BATCH_SUMMARY
1997: SET BD_ACTION_ON_CONTACTS = p_action_on_contacts
1998: WHERE batch_id = p_batch_id;
1999:

Line 1996: UPDATE HZ_IMP_BATCH_SUMMARY

1992:
1993: action_on_entities ( p_batch_id , 'CONTACTS',p_action_on_contacts );
1994:
1995: --Update hz_imp_batch_summary table
1996: UPDATE HZ_IMP_BATCH_SUMMARY
1997: SET BD_ACTION_ON_CONTACTS = p_action_on_contacts
1998: WHERE batch_id = p_batch_id;
1999:
2000:

Line 2005: --Update hz_imp_batch_summary table

2001:
2002:
2003: action_on_entities ( p_batch_id , 'CONTACT_POINTS' , p_action_on_contact_points);
2004:
2005: --Update hz_imp_batch_summary table
2006: UPDATE HZ_IMP_BATCH_SUMMARY
2007: SET BD_ACTION_ON_CONTACT_POINTS = p_action_on_contact_points
2008: WHERE batch_id = p_batch_id;
2009:

Line 2006: UPDATE HZ_IMP_BATCH_SUMMARY

2002:
2003: action_on_entities ( p_batch_id , 'CONTACT_POINTS' , p_action_on_contact_points);
2004:
2005: --Update hz_imp_batch_summary table
2006: UPDATE HZ_IMP_BATCH_SUMMARY
2007: SET BD_ACTION_ON_CONTACT_POINTS = p_action_on_contact_points
2008: WHERE batch_id = p_batch_id;
2009:
2010: