APPS.AML_INTERACTION_LEADS_PKG dependencies on AML_INTERACTION_LEADS_S

Line 26: CURSOR C2 IS SELECT AML_INTERACTION_LEADS_S.nextval FROM sys.dual;

22: p_PROGRAM_UPDATE_DATE IN DATE,
23: p_OBJECT_VERSION_NUMBER IN NUMBER,
24: p_SCORE IN NUMBER
25: ) IS
26: CURSOR C2 IS SELECT AML_INTERACTION_LEADS_S.nextval FROM sys.dual;
27: BEGIN
28: IF (px_INTERACTION_LEAD_ID IS NULL) OR
29: (px_INTERACTION_LEAD_ID = FND_API.G_MISS_NUM)
30: THEN

Line 90: update AML_INTERACTION_LEADS set

86: p_OBJECT_VERSION_NUMBER IN NUMBER,
87: p_SCORE IN NUMBER
88: ) is
89: BEGIN
90: update AML_INTERACTION_LEADS set
91: INTERACTION_ID = decode( p_INTERACTION_ID, FND_API.G_MISS_NUM, INTERACTION_ID, p_INTERACTION_ID)
92: ,IMPORT_INTERFACE_ID = decode( p_IMPORT_INTERFACE_ID, FND_API.G_MISS_NUM, IMPORT_INTERFACE_ID, p_IMPORT_INTERFACE_ID)
93: ,SALES_LEAD_ID = decode( p_SALES_LEAD_ID, FND_API.G_MISS_NUM, SALES_LEAD_ID, p_SALES_LEAD_ID)
94: ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)