eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PSP_ADJ_DRIVER dependencies on PSP_CLEARING_ACCOUNT

Line 4044: ----------P R O C E D U R E: INSERT_PSP_CLEARING_ACCOUNT-------------------------------

4040: retcode := 2;
4041:
4042: end generate_lines;
4043:
4044: ----------P R O C E D U R E: INSERT_PSP_CLEARING_ACCOUNT-------------------------------
4045: --
4046: --
4047: -- Purpose: This procedure is called by distribution transfers clearing account
4048: -- creation form. The purpose is to create a clearing account

Line 4054: PROCEDURE insert_psp_clearing_account(errbuf OUT NOCOPY VARCHAR2,

4050: -- to post GL balances to when an original GL account line is
4051: -- transfered to a Project account.
4052: ------------------------------------------------------------------------------------
4053:
4054: PROCEDURE insert_psp_clearing_account(errbuf OUT NOCOPY VARCHAR2,
4055: retcode OUT NOCOPY VARCHAR2,
4056: p_reversing_gl_ccid IN NUMBER,
4057: p_comments IN VARCHAR2,
4058: p_business_group_id IN NUMBER,

Line 4067: from psp_clearing_account

4063: v_count number;
4064: account_exists Exception;
4065: cursor c_existing is
4066: select count(*)
4067: from psp_clearing_account
4068: where BUSINESS_GROUP_ID = p_business_group_id
4069: AND SET_OF_BOOKS_ID = p_set_of_books_id
4070: AND PAYROLL_ID = p_payroll_id;
4071: begin

Line 4080: insert into psp_clearing_account(reversing_gl_ccid,

4076: raise account_exists;
4077: end if;
4078: close c_existing;
4079:
4080: insert into psp_clearing_account(reversing_gl_ccid,
4081: comments,
4082: business_group_id,
4083: set_of_books_id,
4084: LAST_UPDATE_DATE,

Line 4105: errbuf:= 'PSP_ADJ_DRIVER : INSERT_PSP_CLEARING_ACCOUNT' || sqlerrm;

4101: EXCEPTION
4102: WHEN account_exists THEN
4103: retcode := 2;
4104: WHEN OTHERS THEN
4105: errbuf:= 'PSP_ADJ_DRIVER : INSERT_PSP_CLEARING_ACCOUNT' || sqlerrm;
4106: retcode := -1;
4107: end insert_psp_clearing_account;
4108: -----------------------------------------------------------------------------------
4109:

Line 4107: end insert_psp_clearing_account;

4103: retcode := 2;
4104: WHEN OTHERS THEN
4105: errbuf:= 'PSP_ADJ_DRIVER : INSERT_PSP_CLEARING_ACCOUNT' || sqlerrm;
4106: retcode := -1;
4107: end insert_psp_clearing_account;
4108: -----------------------------------------------------------------------------------
4109:
4110: -----------------------------UPDATE Clearing Account-------------------------------
4111: PROCEDURE update_psp_clearing_account(errbuf OUT NOCOPY VARCHAR2,

Line 4111: PROCEDURE update_psp_clearing_account(errbuf OUT NOCOPY VARCHAR2,

4107: end insert_psp_clearing_account;
4108: -----------------------------------------------------------------------------------
4109:
4110: -----------------------------UPDATE Clearing Account-------------------------------
4111: PROCEDURE update_psp_clearing_account(errbuf OUT NOCOPY VARCHAR2,
4112: retcode OUT NOCOPY VARCHAR2,
4113: p_reversing_gl_ccid IN NUMBER,
4114: p_comments IN VARCHAR2,
4115: p_business_group_id IN NUMBER,

Line 4122: update psp_clearing_account

4118: p_rowid IN VARCHAR2) IS
4119:
4120: begin
4121:
4122: update psp_clearing_account
4123: set reversing_gl_ccid = p_reversing_gl_ccid,
4124: comments = p_comments,
4125: business_group_id = p_business_group_id,
4126: set_of_books_id = p_set_of_books_id,

Line 4137: errbuf:= 'PSP_ADJ_DRIVER : UPDATE_PSP_CLEARING_ACCOUNT' || sqlerrm;

4133: AND rowid = p_rowid;
4134:
4135: EXCEPTION
4136: WHEN OTHERS THEN
4137: errbuf:= 'PSP_ADJ_DRIVER : UPDATE_PSP_CLEARING_ACCOUNT' || sqlerrm;
4138: retcode := -1;
4139:
4140: end update_psp_clearing_account;
4141: ------------------------------------------------------------------------------------

Line 4140: end update_psp_clearing_account;

4136: WHEN OTHERS THEN
4137: errbuf:= 'PSP_ADJ_DRIVER : UPDATE_PSP_CLEARING_ACCOUNT' || sqlerrm;
4138: retcode := -1;
4139:
4140: end update_psp_clearing_account;
4141: ------------------------------------------------------------------------------------
4142:
4143: -----------------------------DELETE Clearing Account--------------------------------
4144: PROCEDURE delete_psp_clearing_account(errbuf OUT NOCOPY VARCHAR2,

Line 4144: PROCEDURE delete_psp_clearing_account(errbuf OUT NOCOPY VARCHAR2,

4140: end update_psp_clearing_account;
4141: ------------------------------------------------------------------------------------
4142:
4143: -----------------------------DELETE Clearing Account--------------------------------
4144: PROCEDURE delete_psp_clearing_account(errbuf OUT NOCOPY VARCHAR2,
4145: retcode OUT NOCOPY VARCHAR2,
4146: p_reversing_gl_ccid IN NUMBER,
4147: p_business_group_id IN NUMBER,
4148: p_set_of_books_id IN NUMBER,

Line 4154: delete from psp_clearing_account

4150:
4151:
4152: begin
4153:
4154: delete from psp_clearing_account
4155: where business_group_id = p_business_group_id
4156: and set_of_books_id = p_set_of_books_id
4157: and rowid = p_rowid;
4158:

Line 4161: errbuf:= 'PSP_ADJ_DRIVER : DELETE_PSP_CLEARING_ACCOUNT' || sqlerrm;

4157: and rowid = p_rowid;
4158:
4159: EXCEPTION
4160: WHEN OTHERS THEN
4161: errbuf:= 'PSP_ADJ_DRIVER : DELETE_PSP_CLEARING_ACCOUNT' || sqlerrm;
4162: retcode := -1;
4163:
4164: end delete_psp_clearing_account;
4165: ------------------------------------------------------------------------------------

Line 4164: end delete_psp_clearing_account;

4160: WHEN OTHERS THEN
4161: errbuf:= 'PSP_ADJ_DRIVER : DELETE_PSP_CLEARING_ACCOUNT' || sqlerrm;
4162: retcode := -1;
4163:
4164: end delete_psp_clearing_account;
4165: ------------------------------------------------------------------------------------
4166:
4167: -------------------------------LOCK Clearing Account--------------------------------
4168:

Line 4169: PROCEDURE LOCK_ROW_PSP_CLEARING_ACCOUNT (

4165: ------------------------------------------------------------------------------------
4166:
4167: -------------------------------LOCK Clearing Account--------------------------------
4168:
4169: PROCEDURE LOCK_ROW_PSP_CLEARING_ACCOUNT (
4170: P_BUSINESS_GROUP_ID IN NUMBER,
4171: P_SET_OF_BOOKS_ID IN NUMBER,
4172: P_REVERSING_GL_CCID IN NUMBER,
4173: P_COMMENTS IN VARCHAR2,

Line 4182: from PSP_CLEARING_ACCOUNT

4178: SET_OF_BOOKS_ID,
4179: REVERSING_GL_CCID,
4180: COMMENTS,
4181: PAYROLL_ID
4182: from PSP_CLEARING_ACCOUNT
4183: where business_group_id = p_business_group_id
4184: and set_of_books_id = p_set_of_books_id
4185: and payroll_id = p_payroll_id
4186: and reversing_gl_ccid = p_reversing_gl_ccid

Line 4214: END LOCK_ROW_PSP_CLEARING_ACCOUNT;

4210: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
4211: app_exception.raise_exception;
4212: end if;
4213: return;
4214: END LOCK_ROW_PSP_CLEARING_ACCOUNT;
4215: ------------------------------------------------------------------------------------
4216:
4217: PROCEDURE undo_adjustment(p_batch_name IN VARCHAR2,
4218: p_business_group_id IN number,