APPS.AS_ACCESSES_PKG dependencies on AS_ACCESSES_ALL

Line 82: CURSOR C IS SELECT rowid FROM as_accesses_all

78: X_object_creation_date DATE,
79: X_contributor_flag VARCHAR2 -- Added for ASNB
80:
81: ) IS
82: CURSOR C IS SELECT rowid FROM as_accesses_all
83: WHERE access_id = X_Access_Id;
84: CURSOR C2 IS SELECT as_accesses_s.nextval FROM sys.dual;
85: BEGIN
86: if (X_Access_Id is NULL or x_access_id = fnd_api.g_miss_num) then

Line 91: INSERT INTO as_accesses_all(

87: OPEN C2;
88: FETCH C2 INTO X_Access_Id;
89: CLOSE C2;
90: end if;
91: INSERT INTO as_accesses_all(
92: access_id,
93: last_update_date,
94: last_updated_by,
95: creation_date,

Line 254: FROM as_accesses_all

250: X_contributor_flag VARCHAR2 -- Added for ASNB
251: ) IS
252: CURSOR C IS
253: SELECT *
254: FROM as_accesses_all
255: WHERE rowid = X_Rowid
256: FOR UPDATE of Access_Id NOWAIT;
257: Recinfo C%ROWTYPE;
258: BEGIN

Line 452: UPDATE as_accesses_all

448: X_prm_keep_flag VARCHAR2,
449: X_contributor_flag VARCHAR2 -- Added for ASNB
450: ) IS
451: BEGIN
452: UPDATE as_accesses_all
453: SET object_version_number = nvl(object_version_number,0) + 1,
454: access_id = X_Access_Id,
455: last_update_date = X_Last_Update_Date,
456: last_updated_by = X_Last_Updated_By,

Line 511: DELETE FROM as_accesses_all

507: END Update_Row;
508:
509: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
510: BEGIN
511: DELETE FROM as_accesses_all
512: WHERE rowid = X_Rowid;
513:
514: if (SQL%NOTFOUND) then
515: RAISE NO_DATA_FOUND;

Line 553: from as_accesses_all

549: X_Acc_Id NUMBER;
550: BEGIN
551: select access_id
552: into X_Acc_Id
553: from as_accesses_all
554: where customer_id = X_Customer_Id
555: -- and address_id = X_Address_Id
556: and salesforce_id = X_Salesforce_Id
557: and person_id = X_Person_Id

Line 587: from as_accesses_all

583: X_Team_Leader_FLag OUT NOCOPY VARCHAR2) RETURN BOOLEAN IS
584: cursor Get_Access_Row (x_customer_id number, x_address_id number, x_salesforce_id number,
585: x_person_id number, x_lead_id number) IS
586: select Team_Leader_Flag
587: from as_accesses_all
588: where customer_id = X_Customer_Id
589: -- and address_id = X_Address_Id
590: and salesforce_id = X_Salesforce_Id
591: and person_id = X_Person_Id

Line 644: from as_accesses_all

640: X_Acc_Id NUMBER;
641: BEGIN
642: select access_id
643: into X_Acc_Id
644: from as_accesses_all
645: where customer_id = X_Customer_Id
646: -- and address_id = X_Address_Id
647: and salesforce_id = X_Salesforce_Id
648: and partner_customer_id = X_Partner_Customer_Id