DBA Data[Home] [Help]

APPS.OZF_GL_INTERFACE_PVT dependencies on OZF_AE_LINE_PVT

Line 2072: ,x_ae_line_tbl OUT NOCOPY OZF_ae_line_PVT.ae_line_tbl_type

2068: ---------------------------------------------------------------------
2069: PROCEDURE Construct_Line_Rec(
2070: p_gl_rec IN gl_interface_rec_type
2071: ,x_return_status OUT NOCOPY VARCHAR2
2072: ,x_ae_line_tbl OUT NOCOPY OZF_ae_line_PVT.ae_line_tbl_type
2073: ) IS
2074: l_num_dr_lines number := 1;
2075: l_num_cr_lines number := 1;
2076: l_num_lines number := 1;

Line 2111: l_ae_line_tbl OZF_ae_line_PVT.ae_line_tbl_type;

2107: l_acctd_amount number;
2108: l_currency_code varchar2(15);
2109: l_line_type_code varchar2(30);
2110:
2111: l_ae_line_tbl OZF_ae_line_PVT.ae_line_tbl_type;
2112: l_rec_num number;
2113:
2114: BEGIN
2115: -- get line amounts for credit and debit lines

Line 2153: x_ae_line_tbl := OZF_ae_line_PVT.ae_line_tbl_type();

2149: l_fxgl_loss_ccid := l_fxgl_gain_ccid;
2150: END IF;
2151:
2152: -- ae lines
2153: x_ae_line_tbl := OZF_ae_line_PVT.ae_line_tbl_type();
2154: l_num_lines := l_amount_tbl.count;
2155: IF OZF_DEBUG_HIGH_ON THEN
2156: OZF_UTILITY_PVT.debug_message('Number of Lines: ' || l_num_lines);
2157: END IF;

Line 2323: ,x_ae_line_tbl OUT NOCOPY OZF_ae_line_PVT.ae_line_tbl_type )

2319: ,p_gl_rec IN gl_interface_rec_type
2320: ,p_acctng_entries IN varchar2
2321: ,x_accounting_event_rec OUT NOCOPY OZF_acctng_events_PVT.acctng_event_rec_type
2322: ,x_ae_header_rec OUT NOCOPY OZF_ae_header_PVT.ae_header_rec_type
2323: ,x_ae_line_tbl OUT NOCOPY OZF_ae_line_PVT.ae_line_tbl_type )
2324: IS
2325: l_api_name CONSTANT VARCHAR2(30) := 'Set_Accounting_Rule';
2326: l_api_version CONSTANT NUMBER := 1.0;
2327: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME ||'.'|| l_api_name;

Line 2466: l_ae_line_tbl OZF_ae_line_PVT.ae_line_tbl_type;

2462: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME ||'.'|| l_api_name;
2463: --
2464: l_acctng_event_rec OZF_acctng_events_PVT.acctng_event_rec_type;
2465: l_ae_header_rec OZF_ae_header_PVT.ae_header_rec_type;
2466: l_ae_line_tbl OZF_ae_line_PVT.ae_line_tbl_type;
2467:
2468: l_accounting_event_id number;
2469: l_ae_header_id number;
2470: l_ae_line_id_tbl OZF_ae_line_PVT.number_tbl_type;

Line 2470: l_ae_line_id_tbl OZF_ae_line_PVT.number_tbl_type;

2466: l_ae_line_tbl OZF_ae_line_PVT.ae_line_tbl_type;
2467:
2468: l_accounting_event_id number;
2469: l_ae_header_id number;
2470: l_ae_line_id_tbl OZF_ae_line_PVT.number_tbl_type;
2471: --
2472: l_post_to_gl varchar2(1);
2473: l_transfer_to_gl_in varchar2(1);
2474: l_off_inv_gl varchar2(1);

Line 2696: OZF_ae_line_PVT.Create_ae_line(

2692: l_ae_line_tbl(i).ae_line_number);
2693: END IF;
2694: END LOOP;
2695:
2696: OZF_ae_line_PVT.Create_ae_line(
2697: P_Api_Version_Number => 1.0,
2698: P_Init_Msg_List => FND_API.G_FALSE,
2699: P_Commit => FND_API.G_FALSE,
2700: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,

Line 2807: l_ae_line_tbl OZF_ae_line_PVT.ae_line_tbl_type;

2803: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME ||'.'|| l_api_name;
2804: --
2805: l_acctng_event_rec OZF_acctng_events_PVT.acctng_event_rec_type;
2806: l_ae_header_rec OZF_ae_header_PVT.ae_header_rec_type;
2807: l_ae_line_tbl OZF_ae_line_PVT.ae_line_tbl_type;
2808:
2809: l_accounting_event_id number := p_event_id;
2810: l_ae_header_id number;
2811: l_ae_line_id_tbl OZF_ae_line_PVT.number_tbl_type;

Line 2811: l_ae_line_id_tbl OZF_ae_line_PVT.number_tbl_type;

2807: l_ae_line_tbl OZF_ae_line_PVT.ae_line_tbl_type;
2808:
2809: l_accounting_event_id number := p_event_id;
2810: l_ae_header_id number;
2811: l_ae_line_id_tbl OZF_ae_line_PVT.number_tbl_type;
2812: --
2813: l_acctng_entries varchar2(3);
2814: l_event_status_code varchar2(30);
2815:

Line 2912: OZF_ae_line_PVT.Create_ae_line(

2908: l_ae_line_tbl(i).ae_line_number);
2909: END IF;
2910: END LOOP;
2911:
2912: OZF_ae_line_PVT.Create_ae_line(
2913: P_Api_Version_Number => 1.0,
2914: P_Init_Msg_List => FND_API.G_FALSE,
2915: P_Commit => FND_API.G_FALSE,
2916: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,

Line 3022: l_ae_line_tbl OZF_AE_LINE_PVT.ae_line_tbl_type;

3018: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME ||'.'|| l_api_name;
3019:
3020: l_acctng_event_rec OZF_ACCTNG_EVENTS_PVT.acctng_event_rec_type;
3021: l_ae_header_rec OZF_AE_HEADER_PVT.ae_header_rec_type;
3022: l_ae_line_tbl OZF_AE_LINE_PVT.ae_line_tbl_type;
3023:
3024: l_new_event_id NUMBER;
3025: l_new_header_id NUMBER;
3026: l_new_line_id_tbl OZF_AE_LINE_PVT.number_tbl_type;

Line 3026: l_new_line_id_tbl OZF_AE_LINE_PVT.number_tbl_type;

3022: l_ae_line_tbl OZF_AE_LINE_PVT.ae_line_tbl_type;
3023:
3024: l_new_event_id NUMBER;
3025: l_new_header_id NUMBER;
3026: l_new_line_id_tbl OZF_AE_LINE_PVT.number_tbl_type;
3027:
3028: l_ae_header_id NUMBER;
3029: l_aeh_object_version_num NUMBER;
3030: l_gl_transfer_yn VARCHAR2(1);

Line 3274: l_ae_line_tbl := OZF_ae_line_PVT.ae_line_tbl_type();

3270:
3271: -- Create new lines for the reverse entries, by switching credit/debit amounts
3272: k := 1;
3273: l_ae_line_tbl := null;
3274: l_ae_line_tbl := OZF_ae_line_PVT.ae_line_tbl_type();
3275:
3276: OPEN get_ae_lines_dtl_csr( l_ae_header_id );
3277: LOOP
3278: FETCH get_ae_lines_dtl_csr INTO l_accounted_cr

Line 3319: OZF_ae_line_PVT.Create_ae_line(

3315: k := k + 1;
3316: END LOOP;
3317: CLOSE get_ae_lines_dtl_csr;
3318:
3319: OZF_ae_line_PVT.Create_ae_line(
3320: P_Api_Version_Number => 1.0,
3321: P_Init_Msg_List => FND_API.G_FALSE,
3322: P_Commit => FND_API.G_FALSE,
3323: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,

Line 3360: OZF_AE_LINE_PVT.Delete_Ae_Line(

3356: OZF_UTILITY_PVT.debug_message('Delting SLA line, line_id:' || l_ae_line_id);
3357: END IF;
3358:
3359: -- Delete SLA lines not transferred
3360: OZF_AE_LINE_PVT.Delete_Ae_Line(
3361: p_api_version_number => 1.0,
3362: p_init_msg_list => FND_API.G_FALSE,
3363: p_commit => FND_API.G_FALSE,
3364: p_validation_level => FND_API.G_VALID_LEVEL_FULL,