DBA Data[Home] [Help]

APPS.AS_SALES_LEAD_ASSIGN_PVT dependencies on AS_ACCESSES_S

Line 3366: SELECT AS_ACCESSES_S.NEXTVAL

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

Line 3510: SELECT AS_ACCESSES_S.NEXTVAL

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

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

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

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

4644: ,OWNER_FLAG, CREATED_BY_TAP_FLAG
4645: ,CUSTOMER_ID, ADDRESS_ID, SALES_LEAD_ID, SALESFORCE_ID
4646: ,PERSON_ID, SALES_GROUP_ID, REQUEST_ID, OPEN_FLAG
4647: ,LEAD_RANK_SCORE, OBJECT_CREATION_DATE)
4648: SELECT as_accesses_s.nextval, SYSDATE, FND_GLOBAL.USER_ID,
4649: SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID,
4650: FND_GLOBAL.PROG_APPL_ID, SYSDATE,
4651: 'X', l_freeze_flag ,'N','Y', 'Y', 'N',
4652: l_customer_id, l_address_id, p_sales_lead_id,

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

4989: ,OWNER_FLAG, CREATED_BY_TAP_FLAG
4990: ,CUSTOMER_ID, ADDRESS_ID, SALES_LEAD_ID, SALESFORCE_ID
4991: ,PERSON_ID, SALES_GROUP_ID, OPEN_FLAG, LEAD_RANK_SCORE
4992: ,OBJECT_CREATION_DATE)
4993: SELECT as_accesses_s.nextval, SYSDATE, FND_GLOBAL.USER_ID,
4994: SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID,
4995: FND_GLOBAL.PROG_APPL_ID, SYSDATE, 'X',
4996: l_freeze_flag ,'N', 'Y', 'Y', 'N',
4997: l_customer_id, l_address_id, p_sales_lead_id,

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

5326: ,OWNER_FLAG, CREATED_BY_TAP_FLAG
5327: ,CUSTOMER_ID, ADDRESS_ID, SALES_LEAD_ID, SALESFORCE_ID
5328: ,PERSON_ID, SALES_GROUP_ID, OPEN_FLAG, LEAD_RANK_SCORE
5329: ,OBJECT_CREATION_DATE)
5330: SELECT as_accesses_s.nextval, SYSDATE, FND_GLOBAL.USER_ID,
5331: SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID,
5332: FND_GLOBAL.PROG_APPL_ID, SYSDATE, 'X',
5333: 'Y' ,'N', 'Y', 'Y', 'N',
5334: l_customer_id, l_address_id, p_sales_lead_id,

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

6125: ,OWNER_FLAG, CREATED_BY_TAP_FLAG
6126: ,CUSTOMER_ID, ADDRESS_ID, SALES_LEAD_ID, SALESFORCE_ID
6127: ,PERSON_ID, SALES_GROUP_ID, OPEN_FLAG, LEAD_RANK_SCORE
6128: ,OBJECT_CREATION_DATE)
6129: SELECT as_accesses_s.nextval, SYSDATE, FND_GLOBAL.USER_ID,
6130: SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, 'X',
6131: l_freeze_flag ,'N', 'Y', 'Y', 'N',
6132: l_customer_id, l_address_id, p_sales_lead_id,
6133: p_resource_id, p_person_id, p_group_id, l_open_status_flag,