eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AK_FLOW2_PVT dependencies on AK_FLOW_PUB

Line 1744: p_flow_pk_tbl IN AK_FLOW_PUB.Flow_PK_Tbl_Type

1740: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1741: p_api_version_number IN NUMBER,
1742: p_return_status OUT NOCOPY VARCHAR2,
1743: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
1744: p_flow_pk_tbl IN AK_FLOW_PUB.Flow_PK_Tbl_Type
1745: := AK_FLOW_PUB.G_MISS_FLOW_PK_TBL,
1746: p_nls_language IN VARCHAR2
1747: ) is
1748: cursor l_get_flow_list_csr (appl_id_parm number) is

Line 1745: := AK_FLOW_PUB.G_MISS_FLOW_PK_TBL,

1741: p_api_version_number IN NUMBER,
1742: p_return_status OUT NOCOPY VARCHAR2,
1743: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
1744: p_flow_pk_tbl IN AK_FLOW_PUB.Flow_PK_Tbl_Type
1745: := AK_FLOW_PUB.G_MISS_FLOW_PK_TBL,
1746: p_nls_language IN VARCHAR2
1747: ) is
1748: cursor l_get_flow_list_csr (appl_id_parm number) is
1749: select flow_application_id, flow_code

Line 1763: l_flow_pk_tbl AK_FLOW_PUB.Flow_PK_Tbl_Type;

1759: l_api_name CONSTANT varchar2(30) := 'Download_Flow';
1760: l_index NUMBER;
1761: l_msg_count NUMBER;
1762: l_msg_data VARCHAR2(2000);
1763: l_flow_pk_tbl AK_FLOW_PUB.Flow_PK_Tbl_Type;
1764: l_region_appl_id NUMBER(15);
1765: l_region_code VARCHAR2(30);
1766: l_region_pk_tbl AK_REGION_PUB.Region_PK_Tbl_Type;
1767: l_return_status varchar2(1);

Line 1983: l_flow_rec AK_FLOW_PUB.Flow_Rec_Type;

1979: l_column varchar2(30);
1980: l_dummy NUMBER;
1981: l_eof_flag VARCHAR2(1);
1982: l_flow_index NUMBER := 0;
1983: l_flow_rec AK_FLOW_PUB.Flow_Rec_Type;
1984: l_flow_tbl AK_FLOW_PUB.Flow_Tbl_Type;
1985: l_index NUMBER;
1986: l_item_index NUMBER := 0;
1987: l_item_rec AK_FLOW_PUB.Page_Region_Item_Rec_Type;

Line 1984: l_flow_tbl AK_FLOW_PUB.Flow_Tbl_Type;

1980: l_dummy NUMBER;
1981: l_eof_flag VARCHAR2(1);
1982: l_flow_index NUMBER := 0;
1983: l_flow_rec AK_FLOW_PUB.Flow_Rec_Type;
1984: l_flow_tbl AK_FLOW_PUB.Flow_Tbl_Type;
1985: l_index NUMBER;
1986: l_item_index NUMBER := 0;
1987: l_item_rec AK_FLOW_PUB.Page_Region_Item_Rec_Type;
1988: l_item_tbl AK_FLOW_PUB.Page_Region_Item_Tbl_Type;

Line 1987: l_item_rec AK_FLOW_PUB.Page_Region_Item_Rec_Type;

1983: l_flow_rec AK_FLOW_PUB.Flow_Rec_Type;
1984: l_flow_tbl AK_FLOW_PUB.Flow_Tbl_Type;
1985: l_index NUMBER;
1986: l_item_index NUMBER := 0;
1987: l_item_rec AK_FLOW_PUB.Page_Region_Item_Rec_Type;
1988: l_item_tbl AK_FLOW_PUB.Page_Region_Item_Tbl_Type;
1989: l_line_num NUMBER;
1990: l_lines_read NUMBER;
1991: l_more_flow BOOLEAN := TRUE;

Line 1988: l_item_tbl AK_FLOW_PUB.Page_Region_Item_Tbl_Type;

1984: l_flow_tbl AK_FLOW_PUB.Flow_Tbl_Type;
1985: l_index NUMBER;
1986: l_item_index NUMBER := 0;
1987: l_item_rec AK_FLOW_PUB.Page_Region_Item_Rec_Type;
1988: l_item_tbl AK_FLOW_PUB.Page_Region_Item_Tbl_Type;
1989: l_line_num NUMBER;
1990: l_lines_read NUMBER;
1991: l_more_flow BOOLEAN := TRUE;
1992: l_msg_count NUMBER;

Line 1995: l_page_rec AK_FLOW_PUB.Page_Rec_Type;

1991: l_more_flow BOOLEAN := TRUE;
1992: l_msg_count NUMBER;
1993: l_msg_data VARCHAR2(2000);
1994: l_page_index NUMBER := 0;
1995: l_page_rec AK_FLOW_PUB.Page_Rec_Type;
1996: l_page_tbl AK_FLOW_PUB.Page_Tbl_Type;
1997: l_region_index NUMBER := 0;
1998: l_region_rec AK_FLOW_PUB.Page_Region_Rec_Type;
1999: l_region_tbl AK_FLOW_PUB.Page_Region_Tbl_Type;

Line 1996: l_page_tbl AK_FLOW_PUB.Page_Tbl_Type;

1992: l_msg_count NUMBER;
1993: l_msg_data VARCHAR2(2000);
1994: l_page_index NUMBER := 0;
1995: l_page_rec AK_FLOW_PUB.Page_Rec_Type;
1996: l_page_tbl AK_FLOW_PUB.Page_Tbl_Type;
1997: l_region_index NUMBER := 0;
1998: l_region_rec AK_FLOW_PUB.Page_Region_Rec_Type;
1999: l_region_tbl AK_FLOW_PUB.Page_Region_Tbl_Type;
2000: l_relation_index NUMBER := 0;

Line 1998: l_region_rec AK_FLOW_PUB.Page_Region_Rec_Type;

1994: l_page_index NUMBER := 0;
1995: l_page_rec AK_FLOW_PUB.Page_Rec_Type;
1996: l_page_tbl AK_FLOW_PUB.Page_Tbl_Type;
1997: l_region_index NUMBER := 0;
1998: l_region_rec AK_FLOW_PUB.Page_Region_Rec_Type;
1999: l_region_tbl AK_FLOW_PUB.Page_Region_Tbl_Type;
2000: l_relation_index NUMBER := 0;
2001: l_relation_rec AK_FLOW_PUB.Region_Relation_Rec_Type;
2002: l_relation_tbl AK_FLOW_PUB.Region_Relation_Tbl_Type;

Line 1999: l_region_tbl AK_FLOW_PUB.Page_Region_Tbl_Type;

1995: l_page_rec AK_FLOW_PUB.Page_Rec_Type;
1996: l_page_tbl AK_FLOW_PUB.Page_Tbl_Type;
1997: l_region_index NUMBER := 0;
1998: l_region_rec AK_FLOW_PUB.Page_Region_Rec_Type;
1999: l_region_tbl AK_FLOW_PUB.Page_Region_Tbl_Type;
2000: l_relation_index NUMBER := 0;
2001: l_relation_rec AK_FLOW_PUB.Region_Relation_Rec_Type;
2002: l_relation_tbl AK_FLOW_PUB.Region_Relation_Tbl_Type;
2003: l_saved_token AK_ON_OBJECTS_PUB.Buffer_Type;

Line 2001: l_relation_rec AK_FLOW_PUB.Region_Relation_Rec_Type;

1997: l_region_index NUMBER := 0;
1998: l_region_rec AK_FLOW_PUB.Page_Region_Rec_Type;
1999: l_region_tbl AK_FLOW_PUB.Page_Region_Tbl_Type;
2000: l_relation_index NUMBER := 0;
2001: l_relation_rec AK_FLOW_PUB.Region_Relation_Rec_Type;
2002: l_relation_tbl AK_FLOW_PUB.Region_Relation_Tbl_Type;
2003: l_saved_token AK_ON_OBJECTS_PUB.Buffer_Type;
2004: l_state NUMBER;
2005: l_return_status varchar2(1);

Line 2002: l_relation_tbl AK_FLOW_PUB.Region_Relation_Tbl_Type;

1998: l_region_rec AK_FLOW_PUB.Page_Region_Rec_Type;
1999: l_region_tbl AK_FLOW_PUB.Page_Region_Tbl_Type;
2000: l_relation_index NUMBER := 0;
2001: l_relation_rec AK_FLOW_PUB.Region_Relation_Rec_Type;
2002: l_relation_tbl AK_FLOW_PUB.Region_Relation_Tbl_Type;
2003: l_saved_token AK_ON_OBJECTS_PUB.Buffer_Type;
2004: l_state NUMBER;
2005: l_return_status varchar2(1);
2006: l_token AK_ON_OBJECTS_PUB.Buffer_Type;

Line 2111: l_flow_rec := AK_FLOW_PUB.G_MISS_FLOW_REC;

2107: --**** Flow processing (states 0 - 19) ****
2108: if (l_state = 0) then
2109: if (l_token = 'BEGIN') then
2110: --== Clear out previous column data ==--
2111: l_flow_rec := AK_FLOW_PUB.G_MISS_FLOW_REC;
2112: l_state := 1;
2113: else
2114: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2115: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');

Line 2378: l_page_rec := AK_FLOW_PUB.G_MISS_PAGE_REC;

2374: --**** FLOW_PAGE processing (states 20 - 39) ****
2375: elsif (l_state = 20) then
2376: if (l_token is not null) then
2377: --== Clear out previous data ==--
2378: l_page_rec := AK_FLOW_PUB.G_MISS_PAGE_REC;
2379: l_page_rec.page_application_id := to_number(l_token);
2380: l_state := 21;
2381: else
2382: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 2621: l_relation_rec := AK_FLOW_PUB.G_MISS_REGION_RELATION_REC;

2617: --**** FLOW_REGION_RELATION processing (states 40 - 59) ****
2618: elsif (l_state = 40) then
2619: if (l_token is not null) then
2620: --== Clear out previous data ==--
2621: l_relation_rec := AK_FLOW_PUB.G_MISS_REGION_RELATION_REC;
2622: l_relation_rec.foreign_key_name := l_token;
2623: l_state := 41;
2624: else
2625: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 2901: l_region_rec := AK_FLOW_PUB.G_MISS_PAGE_REGION_REC;

2897: --**** FLOW_PAGE_REGION processing (states 100 - 119) ****
2898: elsif (l_state = 100) then
2899: if (l_token is not null) then
2900: --== Clear out previous data ==--
2901: l_region_rec := AK_FLOW_PUB.G_MISS_PAGE_REGION_REC;
2902: l_region_rec.region_application_id := to_number(l_token);
2903: l_state := 101;
2904: else
2905: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 3156: l_item_rec := AK_FLOW_PUB.G_MISS_PAGE_REGION_ITEM_REC;

3152: --**** FLOW_PAGE_REGION_ITEM processing (states 200 - 219) ****
3153: elsif (l_state = 200) then
3154: if (l_token is not null) then
3155: --== Clear out previous data ==--
3156: l_item_rec := AK_FLOW_PUB.G_MISS_PAGE_REGION_ITEM_REC;
3157: l_item_rec.attribute_application_id := to_number(l_token);
3158: l_state := 201;
3159: else
3160: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN