APPS.IGP_AD_USERID_PKG dependencies on IGP_AC_ACC_CLASSES

Line 71: l_classification_cd igp_ac_acc_classes.acc_classification_code%TYPE;

67: l_person_name hz_parties.party_name%TYPE;
68: l_org hz_parties.party_name%TYPE;
69: l_approver_email fnd_user.email_address%TYPE;
70: l_item_key wf_items.item_key%TYPE;
71: l_classification_cd igp_ac_acc_classes.acc_classification_code%TYPE;
72: l_expiration_dt DATE;
73: l_requestor VARCHAR2(240);
74: l_approver VARCHAR2(240);
75: l_val VARCHAR2(240);

Line 336: igp_ac_acc_classes acc

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;
340:

Line 342: l_acc_type igp_ac_acc_classes.acc_classification_code%TYPE;

338: acc.acc_classification_code=cp_acc_type AND
339: ac.account_id=acc.account_id;
340:
341: l_user_id fnd_user.user_id%TYPE;
342: l_acc_type igp_ac_acc_classes.acc_classification_code%TYPE;
343: l_exists VARCHAR2(1);
344:
345: BEGIN
346: IF (funcmode = 'RUN') THEN

Line 549: l_classification_cd igp_ac_acc_classes.acc_classification_code%TYPE;

545: l_return_status VARCHAR2(1);
546: l_msg_count NUMBER;
547: l_msg_data VARCHAR2(2000);
548: l_user_password VARCHAR2(100);
549: l_classification_cd igp_ac_acc_classes.acc_classification_code%TYPE;
550: l_expiration_dt DATE;
551: l_resp_exists VARCHAR2(1);
552:
553: BEGIN

Line 666: l_classification_cd igp_ac_acc_classes.acc_classification_code%TYPE;

662: l_user_name fnd_user.user_name%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);

Line 672: l_acc_classification_id igp_ac_acc_classes.acc_classification_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);
672: l_acc_classification_id igp_ac_acc_classes.acc_classification_id%TYPE;
673: l_fnd_resp_end_dt DATE;
674: c_get_resp_rec c_get_resp%ROWTYPE;
675: c_chk_resp_rec c_chk_resp%ROWTYPE;
676:

Line 796: -- Insert a record in IGP_AC_ACC_CLASSES table.

792: description =>l_desc -- Description.
793: );
794: END IF;
795: END LOOP;
796: -- Insert a record in IGP_AC_ACC_CLASSES table.
797: l_account_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'P_ACCOUNT_ID');
798:
799: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
800: fnd_log.string(fnd_log.level_procedure,'igs.plsql.igp_ad_userid_pkg.create_port_account','Account ID :'||l_account_id);

Line 805: igp_ac_acc_classes_pkg.insert_row ( x_mode => 'R',

801: END IF;
802:
803: lv_rowid:=NULL;
804: BEGIN
805: igp_ac_acc_classes_pkg.insert_row ( x_mode => 'R',
806: x_rowid => lv_rowid,
807: x_acc_classification_id => l_acc_classification_id, -- PK of the table. OUT param.
808: x_account_id => l_account_id , -- FK to the account ID.
809: x_acc_classification_code => l_classification_cd, -- Acc classification code.

Line 871: l_classcode igp_ac_acc_classes.acc_classification_code%TYPE;

867:
868:
869: l_account_id NUMBER;
870: l_user_id fnd_user.user_id%TYPE;
871: l_classcode igp_ac_acc_classes.acc_classification_code%TYPE;
872: l_expiry_dt DATE;
873: l_user_name fnd_user.user_name%TYPE;
874: c_get_per_details_rec c_get_per_details%ROWTYPE;
875: l_requestor_id hz_parties.party_id%TYPE;