APPS.IGC_CC_OPN_UPD_GET_LNK_PUB dependencies on FND_LOOKUPS

Line 2037: p_action_code IN fnd_lookups.lookup_code%TYPE,

2033: p_validation_level IN NUMBER,
2034: p_cc_num IN igc_cc_headers.cc_num%TYPE,
2035: p_set_of_books_id IN igc_cc_headers.set_of_books_id%TYPE,
2036: p_org_id IN igc_cc_headers.org_id%TYPE,
2037: p_action_code IN fnd_lookups.lookup_code%TYPE,
2038: p_last_updated_by IN igc_cc_headers.last_updated_by%TYPE,
2039: p_last_update_login IN igc_cc_headers.last_update_login%TYPE,
2040: x_return_status OUT NOCOPY VARCHAR2,
2041: x_msg_count OUT NOCOPY NUMBER,

Line 2062: l_action_type_code fnd_lookups.lookup_code%TYPE;

2058: l_new_ctrl_status igc_cc_headers.cc_ctrl_status%TYPE;
2059: l_new_apprvl_status igc_cc_headers.cc_apprvl_status%TYPE;
2060: l_prev_ctrl_status igc_cc_headers.cc_ctrl_status%TYPE;
2061: l_prev_apprvl_status igc_cc_headers.cc_apprvl_status%TYPE;
2062: l_action_type_code fnd_lookups.lookup_code%TYPE;
2063: l_action_meaning fnd_lookups.meaning%TYPE;
2064: l_control_meaning fnd_lookups.meaning%TYPE;
2065: l_seq VARCHAR2(40);
2066: l_itemkey igc_cc_headers.wf_item_key%TYPE;

Line 2063: l_action_meaning fnd_lookups.meaning%TYPE;

2059: l_new_apprvl_status igc_cc_headers.cc_apprvl_status%TYPE;
2060: l_prev_ctrl_status igc_cc_headers.cc_ctrl_status%TYPE;
2061: l_prev_apprvl_status igc_cc_headers.cc_apprvl_status%TYPE;
2062: l_action_type_code fnd_lookups.lookup_code%TYPE;
2063: l_action_meaning fnd_lookups.meaning%TYPE;
2064: l_control_meaning fnd_lookups.meaning%TYPE;
2065: l_seq VARCHAR2(40);
2066: l_itemkey igc_cc_headers.wf_item_key%TYPE;
2067: l_itemtype igc_cc_headers.wf_item_type%TYPE;

Line 2064: l_control_meaning fnd_lookups.meaning%TYPE;

2060: l_prev_ctrl_status igc_cc_headers.cc_ctrl_status%TYPE;
2061: l_prev_apprvl_status igc_cc_headers.cc_apprvl_status%TYPE;
2062: l_action_type_code fnd_lookups.lookup_code%TYPE;
2063: l_action_meaning fnd_lookups.meaning%TYPE;
2064: l_control_meaning fnd_lookups.meaning%TYPE;
2065: l_seq VARCHAR2(40);
2066: l_itemkey igc_cc_headers.wf_item_key%TYPE;
2067: l_itemtype igc_cc_headers.wf_item_type%TYPE;
2068: l_row_id VARCHAR2(18);

Line 2315: FROM fnd_lookups lkup

2311: SELECT lkup.lookup_code,
2312: lkup.meaning
2313: INTO l_action_type_code,
2314: l_action_meaning
2315: FROM fnd_lookups lkup
2316: WHERE lkup.lookup_type = 'IGC_CC_ACTION_TYPE'
2317: AND lkup.lookup_code = p_action_code
2318: AND lkup.lookup_code IN ('OP','CL','OH','RH');
2319:

Line 2445: FROM fnd_lookups lkup

2441: SELECT lkup.lookup_code,
2442: lkup.meaning
2443: INTO l_action_type_code,
2444: l_control_meaning
2445: FROM fnd_lookups lkup
2446: WHERE lkup.lookup_type = 'IGC_CC_CONTROL_STATUS'
2447: AND lkup.lookup_code = l_cc_header_rec.cc_ctrl_status;
2448:
2449: EXCEPTION