APPS.IGF_AP_GEN dependencies on IGF_AP_TD_ITEM_INST_ALL

Line 848: p_item_sequence_number IN igf_ap_td_item_inst_all.item_sequence_number%TYPE,

844: END update_preflend_todo_status;
845:
846: PROCEDURE update_td_status(
847: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
848: p_item_sequence_number IN igf_ap_td_item_inst_all.item_sequence_number%TYPE,
849: p_status IN igf_ap_td_item_inst_all.status%TYPE,
850: p_clprl_id IN igf_sl_cl_pref_lenders.clprl_id%TYPE DEFAULT NULL,
851: p_return_status OUT NOCOPY VARCHAR2
852: ) AS

Line 849: p_status IN igf_ap_td_item_inst_all.status%TYPE,

845:
846: PROCEDURE update_td_status(
847: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
848: p_item_sequence_number IN igf_ap_td_item_inst_all.item_sequence_number%TYPE,
849: p_status IN igf_ap_td_item_inst_all.status%TYPE,
850: p_clprl_id IN igf_sl_cl_pref_lenders.clprl_id%TYPE DEFAULT NULL,
851: p_return_status OUT NOCOPY VARCHAR2
852: ) AS
853: ------------------------------------------------------------------

Line 869: cp_item_sequence_number igf_ap_td_item_inst_all.item_sequence_number%TYPE

865:
866: -- Get the item
867: CURSOR c_inst(
868: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
869: cp_item_sequence_number igf_ap_td_item_inst_all.item_sequence_number%TYPE
870: ) IS
871: SELECT td.ROWID row_id,
872: td.*
873: FROM igf_ap_td_item_inst_all td

Line 873: FROM igf_ap_td_item_inst_all td

869: cp_item_sequence_number igf_ap_td_item_inst_all.item_sequence_number%TYPE
870: ) IS
871: SELECT td.ROWID row_id,
872: td.*
873: FROM igf_ap_td_item_inst_all td
874: WHERE base_id = cp_base_id
875: AND item_sequence_number = cp_item_sequence_number;
876: l_inst c_inst%ROWTYPE;
877:

Line 907: cp_item_sequence_number igf_ap_td_item_inst_all.item_sequence_number%TYPE

903: l_person_number hz_parties.party_number%TYPE;
904:
905: -- Get item description
906: CURSOR c_td_item(
907: cp_item_sequence_number igf_ap_td_item_inst_all.item_sequence_number%TYPE
908: ) IS
909: SELECT description
910: FROM igf_ap_td_item_mst_all
911: WHERE todo_number = cp_item_sequence_number;