DBA Data[Home] [Help]

APPS.IGC_CC_OPN_UPD_GET_LNK_PUB dependencies on IGC_CC_HEADERS_S

Line 40: p_current_sob_id IN igc_cc_headers.set_of_books_id%TYPE,

36: --
37: PROCEDURE CC_OPEN_API_VALIDATE (
38: p_cc_header_rec IN OUT NOCOPY CC_HEADER_REC_TYPE,
39: p_current_org_id IN igc_cc_headers.org_id%TYPE,
40: p_current_sob_id IN igc_cc_headers.set_of_books_id%TYPE,
41: p_func_currency_code IN igc_cc_headers.currency_code%TYPE,
42: x_valid_cc OUT NOCOPY VARCHAR2,
43: x_currency_code OUT NOCOPY igc_cc_headers.currency_code%TYPE,
44: x_conversion_type OUT NOCOPY igc_cc_headers.conversion_type%TYPE,

Line 408: p_current_sob_id IN igc_cc_headers.set_of_books_id%TYPE,

404:
405: PROCEDURE CC_OPEN_API_VALIDATE (
406: p_cc_header_rec IN OUT NOCOPY CC_HEADER_REC_TYPE,
407: p_current_org_id IN igc_cc_headers.org_id%TYPE,
408: p_current_sob_id IN igc_cc_headers.set_of_books_id%TYPE,
409: p_func_currency_code IN igc_cc_headers.currency_code%TYPE,
410: x_valid_cc OUT NOCOPY VARCHAR2,
411: x_currency_code OUT NOCOPY igc_cc_headers.currency_code%TYPE,
412: x_conversion_type OUT NOCOPY igc_cc_headers.conversion_type%TYPE,

Line 452: l_sob_id igc_cc_headers.set_of_books_id%TYPE;

448: l_cc_num_method igc_cc_system_options_all.cc_num_method%TYPE;
449: l_cc_num_datatype igc_cc_system_options_all.cc_num_datatype%TYPE;
450: l_cc_num_created NUMBER;
451: l_org_name hr_organization_units.name%TYPE;
452: l_sob_id igc_cc_headers.set_of_books_id%TYPE;
453: l_cc_num igc_cc_headers.cc_num%TYPE;
454: l_name hr_all_organization_units.name%TYPE;
455: l_full_path VARCHAR(500);
456:

Line 2000: SELECT igc_cc_headers_s.nextval

1996: l_api_name := 'CC_Open_API_Derive';
1997:
1998: x_header_id := NULL;
1999: l_full_path := g_path||'cc_open_api_derive';
2000: SELECT igc_cc_headers_s.nextval
2001: INTO x_header_id
2002: FROM DUAL;
2003:
2004: -- --------------------------------------------------------------------

Line 2035: p_set_of_books_id IN igc_cc_headers.set_of_books_id%TYPE,

2031: p_init_msg_list IN VARCHAR2,
2032: p_commit IN VARCHAR2,
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,

Line 3201: p_set_of_books_id IN igc_cc_headers.set_of_books_id%TYPE,

3197: p_commit IN VARCHAR2,
3198: p_validation_level IN NUMBER,
3199: p_cc_num IN igc_cc_headers.cc_num%TYPE,
3200: p_org_id IN igc_cc_headers.org_id%TYPE,
3201: p_set_of_books_id IN igc_cc_headers.set_of_books_id%TYPE,
3202: x_cc_header_id OUT NOCOPY igc_cc_headers.cc_header_id%TYPE,
3203: x_cc_ref_num OUT NOCOPY igc_cc_headers.cc_ref_num%TYPE,
3204: x_return_status OUT NOCOPY VARCHAR2,
3205: x_msg_count OUT NOCOPY NUMBER,

Line 3378: p_set_of_books_id IN igc_cc_headers.set_of_books_id%TYPE,

3374: p_commit IN VARCHAR2,
3375: p_validation_level IN NUMBER ,
3376: p_cc_ref_num IN igc_cc_headers.cc_ref_num%TYPE,
3377: p_org_id IN igc_cc_headers.org_id%TYPE,
3378: p_set_of_books_id IN igc_cc_headers.set_of_books_id%TYPE,
3379: p_cc_num IN igc_cc_headers.cc_num%TYPE,
3380: x_return_status OUT NOCOPY VARCHAR2,
3381: x_msg_count OUT NOCOPY NUMBER,
3382: x_msg_data OUT NOCOPY VARCHAR2