[Home] [Help]
1023:
1024: -----------------------------------------------------------
1025: -- Validation Logic:
1026: -- The charge_account_id can not be null.
1027: -- If it is not null, it must be a valid id in gl_code_combinations.
1028: -----------------------------------------------------------
1029: PROCEDURE charge_account_id(
1030: p_id_tbl IN po_tbl_number,
1031: p_charge_account_id_tbl IN po_tbl_number,
1074: WHERE (p_charge_account_id_tbl(i) IS NULL OR
1075: (p_charge_account_id_tbl(i) IS NOT NULL AND
1076: NOT EXISTS(
1077: SELECT NULL
1078: FROM gl_code_combinations gcc
1079: WHERE gcc.code_combination_id = p_charge_account_id_tbl(i)
1080: AND gcc.enabled_flag = 'Y'
1081: AND TRUNC(NVL(p_gl_date_tbl(i), SYSDATE)) BETWEEN TRUNC(NVL(start_date_active,
1082: NVL(p_gl_date_tbl(i), SYSDATE)))
1107: -----------------------------------------------------------
1108: -- Validation Logic:
1109: -- 1. If po_encumbrance_flag is Y, and destination_type_code is not 'SHOP FLOOR',
1110: -- the budget_account_id can not be null.
1111: -- 2. If the account_id is not null, it must be a valid id in gl_code_combinations.
1112: -----------------------------------------------------------
1113: PROCEDURE budget_account_id(
1114: p_id_tbl IN po_tbl_number,
1115: p_budget_account_id_tbl IN po_tbl_number,
1175: AND p_budget_account_id_tbl(i) IS NULL)
1176: OR ( p_budget_account_id_tbl(i) IS NOT NULL
1177: AND NOT EXISTS(
1178: SELECT NULL
1179: FROM gl_code_combinations gcc
1180: WHERE gcc.code_combination_id = p_budget_account_id_tbl(i)
1181: AND gcc.enabled_flag = 'Y'
1182: AND TRUNC(NVL(p_gl_date_tbl(i), SYSDATE)) BETWEEN TRUNC(NVL(start_date_active,
1183: NVL(p_gl_date_tbl(i), SYSDATE)))
1206: END budget_account_id;
1207:
1208: ----------------------------------------------------------------------------------
1209: -- Validation Logic:
1210: -- If the account_id is not null, it must be a valid id in gl_code_combinations.
1211: -- Used to validate accrual account id and variance account id.
1212: ----------------------------------------------------------------------------------
1213: PROCEDURE account_id(
1214: p_id_tbl IN po_tbl_number,
1263: FROM DUAL
1264: WHERE p_account_id_tbl(i) IS NOT NULL
1265: AND NOT EXISTS(
1266: SELECT NULL
1267: FROM gl_code_combinations gcc
1268: WHERE gcc.code_combination_id = p_account_id_tbl(i)
1269: AND gcc.enabled_flag = 'Y'
1270: AND TRUNC(NVL(p_gl_date_tbl(i), SYSDATE)) BETWEEN TRUNC(NVL(start_date_active,
1271: NVL(p_gl_date_tbl(i), SYSDATE)))