APPS.IGF_AW_COA_GEN dependencies on IGF_AW_ITEM

Line 198: p_item_code igf_aw_item.item_code%TYPE DEFAULT NULL,

194: END award_amount;
195:
196: FUNCTION isCoaLocked(
197: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
198: p_item_code igf_aw_item.item_code%TYPE DEFAULT NULL,
199: p_ld_cal_type igs_ca_inst.cal_type%TYPE DEFAULT NULL,
200: p_ld_sequence_number igs_ca_inst.sequence_number%TYPE DEFAULT NULL
201: ) RETURN BOOLEAN AS
202: ------------------------------------------------------------------

Line 218: cp_item_code igf_aw_item.item_code%TYPE,

214:
215: -- Get item/term level lock
216: CURSOR c_item_term(
217: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
218: cp_item_code igf_aw_item.item_code%TYPE,
219: cp_ld_cal_type igs_ca_inst.cal_type%TYPE,
220: cp_ld_sequence_number igs_ca_inst.sequence_number%TYPE
221: ) IS
222: SELECT NVL(lock_flag,'N') lock_flag

Line 233: cp_item_code igf_aw_item.item_code%TYPE

229:
230: -- Get item level lock
231: CURSOR c_item(
232: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
233: cp_item_code igf_aw_item.item_code%TYPE
234: ) IS
235: SELECT NVL(lock_flag,'N') lock_flag
236: FROM igf_aw_coa_items
237: WHERE base_id = cp_base_id

Line 342: p_item_code igf_aw_item.item_code%TYPE DEFAULT NULL,

338:
339: PROCEDURE updateLock(
340: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
341: p_mode VARCHAR2,
342: p_item_code igf_aw_item.item_code%TYPE DEFAULT NULL,
343: p_ld_cal_type igs_ca_inst.cal_type%TYPE DEFAULT NULL,
344: p_ld_sequence_number igs_ca_inst.sequence_number%TYPE DEFAULT NULL
345: );
346:

Line 349: p_item_code igf_aw_item.item_code%TYPE DEFAULT NULL,

345: );
346:
347: PROCEDURE doLockInternal(
348: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
349: p_item_code igf_aw_item.item_code%TYPE DEFAULT NULL,
350: p_ld_cal_type igs_ca_inst.cal_type%TYPE DEFAULT NULL,
351: p_ld_sequence_number igs_ca_inst.sequence_number%TYPE DEFAULT NULL
352: ) AS
353: ------------------------------------------------------------------

Line 380: p_item_code igf_aw_item.item_code%TYPE DEFAULT NULL,

376: END doLockInternal;
377:
378: PROCEDURE doUnlockInternal(
379: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
380: p_item_code igf_aw_item.item_code%TYPE DEFAULT NULL,
381: p_ld_cal_type igs_ca_inst.cal_type%TYPE DEFAULT NULL,
382: p_ld_sequence_number igs_ca_inst.sequence_number%TYPE DEFAULT NULL
383: ) AS
384: ------------------------------------------------------------------

Line 412: p_item_code igf_aw_item.item_code%TYPE DEFAULT NULL,

408:
409: PROCEDURE updateLock(
410: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
411: p_mode VARCHAR2,
412: p_item_code igf_aw_item.item_code%TYPE DEFAULT NULL,
413: p_ld_cal_type igs_ca_inst.cal_type%TYPE DEFAULT NULL,
414: p_ld_sequence_number igs_ca_inst.sequence_number%TYPE DEFAULT NULL
415: ) AS
416: ------------------------------------------------------------------

Line 431: cp_item_code igf_aw_item.item_code%TYPE,

427: -------------------------------------------------------------------
428:
429: CURSOR c_item_term(
430: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
431: cp_item_code igf_aw_item.item_code%TYPE,
432: cp_ld_cal_type igs_ca_inst.cal_type%TYPE,
433: cp_ld_sequence_number igs_ca_inst.sequence_number%TYPE
434: ) IS
435: SELECT terms.rowid row_id,

Line 446: cp_item_code igf_aw_item.item_code%TYPE

442: l_item_term c_item_term%ROWTYPE;
443:
444: CURSOR c_item(
445: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
446: cp_item_code igf_aw_item.item_code%TYPE
447: ) IS
448: SELECT items.rowid row_id,
449: items.*
450: FROM igf_aw_coa_items items

Line 466: cp_item_code igf_aw_item.item_code%TYPE

462: l_base c_base%ROWTYPE;
463:
464: CURSOR c_terms(
465: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
466: cp_item_code igf_aw_item.item_code%TYPE
467: ) IS
468: SELECT terms.ld_cal_type,
469: terms.ld_sequence_number
470: FROM igf_aw_coa_itm_terms terms

Line 952: p_item_code igf_aw_item.item_code%TYPE DEFAULT NULL,

948: END updateLock;
949:
950: FUNCTION doLock(
951: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
952: p_item_code igf_aw_item.item_code%TYPE DEFAULT NULL,
953: p_ld_cal_type igs_ca_inst.cal_type%TYPE DEFAULT NULL,
954: p_ld_sequence_number igs_ca_inst.sequence_number%TYPE DEFAULT NULL
955: ) RETURN VARCHAR2 AS
956: ------------------------------------------------------------------

Line 994: p_item_code igf_aw_item.item_code%TYPE DEFAULT NULL,

990: END doLock;
991:
992: FUNCTION doUnlock(
993: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
994: p_item_code igf_aw_item.item_code%TYPE DEFAULT NULL,
995: p_ld_cal_type igs_ca_inst.cal_type%TYPE DEFAULT NULL,
996: p_ld_sequence_number igs_ca_inst.sequence_number%TYPE DEFAULT NULL
997: ) RETURN VARCHAR2 AS
998: ------------------------------------------------------------------