DBA Data[Home] [Help]

APPS.IEX_TERR_PUB dependencies on AR_COLLECTORS

Line 899: l_resource_id ar_collectors.resource_id%TYPE;

895: l_phone_number varchar2(240);
896: l_phone_extension varchar2(240);
897: l_party_id number;
898:
899: l_resource_id ar_collectors.resource_id%TYPE;
900: l_resource_type ar_collectors.resource_type%TYPE;
901: l_ieu_param_pk_col varchar2(20); --Added for bug#6833110 by PNAVEENK on 29-Aug-2008
902:
903:

Line 900: l_resource_type ar_collectors.resource_type%TYPE;

896: l_phone_extension varchar2(240);
897: l_party_id number;
898:
899: l_resource_id ar_collectors.resource_id%TYPE;
900: l_resource_type ar_collectors.resource_type%TYPE;
901: l_ieu_param_pk_col varchar2(20); --Added for bug#6833110 by PNAVEENK on 29-Aug-2008
902:
903:
904: BEGIN

Line 1027: FROM ar_collectors

1023: --End for bug#6833110
1024:
1025: SELECT resource_id,resource_type
1026: INTO l_resource_id,l_resource_type
1027: FROM ar_collectors
1028: WHERE collector_id = p_collector_id;
1029:
1030: UPDATE IEX_DLN_UWQ_SUMMARY IDS
1031: SET COLLECTOR_ID = P_COLLECTOR_ID,