APPS.IGP_AD_USERID_PKG dependencies on IGP_AC_ACCOUNTS

Line 335: FROM igp_ac_accounts ac,

331: -- Get the details of
332: CURSOR c_exists_acc(cp_acc_type VARCHAR2,cp_user_id fnd_user.user_id%TYPE)
333: IS
334: SELECT 'Y'
335: FROM igp_ac_accounts ac,
336: igp_ac_acc_classes acc
337: WHERE ac.user_id=cp_user_id AND
338: acc.acc_classification_code=cp_acc_type AND
339: ac.account_id=acc.account_id;

Line 647: FROM igp_ac_accounts a

643:
644: -- Get the details of portfolio user.
645: CURSOR c_is_port_user(cp_party_id VARCHAR2) IS
646: SELECT account_id
647: FROM igp_ac_accounts a
648: WHERE party_id=cp_party_id;
649:
650: CURSOR c_get_user_id(cp_user_name VARCHAR2) IS
651: SELECT user_id

Line 667: l_account_id igp_ac_accounts.account_id%TYPE;

663: l_user_id fnd_user.user_id%TYPE;
664: l_fnd_user_id fnd_user.user_id%TYPE;
665: l_party_id hz_parties.party_id%TYPE;
666: l_classification_cd igp_ac_acc_classes.acc_classification_code%TYPE;
667: l_account_id igp_ac_accounts.account_id%TYPE;
668: l_expiration_dt DATE;
669: l_desc fnd_responsibility_tl.description%TYPE;
670: l_exists VARCHAR2(1);
671: lv_rowid VARCHAR2(30);

Line 698: ELSIF (l_account_id IS NULL) THEN --Call the TBH of the IGP_AC_ACCOUNTS table to insert into the table.

694: END IF;
695:
696: IF (l_account_id IS NOT NULL) THEN
697: wf_engine.SetItemAttrNumber(itemtype,itemkey,'P_ACCOUNT_ID', l_account_id); -- Portfolio a/c exists: Set the value of the account ID in the WF.
698: ELSIF (l_account_id IS NULL) THEN --Call the TBH of the IGP_AC_ACCOUNTS table to insert into the table.
699: BEGIN
700: igp_ac_accounts_pkg.insert_row (
701: x_mode => 'R',
702: x_rowid => lv_rowid, -- OUT param

Line 700: igp_ac_accounts_pkg.insert_row (

696: IF (l_account_id IS NOT NULL) THEN
697: wf_engine.SetItemAttrNumber(itemtype,itemkey,'P_ACCOUNT_ID', l_account_id); -- Portfolio a/c exists: Set the value of the account ID in the WF.
698: ELSIF (l_account_id IS NULL) THEN --Call the TBH of the IGP_AC_ACCOUNTS table to insert into the table.
699: BEGIN
700: igp_ac_accounts_pkg.insert_row (
701: x_mode => 'R',
702: x_rowid => lv_rowid, -- OUT param
703: x_account_id => l_account_id, -- OUT param
704: x_party_id => l_party_id, -- HZ party ID.

Line 847: FROM hz_parties hz,igp_ac_accounts ac

843: resultout OUT NOCOPY VARCHAR2 )
844: IS
845: CURSOR c_get_per_details(cp_user_id NUMBER) IS
846: SELECT hz.party_name,hz.party_number
847: FROM hz_parties hz,igp_ac_accounts ac
848: WHERE ac.user_id=cp_user_id AND
849: ac.party_id=hz.party_id;
850:
851: CURSOR c_get_fnd_user(cp_user_id NUMBER) IS

Line 862: igp_ac_Accounts acc

858: fu.email_address req_email
859: FROM
860: hz_parties hz,
861: fnd_user fu,
862: igp_ac_Accounts acc
863: WHERE
864: hz.party_id=cp_req_id AND
865: hz.party_id=acc.party_id AND
866: acc.user_id=fu.user_id;