APPS.AS_SALES_LEAD_ASSIGN_PVT dependencies on AS_ACCESSES_S

Line 3365: SELECT AS_ACCESSES_S.NEXTVAL

3361: l_access_id NUMBER;
3362: l_i NUMBER; -- index to Insert array
3363:
3364: CURSOR c_get_access_id IS
3365: SELECT AS_ACCESSES_S.NEXTVAL
3366: FROM SYS.DUAL;
3367:
3368: BEGIN
3369: l_i := g_i_count;

Line 3509: SELECT AS_ACCESSES_S.NEXTVAL

3505: AND SALES_LEAD_ID = c_sales_lead_id
3506: AND ROWNUM <= 1;
3507:
3508: CURSOR c_get_new_access_id IS
3509: SELECT AS_ACCESSES_S.NEXTVAL
3510: FROM SYS.DUAL;
3511:
3512: BEGIN
3513: IF (AS_DEBUG_LOW_ON) THEN

Line 4258: SELECT as_accesses_s.nextval, SYSDATE, FND_GLOBAL.USER_ID,

4254: ,OWNER_FLAG, CREATED_BY_TAP_FLAG
4255: ,CUSTOMER_ID, ADDRESS_ID, SALES_LEAD_ID, SALESFORCE_ID
4256: ,PERSON_ID, SALES_GROUP_ID, OPEN_FLAG, LEAD_RANK_SCORE
4257: ,OBJECT_CREATION_DATE)
4258: SELECT as_accesses_s.nextval, SYSDATE, FND_GLOBAL.USER_ID,
4259: SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID,
4260: FND_GLOBAL.PROG_APPL_ID, SYSDATE,
4261: 'X', 'Y' ,'N', 'Y', 'N', 'N',
4262: p_customer_id, p_address_id, p_sales_lead_id,

Line 4626: SELECT as_accesses_s.nextval, SYSDATE, FND_GLOBAL.USER_ID,

4622: ,OWNER_FLAG, CREATED_BY_TAP_FLAG
4623: ,CUSTOMER_ID, ADDRESS_ID, SALES_LEAD_ID, SALESFORCE_ID
4624: ,PERSON_ID, SALES_GROUP_ID, REQUEST_ID, OPEN_FLAG
4625: ,LEAD_RANK_SCORE, OBJECT_CREATION_DATE)
4626: SELECT as_accesses_s.nextval, SYSDATE, FND_GLOBAL.USER_ID,
4627: SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID,
4628: FND_GLOBAL.PROG_APPL_ID, SYSDATE,
4629: 'X', l_freeze_flag ,'N','Y', 'Y', 'N',
4630: l_customer_id, l_address_id, p_sales_lead_id,

Line 4969: SELECT as_accesses_s.nextval, SYSDATE, FND_GLOBAL.USER_ID,

4965: ,OWNER_FLAG, CREATED_BY_TAP_FLAG
4966: ,CUSTOMER_ID, ADDRESS_ID, SALES_LEAD_ID, SALESFORCE_ID
4967: ,PERSON_ID, SALES_GROUP_ID, OPEN_FLAG, LEAD_RANK_SCORE
4968: ,OBJECT_CREATION_DATE)
4969: SELECT as_accesses_s.nextval, SYSDATE, FND_GLOBAL.USER_ID,
4970: SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID,
4971: FND_GLOBAL.PROG_APPL_ID, SYSDATE, 'X',
4972: l_freeze_flag ,'N', 'Y', 'Y', 'N',
4973: l_customer_id, l_address_id, p_sales_lead_id,

Line 5306: SELECT as_accesses_s.nextval, SYSDATE, FND_GLOBAL.USER_ID,

5302: ,OWNER_FLAG, CREATED_BY_TAP_FLAG
5303: ,CUSTOMER_ID, ADDRESS_ID, SALES_LEAD_ID, SALESFORCE_ID
5304: ,PERSON_ID, SALES_GROUP_ID, OPEN_FLAG, LEAD_RANK_SCORE
5305: ,OBJECT_CREATION_DATE)
5306: SELECT as_accesses_s.nextval, SYSDATE, FND_GLOBAL.USER_ID,
5307: SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID,
5308: FND_GLOBAL.PROG_APPL_ID, SYSDATE, 'X',
5309: 'Y' ,'N', 'Y', 'Y', 'N',
5310: l_customer_id, l_address_id, p_sales_lead_id,

Line 6105: SELECT as_accesses_s.nextval, SYSDATE, FND_GLOBAL.USER_ID,

6101: ,OWNER_FLAG, CREATED_BY_TAP_FLAG
6102: ,CUSTOMER_ID, ADDRESS_ID, SALES_LEAD_ID, SALESFORCE_ID
6103: ,PERSON_ID, SALES_GROUP_ID, OPEN_FLAG, LEAD_RANK_SCORE
6104: ,OBJECT_CREATION_DATE)
6105: SELECT as_accesses_s.nextval, SYSDATE, FND_GLOBAL.USER_ID,
6106: SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, 'X',
6107: l_freeze_flag ,'N', 'Y', 'Y', 'N',
6108: l_customer_id, l_address_id, p_sales_lead_id,
6109: p_resource_id, p_person_id, p_group_id, l_open_status_flag,