56: -- Note: Project and task are always required in the denorm table
57:
58: IF x_exp_type IS NOT NULL THEN
59:
60: x_created_by := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
61: x_last_updated_by := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
62: x_last_update_login := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
63: x_creation_date := SYSDATE;
64: x_last_update_date := SYSDATE;
57:
58: IF x_exp_type IS NOT NULL THEN
59:
60: x_created_by := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
61: x_last_updated_by := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
62: x_last_update_login := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
63: x_creation_date := SYSDATE;
64: x_last_update_date := SYSDATE;
65:
58: IF x_exp_type IS NOT NULL THEN
59:
60: x_created_by := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
61: x_last_updated_by := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
62: x_last_update_login := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
63: x_creation_date := SYSDATE;
64: x_last_update_date := SYSDATE;
65:
66: INSERT INTO PA_EXPENDITURE_HISTORY
134:
135: END Insert_Audit_Rec;
136:
137: BEGIN
138: x_profile_audit_flag := FND_PROFILE.VALUE('PA_ONLINE_EXP_AUDIT');
139: IF NVL(x_profile_audit_flag,'N') = 'Y' THEN
140: SELECT EXPENDITURE_CLASS_CODE,
141: PTE_REFERENCE,
142: INCURRED_BY_PERSON_ID,